Hi,
> What does "SHOW ENGINE INNODB STATUS" show?
here is the output: ( I skipped some table drawings )
=====================================
120611 20:43:43 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 31 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 12218885, signal count 12217545
Mutex spin waits 0, rounds 147298955, OS waits 7317645
RW-shared spins 9815333, OS waits 4848900; RW-excl spins 54514, OS waits 52340
------------
TRANSACTIONS
------------
Trx id counter 0 34220853
Purge done for trx's n:o < 0 34220853 undo n:o < 0 0
History list length 2
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, process no 4433, OS thread id 139918283429632
MySQL thread id 122752, query id 19674935 localhost root
show engine innodb status
--------
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
562950010 OS file reads, 9307704 OS file writes, 4963497 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 404, seg size 406,
8638712 inserts, 8638712 merged recs, 2735782 merges
Hash table size 17393, used cells 6970, node heap has 14 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 1 633049080
Log flushed up to 1 633049080
Last checkpoint at 1 633049080
0 pending log writes, 0 pending chkp writes
4633291 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 20625296; in additional pool allocated 969472
Buffer pool size 512
Free buffers 0
Database pages 498
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 635994481, created 42139, written 4998703
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
1 read views open inside InnoDB
Main thread process no. 4433, id 139918253975296, state: waiting for server activity
Number of rows inserted 4178715, updated 510655, deleted 0, read 5909132518
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
Received on Mon Jun 11 2012 - 18:49:32 PST