mysql> show processlist; +----+------+-----------------+------+---------+------+--------------------+--------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------------+------+---------+------+--------------------+--------------------------------------------------------+ | 5 | root | 127.0.0.1:50034 | test | Query | 0 | NULL | show processlist | | 36 | root | 127.0.0.1:50328 | test | Query | 930 | Waiting for table | select * from t1 where id = -6248 | | 37 | root | 127.0.0.1:50329 | test | Query | 930 | Waiting for table | drop table if exists t1 | | 38 | root | 127.0.0.1:50330 | test | Query | 930 | Waiting for tables | select * from t1 where id = -8663 | | 39 | root | 127.0.0.1:50331 | test | Query | 930 | Waiting for table | insert ignore into t1(id,name) values (-30361,'29782') | | 40 | root | 127.0.0.1:50332 | test | Query | 930 | Waiting for table | select * from t1 where id = -2188 | +----+------+-----------------+------+---------+------+--------------------+--------------------------------------------------------+ 6 rows in set (0.00 sec) mysql> show innodb status\G *************************** 1. row *************************** Status: ===================================== 071030 12:44:35 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 60 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 147, signal count 126 Mutex spin waits 316, rounds 4520, OS waits 90 RW-shared spins 91, OS waits 45; RW-excl spins 22, OS waits 12 ------------ TRANSACTIONS ------------ Trx id counter 0 161854 Purge done for trx's n:o < 0 161854 undo n:o < 0 0 History list length 16 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, OS thread id 9708 MySQL thread id 5, query id 202523 127.0.0.1 root show innodb status ---TRANSACTION 0 161841, not started, OS thread id 13376 MySQL thread id 40, query id 202362 127.0.0.1 root Waiting for table select * from t1 where id = -2188 ---TRANSACTION 0 161825, not started, OS thread id 4960 MySQL thread id 39, query id 202361 127.0.0.1 root Waiting for table insert ignore into t1(id,name) values (-30361,'29782') ---TRANSACTION 0 161826, not started, OS thread id 15192 MySQL thread id 38, query id 202358 127.0.0.1 root Waiting for tables select * from t1 where id = -8663 ---TRANSACTION 0 161830, not started, OS thread id 5888 MySQL thread id 37, query id 202360 127.0.0.1 root Waiting for table drop table if exists t1 ---TRANSACTION 0 161843, not started, OS thread id 14544 MySQL thread id 36, query id 202363 127.0.0.1 root Waiting for table select * from t1 where id = -6248 -------- FILE I/O -------- I/O thread 0 state: wait Windows aio (insert buffer thread) I/O thread 1 state: wait Windows aio (log thread) I/O thread 2 state: wait Windows aio (read thread) I/O thread 3 state: wait Windows aio (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 120 OS file reads, 5484 OS file writes, 5377 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 34679, used cells 27, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 55589792 Log flushed up to 0 55589792 Last checkpoint at 0 55589792 0 pending log writes, 0 pending chkp writes 5356 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 13231866; in additional pool allocated 176256 Buffer pool size 512 Free buffers 454 Database pages 58 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 22, created 36, written 124 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue Main thread id 13012, state: waiting for server activity Number of rows inserted 2158, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set, 1 warning (0.02 sec)