mysql> show processlist; +------+---------+-----------+------+---------+------+--------------------------+--------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+---------+-----------+------+---------+------+--------------------------+--------------------------------------+ | 3308 | DELAYED | localhost | test | Killed | 214 | NULL | | | 3317 | root | | test | Killed | 214 | Creating delayed handler | insert delayed into t1 values (65) | | 3318 | root | | test | Killed | 214 | got old table | insert delayed into t1 values (77) | | 3319 | root | | test | Killed | 214 | Creating delayed handler | insert delayed into t1 values (-59) | | 3321 | root | | test | Killed | 214 | Creating delayed handler | insert delayed into t1 values (-128) | | 3323 | root | | test | Killed | 214 | Creating delayed handler | insert delayed into t1 values (-113) | | 3325 | DELAYED | localhost | test | Killed | 214 | NULL | | | 3326 | root | | test | Killed | 214 | waiting for delay_list | insert delayed into t1 values (-83) | | 3327 | root | | test | Killed | 214 | waiting for delay_list | insert delayed into t1 values (-77) | | 3328 | root | | test | Killed | 213 | waiting for delay_list | insert delayed into t1 values (-53) | | 3329 | root | | test | Killed | 213 | waiting for delay_list | insert delayed into t1 values (-122) | | 3330 | root | | test | Killed | 212 | waiting for delay_list | insert delayed into t1 values (112) | | 3331 | root | | test | Killed | 212 | waiting for delay_list | insert delayed into t1 values (35) | | 3332 | root | | test | Killed | 211 | waiting for delay_list | insert delayed into t1 values (-79) | | 3333 | root | | test | Killed | 211 | waiting for delay_list | insert delayed into t1 values (-77) | | 3334 | root | | test | Killed | 210 | waiting for delay_list | insert delayed into t1 values (-83) | | 3335 | root | | test | Killed | 210 | waiting for delay_list | insert delayed into t1 values (117) | | 3336 | root | | test | Killed | 209 | waiting for delay_list | insert delayed into t1 values (82) | | 3337 | root | | test | Killed | 209 | waiting for delay_list | insert delayed into t1 values (124) | | 3338 | root | | test | Killed | 208 | waiting for delay_list | insert delayed into t1 values (-126) | | 3339 | root | | test | Killed | 208 | waiting for delay_list | insert delayed into t1 values (-125) | | 3340 | root | | test | Killed | 207 | waiting for delay_list | insert delayed into t1 values (27) | | 3342 | root | | test | Killed | 207 | waiting for delay_list | insert delayed into t1 values (-96) | | 3343 | root | | test | Killed | 206 | waiting for delay_list | insert delayed into t1 values (-89) | | 3344 | root | | test | Killed | 206 | waiting for delay_list | insert delayed into t1 values (28) | | 3345 | root | | test | Killed | 205 | waiting for delay_list | insert delayed into t1 values (-38) | | 3346 | root | | test | Killed | 205 | waiting for delay_list | insert delayed into t1 values (27) | | 3347 | root | | test | Killed | 204 | waiting for delay_list | insert delayed into t1 values (7) | | 3348 | root | | test | Killed | 204 | waiting for delay_list | insert delayed into t1 values (65) | | 3349 | root | | test | Killed | 203 | waiting for delay_list | insert delayed into t1 values (12) | | 3350 | root | | test | Killed | 203 | waiting for delay_list | insert delayed into t1 values (-29) | | 3351 | root | | test | Killed | 202 | waiting for delay_list | insert delayed into t1 values (-4) | | 3365 | root | | test | Sleep | 6 | | NULL | | 3366 | root | | test | Query | 0 | NULL | show processlist | +------+---------+-----------+------+---------+------+--------------------------+--------------------------------------+ 34 rows in set (0.00 sec)