网站访问慢-MySQL负载高（实战）
#无需登陆，非交互查询，可以grep过滤，更直观看结果mysql -uroot -pqiuyuetao -S/data/3306/mysql.sock -e "show full processlist;" |egrep -vi "sleep"
#登陆myslq查看
show full processlist;
IdUser Host dbCommand Time State Info
192 slave 8.8.8.142:39820 NULL Binlog Dump 58982 Has sent all binlog to slave; waiting for binlog to be updatedNULL
194 slave 8.8.8.120:41075 NULL Binlog Dump 58982 Has sent all binlog to slave; waiting for binlog to be updatedNULL
424891 biotherm 8.8.8.46:57861biotherm Query 493 Sending data SELECT * FROM xxx_list WHERE tid = '1112'AND del = 0ORDER BYid
DESCLIMIT 0, 4
424917 biotherm 8.8.8.49:50984biotherm Query 488 Sending data SELECT * FROM xxx_list WHERE tid = '1112'AND del = 0ORDER BYid
DESCLIMIT 0, 4
..............................................
430330 biotherm 8.8.8.42:35982biotherm Query 487 Sending data SELECT * FROM xxx_list WHERE tid = '1112'AND del = 0
页:
[1]