mysql> SHOW ENGINE INNODB STATUS\G *************************** 1. row *************************** Status: ===================================== 070419 20:38:00 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 31 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 100, signal count 100 Mutex spin waits 13, rounds 184, OS waits 1 RW-shared spins 198, OS waits 99; RW-excl spins 0, OS waits 0 ------------ TRANSACTIONS ------------ Trx id counter 0 1598085474 Purge done for trx's n:o < 0 1598085453 undo n:o < 0 0 History list length 22 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, process no 32367, OS thread id 1159256384 MySQL thread id 786, query id 18591 localhost root SHOW ENGINE INNODB STATUS ---TRANSACTION 0 1598085465, not started, process no 32367, OS thread id 1160587584 MySQL thread id 785, query id 18553 web1 10.100.1.102 civicspacelabs_o ---TRANSACTION 0 1598085464, not started, process no 32367, OS thread id 1162451264 MySQL thread id 784, query id 18544 web1 10.100.1.102 civicspacelabs_o ---TRANSACTION 0 0, not started, process no 32367, OS thread id 1159788864 MySQL thread id 781, query id 18523 web1 10.100.1.102 civicspacelabs_o ---TRANSACTION 0 0, not started, process no 32367, OS thread id 1161652544 MySQL thread id 780, query id 18514 web1 10.100.1.102 civicspacelabs_o ---TRANSACTION 0 1598085462, not started, process no 32367, OS thread id 1162983744 MySQL thread id 777, query id 18502 web1 10.100.1.102 civicspacelabs_o -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (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 2972 OS file reads, 2241 OS file writes, 662 OS fsyncs 0.03 reads/s, 16384 avg bytes/read, 0.10 writes/s, 0.03 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 5, seg size 7, is empty Ibuf for space 0: size 1, free list len 5, seg size 7, 53 inserts, 53 merged recs, 53 merges Hash table size 1593833, used cells 4897, node heap has 8 buffer(s) 0.19 hash searches/s, 0.97 non-hash searches/s --- LOG --- Log sequence number 114 1134701118 Log flushed up to 114 1134701118 Last checkpoint at 114 1134700648 0 pending log writes, 0 pending chkp writes 1367 log i/o's done, 0.10 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 927440000; in additional pool allocated 11928064 Buffer pool size 49152 Free buffers 46173 Database pages 2971 Modified db pages 4 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 2961, created 10, written 862 0.03 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 996 / 1000 -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 32367, id 1157658944, state: sleeping Number of rows inserted 418, updated 66, deleted 335, read 37726 0.00 inserts/s, 0.03 updates/s, 0.00 deletes/s, 0.19 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================