摘要:
Mysql开启慢sql 开启 # 查看慢SQL是否启用 show variables like 'slow_query_log'; # 开启慢查询命令 set global slow_query_log = on; # 查看慢查询参数,即设置超过多少秒的查询归为了慢查询。参数为:long_query 阅读全文
摘要:
MySQL查看所有连接的客户端ip sql SELECT substring_index(host, ':',1) AS host_name,state,count(*) FROM information_schema.processlist GROUP BY state,host_name; 阅读全文