This is patch is port from Goolge patches V2. Patch depends on [[ patches:innodb_fsync_source ]] and [[ patches:innodb_io_tune ]] 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