This is patch is port from Goolge patches V2.

Patch depends on innodb_fsync_source and innodb_io_tune

Patch adds configuration variable

Patch adds next status variables into SHOW STATUS output (sample output):

Innodb_dict_size 86832
Innodb_long_lock_wait OFF
Innodb_long_lock_waits 0
Innodb_os_read_requests 255
Innodb_os_write_requests 618
Innodb_os_pages_read 15441
Innodb_os_pages_written 29564
Innodb_os_read_time 25826437
Innodb_os_write_time 24080782
Innodb_time_per_read 101280
Innodb_time_per_write 38965
Innodb_deadlocks 0
Innodb_transaction_count 49921
Innodb_transaction_purge_count 49536
Innodb_transaction_purge_lag 5
Innodb_active_transactions 0
Innodb_summed_transaction_age 0
Innodb_longest_transaction_age 0
Innodb_lock_wait_timeouts 0
Innodb_lock_waiters 0
Innodb_summed_lock_wait_time 0
Innodb_longest_lock_wait 0
Innodb_pending_normal_aio_reads 0
Innodb_pending_normal_aio_writes 0
Innodb_pending_ibuf_aio_reads 0
Innodb_pending_log_ios 0
Innodb_pending_sync_ios 0
Innodb_os_reads 537
Innodb_os_writes 1726
Innodb_os_fsyncs 1024
Innodb_ibuf_inserts 1
Innodb_ibuf_size 120
Innodb_ibuf_merged_recs 120
Innodb_ibuf_merges 1
Innodb_log_ios_done 390

And information about main innodb thread in SHOW INNODB STATUS, BACKGROUND THREAD section

----------
BACKGROUND THREAD
----------
srv_master_thread loops: 0 1_second, 0 sleeps, 12 10_second, 79 background, 79 flush
srv_master_thread log flush: 122 sync, 124 async
 
patches/innodb_extra_status.txt · Last modified: 2010/03/21 06:56 (external edit)
 
Except where otherwise noted, content on this wiki is licensed under the following license:GNU Free Documentation License 1.2
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki