Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement