mysql 日志相关命令

 

 

show variables like '%general_log%';
set GLOBAL general_log ='ON'
show variables	like '%general%';
show VARIABLES like '%out%';
set global log_output='TABLE';
show VARIABLES like '%slow%';
set GLOBAL LOG_slow_queries='on'
show VARIABLES like '%long%';
set long_query_time = 0.5
select 11;
select	sleep(11);
select * from mysql.general_log \G
select * from mysql.slow_log \G