The general query log is a general record of what mysqld is doing. The server writes information to this log when clients connect or disconnect, and it logs each SQL statement received from clients. The general query log can be very useful when you suspect an error in a client and want to know exactly what the client sent to mysqld.
Older versions of the mysql.server script (from
MySQL 3.23.4 to 3.23.8) pass a
--log
option to
safe_mysqld to enable the general query log. If
you need better performance when you start using MySQL in a
production environment, you can remove the
--log
option from
mysql.server or change it to
--log-bin
. See
Section 5.3.4, “The Binary Log”.
mysqld writes statements to the query log in the order that it receives them, which might differ from the order in which they are executed. This logging order contrasts to the update log and the binary log, which are written after the query is executed but before any locks are released. (Also, the query log contains all statements, whereas the update and binary logs do not contain statements that only select data.)
To enable the general query log, start mysqld
with the
--log[=
or file_name
]-l [
option.
file_name
]
If no file_name
value is given for
--log
or -l
, the
default name is
. The
server creates the file in the data directory unless an absolute
path name is given to specify a different directory.
host_name
.log
Server restarts and log flushing do not cause a new general query log file to be generated (although flushing closes and reopens it). On Unix, you can rename the file and create a new one by using the following commands:
shell>mv
shell>host_name
.loghost_name
-old.logmysqladmin flush-logs
shell>cp
shell>host_name
-old.logbackup-directory
rm
host_name
-old.log
On Windows, you cannot rename the log file while the server has it open. You must stop the server and rename the file, and then restart the server to create a new log file.
The session sql_log_off
variable
can be set to ON
or OFF
to
disable or enable general query logging for the current
connection.
The general query log should be protected because logged statements might contain passwords. See Section 5.4.2.1, “Administrator Guidelines for Password Security”.
User Comments
Add your own comment.