标签：slow log show variables 问题 排查 MySql query like
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%';
标签：slow,
log,
show,
variables,
问题,
排查,
MySql,
query,
like
From： https://www.cnblogs.com/kikyoqiang/p/17007047.html