mysql> show processlist; +-----+---------+--------------------+------+----------------+------+--------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+---------+--------------------+------+----------------+------+--------------------------+------------------------------------------------------------------------------------------------------+ | 2 | root | 127.0.0.1:34982 | test | Query | 439 | Waiting for table | select `id`,`name` from `bug` where `add1` = 'stratagem\'s' or `add2` = 'greenhouse' | | 3 | root | 127.0.0.1:34983 | test | Query | 439 | waiting for delay_list | insert delayed into `bug_2`(`name`,`add1`,`add2`) values ('Rhynd','eyedropper','alacks'),('dissects' | | 4 | root | 127.0.0.1:34984 | test | Query | 439 | Waiting for table | alter table `bug` disable keys | | 5 | root | 127.0.0.1:34985 | test | Query | 439 | setup | alter table `bug_2` disable keys | | 6 | root | 127.0.0.1:34986 | test | Query | 439 | closing tables | select `id`,`name` from `bug` where `add1` = 'partied' or `add2` = 'moggie' | | 7 | root | 127.0.0.1:34987 | test | Query | 439 | NULL | flush tables | | 8 | root | 127.0.0.1:34988 | test | Query | 439 | waiting for delay_list | insert delayed into `bug_2`(`name`,`add1`,`add2`) values ('Rhynd','eyedropper','alacks'),('dissects' | | 9 | root | 127.0.0.1:34989 | test | Query | 439 | waiting for delay_list | insert delayed into `bug_2`(`name`,`add1`,`add2`) values ('Rhynd','eyedropper','alacks'),('dissects' | | 11 | root | 127.0.0.1:34990 | test | Query | 439 | waiting for delay_list | insert delayed into `bug_2`(`name`,`add1`,`add2`) values ('Rhynd','eyedropper','alacks'),('dissects' | | 13 | root | 127.0.0.1:34991 | test | Query | 439 | Opening table | alter table `bug_2` enable keys | | 14 | root | 127.0.0.1:34992 | test | Query | 439 | waiting for delay_list | insert delayed into `bug_2`(`name`,`add1`,`add2`) values ('Rhynd','eyedropper','alacks'),('dissects' | | 15 | root | 127.0.0.1:34993 | test | Query | 439 | waiting for delay_list | insert delayed into `bug_2`(`name`,`add1`,`add2`) values ('Rhynd','eyedropper','alacks'),('dissects' | | 16 | root | 127.0.0.1:34994 | test | Query | 439 | Opening table | alter table `bug` disable keys | | 17 | root | 127.0.0.1:34995 | test | Query | 440 | waiting for handler lock | insert delayed into `bug_2`(`name`,`add1`,`add2`) values ('Rhynd','eyedropper','alacks'),('dissects' | | 18 | root | 127.0.0.1:34996 | test | Query | 439 | waiting for delay_list | insert delayed into `bug_2`(`name`,`add1`,`add2`) values ('Rhynd','eyedropper','alacks'),('dissects' | | 19 | root | 127.0.0.1:34997 | test | Query | 439 | Opening table | alter table `bug_2` disable keys | | 20 | root | 127.0.0.1:34998 | test | Query | 439 | Opening tables | select `id`,`name` from `bug_2` where `add1` = 'fasted' or `add2` = 'protestation' | | 21 | root | 127.0.0.1:34999 | test | Query | 439 | Opening tables | select `id`,`name` from `bug_2` where `add1` = 'adjustable' or `add2` = 'brouhaha\'s' | | 22 | root | 127.0.0.1:35000 | test | Query | 439 | Opening table | alter table `bug_2` disable keys | | 23 | root | 127.0.0.1:35001 | test | Query | 440 | waiting for delay_list | insert delayed into `bug_2`(`name`,`add1`,`add2`) values ('Rhynd','eyedropper','alacks'),('dissects' | | 24 | root | 127.0.0.1:35002 | test | Query | 439 | Flushing tables | flush tables | | 25 | root | 127.0.0.1:35003 | test | Query | 439 | Flushing tables | flush tables | | 26 | root | 127.0.0.1:35004 | test | Query | 439 | waiting for delay_list | insert delayed into `bug_2`(`name`,`add1`,`add2`) values ('Rhynd','eyedropper','alacks'),('dissects' | | 28 | root | 127.0.0.1:35005 | test | Query | 439 | waiting for delay_list | insert delayed into `bug_2`(`name`,`add1`,`add2`) values ('Rhynd','eyedropper','alacks'),('dissects' | | 29 | root | 127.0.0.1:35006 | test | Query | 439 | Opening tables | select `id`,`name` from `bug_2` where `add1` = 'dislimn' or `add2` = 'Boas\'s' | | 142 | root | 192.168.250.3:2809 | NULL | Query | 0 | NULL | show processlist | | 258 | DELAYED | | test | Delayed_insert | 440 | Locked | | +-----+---------+--------------------+------+----------------+------+--------------------------+------------------------------------------------------------------------------------------------------+ 27 rows in set (0.00 sec) mysql> select version(); +-----------------+ | version() | +-----------------+ | 4.0.27-standard | +-----------------+