GNU Info

Info Node: (mysql.info)Query log

(mysql.info)Query log


Next: Update log Prev: Error log Up: Log Files
Enter node , (file) or (file)node

The General Query Log
---------------------

If you want to know what happens within `mysqld', you should start it
with `--log[=file]'.  This will log all connections and queries to the
log file (by default named `'hostname'.log').  This log can be very
useful when you suspect an error in a client and want to know exactly
what `mysqld' thought the client sent to it.

By default, the `mysql.server' script starts the MySQL server with the
`-l' option.  If you need better performance when you start using MySQL
in a production environment, you can remove the `-l' option from
`mysql.server' or change it to `--log-bin'.

The entries in this log are written as `mysqld' receives the questions.
This may be different than the order in which the statements are
executed.  This is in contrast to the update log and the binary log
which are written after the query is executed, but before any locks are
released.


automatically generated by info2www version 1.2.2.9