Tuesday, May 10, 2016

Show query log in MySQL

SET global general_log = 'ON';
#SET global general_log = 'OFF';

#SET global log_output = 'TABLE';
SET global log_output = 'FILE';

SHOW VARIABLES WHERE variable_name REGEXP 'general_log|log_output' ;

SELECT * FROM mysql.general_log;

No comments: