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;
Tuesday, May 10, 2016
Show query log in MySQL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment