Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4481 Server version: 5.1.57 Source distribution Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> SHOW ENGINE INNODB STATUS\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 110729 13:41:07 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 9 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 24619, signal count 23988 Mutex spin waits 0, rounds 540680, OS waits 10342 RW-shared spins 22990, OS waits 11213; RW-excl spins 3448, OS waits 3060 ------------ TRANSACTIONS ------------ Trx id counter 0 26799358 Purge done for trx's n:o < 0 26799349 undo n:o < 0 0 History list length 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, process no 1069, OS thread id 2966018928 MySQL thread id 4481, query id 7009661 localhost root SHOW ENGINE INNODB STATUS ---TRANSACTION 0 26782205, not started, process no 1069, OS thread id 2966219632 MySQL thread id 3771, query id 6980932 localhost mythtv ---TRANSACTION 0 26799356, not started, process no 1069, OS thread id 2966420336 MySQL thread id 924, query id 7009660 localhost mythtv ---TRANSACTION 0 26799352, not started, process no 1069, OS thread id 3012651888 MySQL thread id 564, query id 7009632 localhost mythtv ---TRANSACTION 0 26777606, not started, process no 1069, OS thread id 3013053296 MySQL thread id 7, query id 6964170 localhost mythtv ---TRANSACTION 0 26799354, not started, process no 1069, OS thread id 3013254000 MySQL thread id 6, query id 7009642 localhost mythtv ---TRANSACTION 0 26799355, not started, process no 1069, OS thread id 3013454704 MySQL thread id 5, query id 7009651 localhost mythtv ---TRANSACTION 0 26799353, not started, process no 1069, OS thread id 3013856112 MySQL thread id 4, query id 7009639 localhost mythtv ---TRANSACTION 0 26799357, not started, process no 1069, OS thread id 3013655408 MySQL thread id 3, query id 7009659 localhost mythtv -------- 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 1521047 OS file reads, 586771 OS file writes, 460443 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: size 1, free list len 5, seg size 7, 65316 inserts, 65316 merged recs, 3336 merges Hash table size 34679, node heap has 12 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 1 2779289259 Log flushed up to 1 2779289259 Last checkpoint at 1 2779289259 0 pending log writes, 0 pending chkp writes 427939 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 24984714; in additional pool allocated 1048064 Dictionary memory allocated 537240 Buffer pool size 512 Free buffers 1 Database pages 499 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 2381334, created 16536, written 180842 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 1069, id 2976263024, state: waiting for server activity Number of rows inserted 610797, updated 234559, deleted 464411, read 365518858 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 (0.08 sec) mysql>