mysql查看日志

show variables like'%log%'

show status like '%thread%';

show global variables like '%time%';

show variables like '%time%';  

设置general_log

SET GLOBAL log_output=FILE; 
SET GLOBAL general_log_file='/usr/local/mysql/data/general.log'; 
SET GLOBAL general_log=ON; SHOW GLOBAL VARIABLES LIKE '%log%';