mysql>showprocesslist;+------+------+-----------+------+---------+------+----------+--------------------------------------------------------------------------------------...
mysql> show processlist;
+------+------+-----------+------+---------+------+----------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+------+-----------+------+---------+------+----------+------------------------------------------------------------------------------------------------------+
| 1795 | root | localhost | NULL | Query | 0 | NULL | show processlist |
| 4128 | root | localhost | mysqler | Query | 6 | Updating | UPDATE zyads_stats SET clicks=clicks+1 WHERE zoneid = '26706' AND adsid = '1660' |
| 4129 | root | localhost | mysqler | Query | 6 | Locked | INSERT INTO zyads_stats (num,deduction,day,planid,adsid,zoneid,plantype,siteid,uid,adstypeid,linkuid |
| 4134 | root | localhost | mysqler | Query | 6 | Locked | INSERT INTO zyads_stats (num,deduction,day,planid,adsid,zoneid,plantype,siteid,uid,adstypeid,linkuid |
| 4137 | root | localhost | mysqler | Query | 5 | Locked | INSERT INTO zyads_stats (num,deduction,day,planid,adsid,zoneid,plantype,siteid,uid,adstypeid,linkuid |
| 4140 | root | localhost | mysqler | Query | 5 | Locked | INSERT INTO zyads_stats (num,deduction,day,planid,adsid,zoneid,plantype,siteid,uid,adstypeid,linkuid |
| 4141 | root | localhost | mysqler | Query | 5 | Locked | INSERT INTO zyads_stats (num,deduction,day,planid,adsid,zoneid,plantype,siteid,uid,adstypeid,linkuid |
| 4143 | root | localhost | mysqler | Query | 5 | Locked | INSERT INTO zyads_stats (num,deduction,day,planid,adsid,zoneid,plantype,siteid,uid,adstypeid,linkuid |
| 4144 | root | localhost | mysqler | Query | 5 | Locked | INSERT INTO zyads_stats (num,deduction,day,planid,adsid,zoneid,plantype,siteid,uid,adstypeid,linkuid |
| 4145 | root | localhost | mysqler | Query | 5 | Locked | UPDATE zyads_stats SET clicks=clicks+1 WHERE zoneid = '27717' AND adsid = '1660'
展开