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