mysql> show global status like 'inno%'; +-----------------------------------+----------------------+ | Variable_name | Value | +-----------------------------------+----------------------+ | Innodb_buffer_pool_pages_data | 12799 | | Innodb_buffer_pool_pages_dirty | 8619 | | Innodb_buffer_pool_pages_flushed | 1717921 | | Innodb_buffer_pool_pages_free | 0 | | Innodb_buffer_pool_pages_latched | 0 | | Innodb_buffer_pool_pages_misc | 1 | | Innodb_buffer_pool_pages_total | 12800 | | Innodb_buffer_pool_read_ahead_rnd | 98 | | Innodb_buffer_pool_read_ahead_seq | 0 | | Innodb_buffer_pool_read_requests | 94544218 | | Innodb_buffer_pool_reads | 212945 | | Innodb_buffer_pool_wait_free | 0 | | Innodb_buffer_pool_write_requests | 28428157 | | Innodb_data_fsyncs | 66573 | | Innodb_data_pending_fsyncs | 0 | | Innodb_data_pending_reads | 0 | | Innodb_data_pending_writes | 0 | | Innodb_data_read | 3536617472 | | Innodb_data_reads | 215858 | | Innodb_data_writes | 1772983 | | Innodb_data_written | 2347691008 | | Innodb_dblwr_pages_written | 1717748 | | Innodb_dblwr_writes | 22360 | | Innodb_log_waits | 0 | | Innodb_log_write_requests | 4658135 | | Innodb_log_writes | 17794 | | Innodb_os_log_fsyncs | 19524 | | Innodb_os_log_pending_fsyncs | 0 | | Innodb_os_log_pending_writes | 0 | | Innodb_os_log_written | 1890713088 | | Innodb_page_size | 16384 | | Innodb_pages_created | 52617 | | Innodb_pages_read | 215858 | | Innodb_pages_written | 1717921 | | Innodb_row_lock_current_waits | 0 | | Innodb_row_lock_time | 18446744073709551517 | | Innodb_row_lock_time_avg | 1561806280 | | Innodb_row_lock_time_max | 3133607239 | | Innodb_row_lock_waits | 11 | | Innodb_rows_deleted | 617738 | | Innodb_rows_inserted | 1851359 | | Innodb_rows_read | 34395666 | | Innodb_rows_updated | 0 | +-----------------------------------+----------------------+ 43 rows in set (0.00 sec) mysql> show innodb status\G *************************** 1. row *************************** Status: ===================================== 061026 16:21:29 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 47 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 14443, signal count 14419 Mutex spin waits 0, rounds 0, OS waits 0 RW-shared spins 15568, OS waits 10681; RW-excl spins 3921, OS waits 3762 ------------ TRANSACTIONS ------------ Trx id counter 0 1794548 Purge done for trx's n:o < 0 1043934 undo n:o < 0 0 History list length 3 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 740106, not started, OS thread id 4532 MySQL thread id 5, query id 1857777 localhost 127.0.0.1 root show innodb status ---TRANSACTION 0 1794547, ACTIVE 0 sec, OS thread id 1316 inserting, thread declared inside InnoDB mysql tables in use 1, locked 1 2 lock struct(s), heap size 368 MySQL thread id 50, query id 1857776 mail.mysql.com 10.100.1.21 root update INSERT IGNORE INTO `xxxxxx`(`xxxxx`,`xxxxxx`,<cut> -------- 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: 30, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 216146 OS file reads, 1773985 OS file writes, 66605 OS fsyncs 47.42 reads/s, 16384 avg bytes/read, 136.15 writes/s, 5.13 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 3, free list len 1, seg size 5, is not empty Ibuf for space 0: size 3, free list len 1, seg size 5, 1460 inserts, 1087 merged recs, 512 merges Hash table size 415141, used cells 0, node heap has 1 buffer(s) 0.00 hash searches/s, 456.29 non-hash searches/s --- LOG --- Log sequence number 0 1882267179 Log flushed up to 0 1882267179 Last checkpoint at 0 1875481814 0 pending log writes, 0 pending chkp writes 20834 log i/o's done, 1.55 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 440509594; in additional pool allocated 486400 Buffer pool size 12800 Free buffers 0 Database pages 12799 Modified db pages 8456 Pending reads 0 Pending writes: LRU 0, flush list 31, single page 0 Pages read 216146, created 52631, written 1718864 47.42 reads/s, 2.43 creates/s, 131.27 writes/s Buffer pool hit rate 972 / 1000 -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread id 4544, state: sleeping Number of rows inserted 1851838, updated 0, deleted 617738, read 34395666 74.06 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.00 sec)