]]>
Call us: 1-888-316-9775 • Contact Us
MySQL and InnoDB are trademarks of Oracle Corp.
Proudly running Percona Server
Copyright © 2006-2013 Percona Inc.
Copyright, Trademark, and Privacy Policy • Sitemap
]]>
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
Except where otherwise noted, content on this wiki is licensed under the following license:CC Attribution-Noncommercial-Share Alike 3.0 Unported
