每日一句优化sql之慢sql查询
如题
select concat('运行时间',TIME,'s \nSQL:\n',INFO) as msg from INFORMATION_SCHEMA.PROCESSLIST where db = 'xjd' and COMMAND != 'Sleep' and TIME >= 3;
select concat('运行时间',TIME,'s \nSQL:\n',INFO) as msg from INFORMATION_SCHEMA.PROCESSLIST where db = 'xjd' and COMMAND != 'Sleep' and TIME >= 3;