Thursday, June 12, 2014

MySQL Query Log

Turn on query log permanently, eidt my.ini:

[mysqld]

log

Turn on query log at runtime:

SET GLOBAL general_log = 'ON';
SET GLOBAL general_log = 'OFF';

Note: use the "FLUSH LOGS" command to flush the logs from memory to the log file.

No comments: