]]>
]]>

This is patch is port from Goolge patches V2.

Patch depends on innodb_fsync_source and !!! Patch is deprecated and is not available in percona builds !!!

Patch adds configuration variable

  • innodb_status_update_interval (default 30), this is minimal interval when InnoDB updates counters shown in SHOW [GLOBAL] STATUS command.

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: 2011/07/17 21:05 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license:CC Attribution-Noncommercial-Share Alike 3.0 Unported
Contact Us 24 Hours A Day
SupportContact us 24×7
Emergency? Contact us for help now!
Sales North America(888) 316-9775 or
(208) 473-2904
Sales
Europe
+44-208-133-0309 (UK)
0-800-051-8984 (UK)
0-800-181-0665 (GER)
Training(855) 55TRAIN or
(925) 271-5054

 

Share This
]]> ]]>