showvariableslike'%slow%';
showvariableslike'%log_output%';
或
select@@global.log_output;
set@@global.log_output='TABLE';
showvariableslike'%long_query_time%'; 最长查询时间
set@@long_query_time=2;
select*frommysql.slow_log;
参考: http://blog.itpub.net/23490154/viewspace-1063856/