mysql> show full processlist; +----+---------+------+------+----------------+------+--------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+---------+------+------+----------------+------+--------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 2 | root | | test | Query | 659 | NULL | select `id`,`name` from `bug` where `add1` = 'partied' or `add2` = 'moggie' | | 3 | root | | test | Query | 659 | Creating delayed handler | insert delayed into `bug`(`name`,`add1`,`add2`) values ('magnetoelectricity\'s','creditable','fashioners'),('spongin\'s','initiatory','slumbrous'),('Fong','pointelles','Maitreya\'s'),('albatross\'s','authenticator','Gibeon'),('sienna\'s','diluter','Basque') | | 4 | root | | test | Query | 659 | Waiting for table | select `id`,`name` from `bug` where `add1` = 'squawkers' or `add2` = 'Beatty\'s' | | 5 | root | | test | Query | 659 | Waiting for table | select `id`,`name` from `bug` where `add1` = 'squawkers' or `add2` = 'Beatty\'s' | | 6 | root | | test | Query | 659 | Waiting for table | select `id`,`name` from `bug_2` where `add1` = 'dislimn' or `add2` = 'Boas\'s' | | 7 | root | | test | Query | 659 | NULL | select `id`,`name` from `bug` where `add1` = 'partied' or `add2` = 'moggie' | | 8 | root | | test | Query | 659 | NULL | select `id`,`name` from `bug` where `add1` = 'heckler' or `add2` = 'turbid' | | 9 | root | | test | Query | 659 | waiting for handler lock | insert delayed into `bug`(`name`,`add1`,`add2`) values ('magnetoelectricity\'s','creditable','fashioners'),('spongin\'s','initiatory','slumbrous'),('Fong','pointelles','Maitreya\'s'),('albatross\'s','authenticator','Gibeon'),('sienna\'s','diluter','Basque') | | 10 | root | | test | Query | 659 | Flushing tables | flush tables | | 11 | root | | test | Query | 659 | waiting for handler open | insert delayed into `bug_2`(`name`,`add1`,`add2`) values ('Rhynd','eyedropper','alacks'),('dissects','Aquarius\'s','Sorel'),('Delano','acetylide','toboggans'),('frightfulness\'s','stratus','cloggier'),('remembrance','filleter','definitions') | | 12 | root | | test | Query | 659 | NULL | flush tables | | 13 | root | | test | Query | 659 | NULL | flush tables | | 14 | root | | test | Query | 659 | Waiting for tables | alter table `bug` enable keys | | 15 | root | | test | Query | 659 | waiting for handler lock | insert delayed into `bug`(`name`,`add1`,`add2`) values ('magnetoelectricity\'s','creditable','fashioners'),('spongin\'s','initiatory','slumbrous'),('Fong','pointelles','Maitreya\'s'),('albatross\'s','authenticator','Gibeon'),('sienna\'s','diluter','Basque') | | 16 | root | | test | Query | 659 | setup | alter table `bug` enable keys | | 17 | root | | test | Query | 659 | Waiting for tables | alter table `bug` enable keys | | 18 | root | | test | Query | 659 | Waiting for table | select `id`,`name` from `bug` where `add1` = 'partied' or `add2` = 'moggie' | | 20 | root | | test | Query | 659 | Waiting for table | select `id`,`name` from `bug_2` where `add1` = 'dislimn' or `add2` = 'Boas\'s' | | 21 | root | | test | Query | 659 | NULL | select `id`,`name` from `bug` where `add1` = 'squawkers' or `add2` = 'Beatty\'s' | | 22 | root | | test | Query | 659 | Waiting for table | select `id`,`name` from `bug` where `add1` = 'Malathion\'s' or `add2` = 'destruction\'s' | | 24 | root | | test | Query | 659 | Waiting for tables | alter table `bug` enable keys | | 25 | root | | test | Query | 659 | Creating delayed handler | insert delayed into `bug`(`name`,`add1`,`add2`) values ('magnetoelectricity\'s','creditable','fashioners'),('spongin\'s','initiatory','slumbrous'),('Fong','pointelles','Maitreya\'s'),('albatross\'s','authenticator','Gibeon'),('sienna\'s','diluter','Basque') | | 26 | root | | test | Query | 659 | NULL | flush tables | | 27 | root | | test | Query | 659 | NULL | flush tables | | 29 | root | | test | Query | 659 | Waiting for table | select `id`,`name` from `bug` where `add1` = 'Malathion\'s' or `add2` = 'destruction\'s' | | 41 | DELAYED | | test | Killed | 659 | NULL | | | 42 | DELAYED | | test | Killed | 659 | Waiting for tables | | | 43 | DELAYED | | test | Delayed insert | 659 | Opening table | | | 44 | root | | test | Query | 0 | NULL | show full processlist | +----+---------+------+------+----------------+------+--------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 29 rows in set (0.00 sec)