MySql 问题排查

1、

service mysqld restart
SET GLOBAL event_scheduler = OFF;
show variables like 'slow_query_log';
-- set global slow_query_log='ON';
show variables like 'slow_query_log_file';
-- set global slow_query_log_file='/var/lib/mysql/slow_query.log';
select a.TIME, a.* from information_schema.processlist a where 1=1
and DB='ym' 
-- and command='Query'
ORDER BY command asc, a.TIME desc
show variables like '%character%';