mysql> show status where value is not NULL and value > 0; +-----------------------------------+-------------+ | Variable_name | Value | +-----------------------------------+-------------+ | Aborted_clients | 18 | | Aborted_connects | 8 | | Binlog_cache_use | 1 | | Bytes_received | 153 | | Bytes_sent | 158 | | Com_select | 1 | | Com_show_status | 1 | | Connections | 373919 | | Created_tmp_files | 5 | | Flush_commands | 1 | | Innodb_buffer_pool_pages_data | 57368 | | Innodb_buffer_pool_pages_dirty | 34 | | Innodb_buffer_pool_pages_flushed | 781370 | | Innodb_buffer_pool_pages_free | 71386 | | Innodb_buffer_pool_pages_misc | 2317 | | Innodb_buffer_pool_pages_total | 131071 | | Innodb_buffer_pool_read_ahead_rnd | 107 | | Innodb_buffer_pool_read_ahead_seq | 518 | | Innodb_buffer_pool_read_requests | 4654468237 | | Innodb_buffer_pool_reads | 38518 | | Innodb_buffer_pool_write_requests | 11064471 | | Innodb_data_fsyncs | 307243 | | Innodb_data_read | 891424768 | | Innodb_data_reads | 45190 | | Innodb_data_writes | 807464 | | Innodb_data_written | 26130312704 | | Innodb_dblwr_pages_written | 781370 | | Innodb_dblwr_writes | 25601 | | Innodb_log_write_requests | 991206 | | Innodb_log_writes | 143626 | | Innodb_os_log_fsyncs | 156239 | | Innodb_os_log_written | 519873536 | | Innodb_page_size | 16384 | | Innodb_pages_created | 3094 | | Innodb_pages_read | 54275 | | Innodb_pages_written | 781370 | | Innodb_row_lock_time | 1641 | | Innodb_row_lock_time_avg | 38 | | Innodb_row_lock_time_max | 404 | | Innodb_row_lock_waits | 43 | | Innodb_rows_deleted | 113069 | | Innodb_rows_inserted | 245552 | | Innodb_rows_read | 5731965165 | | Innodb_rows_updated | 632014 | | Key_blocks_unused | 319655 | | Key_blocks_used | 17899 | | Key_read_requests | 72524430 | | Key_reads | 280913 | | Key_write_requests | 27574424 | | Key_writes | 72290 | | Max_used_connections | 28 | | Open_files | 43 | | Open_table_definitions | 149 | | Open_tables | 64 | | Opened_files | 507064 | | Qcache_free_blocks | 2124 | | Qcache_free_memory | 18190568 | | Qcache_hits | 2727723 | | Qcache_inserts | 1971639 | | Qcache_lowmem_prunes | 118446 | | Qcache_not_cached | 289771 | | Qcache_queries_in_cache | 6462 | | Qcache_total_blocks | 15291 | | Queries | 8617082 | | Questions | 2 | | Table_locks_immediate | 5989091 | | Table_locks_waited | 1450 | | Threads_cached | 6 | | Threads_connected | 3 | | Threads_created | 850 | | Threads_running | 1 | | Uptime | 128596 | | Uptime_since_flush_status | 128596 | +-----------------------------------+-------------+ mysql> show engine innodb status; | InnoDB | | ===================================== 090430 11:01:34 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 8 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 57120, signal count 391776 Mutex spin waits 10883795, rounds 8917227, OS waits 16784 RW-shared spins 354778, OS waits 17810; RW-excl spins 70483, OS waits 14158 Spin rounds per wait: 0.82 mutex, 4.52 RW-shared, 12.49 RW-excl -------- 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 (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (read thread) I/O thread 7 state: waiting for i/o request (read thread) I/O thread 8 state: waiting for i/o request (read thread) I/O thread 9 state: waiting for i/o request (read thread) I/O thread 10 state: waiting for i/o request (read thread) I/O thread 11 state: waiting for i/o request (read thread) I/O thread 12 state: waiting for i/o request (read thread) I/O thread 13 state: waiting for i/o request (read thread) I/O thread 14 state: waiting for i/o request (read thread) I/O thread 15 state: waiting for i/o request (read thread) I/O thread 16 state: waiting for i/o request (read thread) I/O thread 17 state: waiting for i/o request (read thread) I/O thread 18 state: waiting for i/o request (write thread) I/O thread 19 state: waiting for i/o request (write thread) I/O thread 20 state: waiting for i/o request (write thread) I/O thread 21 state: waiting for i/o request (write thread) I/O thread 22 state: waiting for i/o request (write thread) I/O thread 23 state: waiting for i/o request (write thread) I/O thread 24 state: waiting for i/o request (write thread) I/O thread 25 state: waiting for i/o request (write thread) I/O thread 26 state: waiting for i/o request (write thread) I/O thread 27 state: waiting for i/o request (write thread) I/O thread 28 state: waiting for i/o request (write thread) I/O thread 29 state: waiting for i/o request (write thread) I/O thread 30 state: waiting for i/o request (write thread) I/O thread 31 state: waiting for i/o request (write thread) I/O thread 32 state: waiting for i/o request (write thread) I/O thread 33 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 45201 OS file reads, 816322 OS file writes, 310483 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.87 writes/s, 0.87 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 2039 inserts, 2039 merged recs, 1480 merges Hash table size 4425293, node heap has 2316 buffer(s) 710.54 hash searches/s, 636.42 non-hash searches/s --- LOG --- Log sequence number 1714920054 Log flushed up to 1714919574 Last checkpoint at 1714906765 Max checkpoint age 7782360 Modified age 13289 Checkpoint age 13289 0 pending log writes, 0 pending chkp writes 157977 log i/o's done, 0.87 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 2197815296; in additional pool allocated 0 Internal hash tables (constant factor + variable factor) Adaptive hash index 73351896 (35402344 + 37949552) Page hash 2213656 Dictionary cache 9462320 (8851984 + 610336) File system 118288 (82672 + 35616) Lock system 5314152 (5313416 + 736) Recovery system 0 (0 + 0) Threads 409976 (406936 + 3040) Dictionary memory allocated 610336 Buffer pool size 131071 Buffer pool size, bytes 2147467264 Free buffers 71361 Database pages 57394 Modified db pages 27 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 54286, created 3109, written 789675 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000 LRU len: 57394, unzip_LRU len: 0 I/O sum[260]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 19805, id 1414224208, state: sleeping Number of rows inserted 248427, updated 637423, deleted 114195, read 5773482532 1.25 inserts/s, 3.25 updates/s, 0.00 deletes/s, 5453.07 reads/s