通过查询服务端有哪些连接,和它们的响应耗时等,然后主动kill一些有问题的连接:https://blog.csdn.net/u014012924/article/details/120441318;
show full processlist和kill $id
还有:
select id, user, host,db, command, time, state, info
from information_schema.processlist
order by time desc;
通过查询服务端有哪些连接,和它们的响应耗时等,然后主动kill一些有问题的连接:https://blog.csdn.net/u014012924/article/details/120441318;
show full processlist和kill $id
还有:
select id, user, host,db, command, time, state, info
from information_schema.processlist
order by time desc;