mysql 表监控_mysql 5.6性能监控表innodb_metrics

最新推荐文章于 2024-05-24 01:00:51 发布
最新推荐文章于 2024-05-24 01:00:51 发布
阅读量402 收藏
点赞数
文章标签： mysql 表监控
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_34847632/article/details/113148009
版权

前言

oracle有dba_hist_active_session_history,mysql自5.6也提供性能监控指标表innodb_metrics,可以定制监控多种不同监控类别；如何使用得当，对于mysql

性能评估，比如锁的占用分析，事务的吞吐量，元数据的性能，操作系统读写的性能，服务器的性能，不一而足。

操作明细

```scala

1，innodb_metrics表

mysql> desc information_schema.innodb_metrics;

+-----------------+--------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-----------------+--------------+------+-----+---------+-------+

| NAME | varchar(193) | NO | | | |

| SUBSYSTEM | varchar(193) | NO | | | |

| COUNT | bigint(21) | NO | | 0 | |

| MAX_COUNT | bigint(21) | YES | | NULL | |

| MIN_COUNT | bigint(21) | YES | | NULL | |

| AVG_COUNT | double | YES | | NULL | |

| COUNT_RESET | bigint(21) | NO | | 0 | |

| MAX_COUNT_RESET | bigint(21) | YES | | NULL | |

| MIN_COUNT_RESET | bigint(21) | YES | | NULL | |

| AVG_COUNT_RESET | double | YES | | NULL | |

| TIME_ENABLED | datetime | YES | | NULL | |

| TIME_DISABLED | datetime | YES | | NULL | |

| TIME_ELAPSED | bigint(21) | YES | | NULL | |

| TIME_RESET | datetime | YES | | NULL | |

| STATUS | varchar(193) | NO | | | |

| TYPE | varchar(193) | NO | | | |

| COMMENT | varchar(193) | NO | | | |

+-----------------+--------------+------+-----+---------+-------+

17 rows in set (0.04 sec)

2，表的数据，非常有价值，可用于监控分析

mysql> select * from information_schema.innodb_metrics;

+------------------------------------------+---------------------+-------------+-------------+-----------+-------------------------+-------------+-----------------+-----------------+-----------------+---------------------+---------------+--------------+------------+----------+----------------+-------------------------------------------------------------------------------------------------------------------+

| NAME | SUBSYSTEM | COUNT | MAX_COUNT | MIN_COUNT | AVG_COUNT | COUNT_RESET | MAX_COUNT_RESET | MIN_COUNT_RESET | AVG_COUNT_RESET | TIME_ENABLED | TIME_DISABLED | TIME_ELAPSED | TIME_RESET | STATUS | TYPE | COMMENT |

+------------------------------------------+---------------------+-------------+-------------+-----------+-------------------------+-------------+-----------------+-----------------+-----------------+---------------------+---------------+--------------+------------+----------+----------------+-------------------------------------------------------------------------------------------------------------------+

| metadata_table_handles_opened | metadata | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of table handles opened |

| metadata_table_handles_closed | metadata | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of table handles closed |

| metadata_table_reference_count | metadata | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Table reference counter |

| metadata_mem_pool_size | metadata | 8388608 | 8388608 | 8388608 | NULL | 8388608 | 8388608 | 8388608 | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | value | Size of a memory pool InnoDB uses to store data dictionary and internal data structures in bytes |

| lock_deadlocks | lock | 0 | NULL | NULL | 0 | 0 | NULL | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | counter | Number of deadlocks |

| lock_timeouts | lock | 7 | 7 | NULL | 0.00015228647261019014 | 7 | 7 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | counter | Number of lock timeouts |

| lock_rec_lock_waits | lock | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of times enqueued into record lock wait queue |

| lock_table_lock_waits | lock | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of times enqueued into table lock wait queue |

| lock_rec_lock_requests | lock | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of record locks requested |

| lock_rec_lock_created | lock | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of record locks created |

| lock_rec_lock_removed | lock | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of record locks removed from the lock queue |

| lock_rec_locks | lock | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Current number of record locks on tables |

| lock_table_lock_created | lock | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of table locks created |

| lock_table_lock_removed | lock | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of table locks removed from the lock queue |

| lock_table_locks | lock | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Current number of table locks on tables |

| lock_row_lock_current_waits | lock | 0 | 0 | NULL | 0 | 0 | 0 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Number of row locks currently being waited for (innodb_row_lock_current_waits) |

| lock_row_lock_time | lock | 356363 | 356363 | NULL | 7.75275203411217 | 356363 | 356363 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Time spent in acquiring row locks, in milliseconds (innodb_row_lock_time) |

| lock_row_lock_time_max | lock | 51062 | 51062 | 51062 | NULL | 51062 | 51062 | 51062 | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | value | The maximum time to acquire a row lock, in milliseconds (innodb_row_lock_time_max) |

| lock_row_lock_waits | lock | 7 | 7 | NULL | 0.00015228647261019014 | 7 | 7 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Number of times a row lock had to be waited for (innodb_row_lock_waits) |

| lock_row_lock_time_avg | lock | 50909 | 50909 | 50909 | NULL | 50909 | 50909 | 50909 | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | value | The average time to acquire a row lock, in milliseconds (innodb_row_lock_time_avg) |

| buffer_pool_size | server | 134217728 | 134217728 | 134217728 | NULL | 134217728 | 134217728 | 134217728 | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | value | Server buffer pool size (all buffer pools) in bytes |

| buffer_pool_reads | buffer | 56917 | 56917 | NULL | 1.238241308793456 | 56917 | 56917 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Number of reads directly from disk (innodb_buffer_pool_reads) |

| buffer_pool_read_requests | buffer | 688876467 | 688876467 | NULL | 14986.652460514293 | 688876467 | 688876467 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Number of logical read requests (innodb_buffer_pool_read_requests) |

| buffer_pool_write_requests | buffer | 232689742 | 232689742 | NULL | 5062.214288822173 | 232689742 | 232689742 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Number of write requests (innodb_buffer_pool_write_requests) |

| buffer_pool_wait_free | buffer | 148 | 148 | NULL | 0.003219771135186877 | 148 | 148 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Number of times waited for free buffer (innodb_buffer_pool_wait_free) |

| buffer_pool_read_ahead | buffer | 281470 | 281470 | NULL | 6.123439063655746 | 281470 | 281470 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Number of pages read as read ahead (innodb_buffer_pool_read_ahead) |

| buffer_pool_read_ahead_evicted | buffer | 0 | 0 | NULL | 0 | 0 | 0 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Read-ahead pages evicted without being accessed (innodb_buffer_pool_read_ahead_evicted) |

| buffer_pool_pages_total | buffer | 8191 | 8191 | 8191 | NULL | 8191 | 8191 | 8191 | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | value | Total buffer pool size in pages (innodb_buffer_pool_pages_total) |

| buffer_pool_pages_misc | buffer | 491 | 491 | 491 | NULL | 491 | 491 | 491 | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | value | Buffer pages for misc use such as row locks or the adaptive hash index (innodb_buffer_pool_pages_misc) |

| buffer_pool_pages_data | buffer | 6676 | 6676 | 6676 | NULL | 6676 | 6676 | 6676 | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | value | Buffer pages containing data (innodb_buffer_pool_pages_data) |

| buffer_pool_bytes_data | buffer | 109379584 | 109379584 | 109379584 | NULL | 109379584 | 109379584 | 109379584 | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | value | Buffer bytes containing data (innodb_buffer_pool_bytes_data) |

| buffer_pool_pages_dirty | buffer | 0 | 0 | 0 | NULL | 0 | 0 | 0 | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | value | Buffer pages currently dirty (innodb_buffer_pool_pages_dirty) |

| buffer_pool_bytes_dirty | buffer | 0 | 0 | 0 | NULL | 0 | 0 | 0 | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | value | Buffer bytes currently dirty (innodb_buffer_pool_bytes_dirty) |

| buffer_pool_pages_free | buffer | 1024 | 1024 | 1024 | NULL | 1024 | 1024 | 1024 | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | value | Buffer pages currently free (innodb_buffer_pool_pages_free) |

| buffer_pages_created | buffer | 258153 | 258153 | NULL | 5.616172823391202 | 258153 | 258153 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Number of pages created (innodb_pages_created) |

| buffer_pages_written | buffer | 567903 | 567903 | NULL | 12.354849236392116 | 567903 | 567903 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Number of pages written (innodb_pages_written) |

| buffer_pages_read | buffer | 338386 | 338386 | NULL | 7.361658617238828 | 338386 | 338386 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Number of pages read (innodb_pages_read) |

| buffer_data_reads | buffer | 5544202240 | 5544202240 | NULL | 120615.2860810164 | 5544202240 | 5544202240 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Amount of data read in bytes (innodb_data_reads) |

| buffer_data_written | buffer | 28202428416 | 28202428416 | NULL | 613549.7632162903 | 28202428416 | 28202428416 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Amount of data written in bytes (innodb_data_written) |

| buffer_flush_batch_scanned | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages scanned as part of flush batch |

| buffer_flush_batch_num_scan | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of times buffer flush list flush is called |

| buffer_flush_batch_scanned_per_call | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Pages scanned per flush batch scan |

| buffer_flush_batch_rescan | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of times rescan of flush list forced |

| buffer_flush_batch_total_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages flushed as part of flush batch |

| buffer_flush_batches | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of flush batches |

| buffer_flush_batch_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Pages queued as a flush batch |

| buffer_flush_neighbor_total_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total neighbors flushed as part of neighbor flush |

| buffer_flush_neighbor | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of times neighbors flushing is invoked |

| buffer_flush_neighbor_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Pages queued as a neighbor batch |

| buffer_flush_n_to_flush_requested | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of pages requested for flushing. |

| buffer_flush_avg_page_rate | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Average number of pages at which flushing is happening |

| buffer_flush_lsn_avg_rate | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Average redo generation rate |

| buffer_flush_pct_for_dirty | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Percent of IO capacity used to avoid max dirty page limit |

| buffer_flush_pct_for_lsn | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Percent of IO capacity used to avoid reusable redo space limit |

| buffer_flush_sync_waits | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of times a wait happens due to sync flushing |

| buffer_flush_adaptive_total_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages flushed as part of adaptive flushing |

| buffer_flush_adaptive | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of adaptive batches |

| buffer_flush_adaptive_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Pages queued as an adaptive batch |

| buffer_flush_sync_total_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages flushed as part of sync batches |

| buffer_flush_sync | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of sync batches |

| buffer_flush_sync_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Pages queued as a sync batch |

| buffer_flush_background_total_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages flushed as part of background batches |

| buffer_flush_background | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of background batches |

| buffer_flush_background_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Pages queued as a background batch |

| buffer_LRU_batch_scanned | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages scanned as part of LRU batch |

| buffer_LRU_batch_num_scan | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of times LRU batch is called |

| buffer_LRU_batch_scanned_per_call | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Pages scanned per LRU batch call |

| buffer_LRU_batch_total_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages flushed as part of LRU batches |

| buffer_LRU_batches | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of LRU batches |

| buffer_LRU_batch_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Pages queued as an LRU batch |

| buffer_LRU_single_flush_scanned | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages scanned as part of single page LRU flush |

| buffer_LRU_single_flush_num_scan | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of times single page LRU flush is called |

| buffer_LRU_single_flush_scanned_per_call | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Page scanned per single LRU flush |

| buffer_LRU_single_flush_failure_count | Buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of times attempt to flush a single page from LRU failed |

| buffer_LRU_get_free_search | Buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of searches performed for a clean page |

| buffer_LRU_search_scanned | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages scanned as part of LRU search |

| buffer_LRU_search_num_scan | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of times LRU search is performed |

| buffer_LRU_search_scanned_per_call | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Page scanned per single LRU search |

| buffer_LRU_unzip_search_scanned | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages scanned as part of LRU unzip search |

| buffer_LRU_unzip_search_num_scan | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of times LRU unzip search is performed |

| buffer_LRU_unzip_search_scanned_per_call | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Page scanned per single LRU unzip search |

| buffer_page_read_index_leaf | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Index Leaf Pages read |

| buffer_page_read_index_non_leaf | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Index Non-leaf Pages read |

| buffer_page_read_index_ibuf_leaf | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Insert Buffer Index Leaf Pages read |

| buffer_page_read_index_ibuf_non_leaf | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Insert Buffer Index Non-Leaf Pages read |

| buffer_page_read_undo_log | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Undo Log Pages read |

| buffer_page_read_index_inode | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Index Inode Pages read |

| buffer_page_read_ibuf_free_list | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Insert Buffer Free List Pages read |

| buffer_page_read_ibuf_bitmap | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Insert Buffer Bitmap Pages read |

| buffer_page_read_system_page | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of System Pages read |

| buffer_page_read_trx_system | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Transaction System Pages read |

| buffer_page_read_fsp_hdr | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of File Space Header Pages read |

| buffer_page_read_xdes | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Extent Descriptor Pages read |

| buffer_page_read_blob | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Uncompressed BLOB Pages read |

| buffer_page_read_zblob | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of First Compressed BLOB Pages read |

| buffer_page_read_zblob2 | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Subsequent Compressed BLOB Pages read |

| buffer_page_read_other | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of other/unknown (old version of InnoDB) Pages read |

| buffer_page_written_index_leaf | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Index Leaf Pages written |

| buffer_page_written_index_non_leaf | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Index Non-leaf Pages written |

| buffer_page_written_index_ibuf_leaf | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Insert Buffer Index Leaf Pages written |

| buffer_page_written_index_ibuf_non_leaf | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Insert Buffer Index Non-Leaf Pages written |

| buffer_page_written_undo_log | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Undo Log Pages written |

| buffer_page_written_index_inode | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Index Inode Pages written |

| buffer_page_written_ibuf_free_list | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Insert Buffer Free List Pages written |

| buffer_page_written_ibuf_bitmap | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Insert Buffer Bitmap Pages written |

| buffer_page_written_system_page | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of System Pages written |

| buffer_page_written_trx_system | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Transaction System Pages written |

| buffer_page_written_fsp_hdr | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of File Space Header Pages written |

| buffer_page_written_xdes | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Extent Descriptor Pages written |

| buffer_page_written_blob | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Uncompressed BLOB Pages written |

| buffer_page_written_zblob | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of First Compressed BLOB Pages written |

| buffer_page_written_zblob2 | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Subsequent Compressed BLOB Pages written |

| buffer_page_written_other | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of other/unknown (old version InnoDB) Pages written |

| os_data_reads | os | 338399 | 338399 | NULL | 7.3619414349736765 | 338399 | 338399 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Number of reads initiated (innodb_data_reads) |

| os_data_writes | os | 822181 | 822181 | NULL | 17.88672061958839 | 822181 | 822181 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Number of writes initiated (innodb_data_writes) |

| os_data_fsyncs | os | 257327 | 257327 | NULL | 5.5982030196232 | 257327 | 257327 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Number of fsync() calls (innodb_data_fsyncs) |

| os_pending_reads | os | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of reads pending |

| os_pending_writes | os | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of writes pending |

| os_log_bytes_written | os | 9592861184 | 9592861184 | NULL | 208694.71313579602 | 9592861184 | 9592861184 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Bytes of log written (innodb_os_log_written) |

| os_log_fsyncs | os | 224155 | 224155 | NULL | 4.876539181133881 | 224155 | 224155 | NULL | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Number of fsync log writes (innodb_os_log_fsyncs) |

| os_log_pending_fsyncs | os | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Number of pending fsync write (innodb_os_log_pending_fsyncs) |

| os_log_pending_writes | os | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | status_counter | Number of pending log file writes (innodb_os_log_pending_writes) |

| trx_rw_commits | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of read-write transactions committed |

| trx_ro_commits | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of read-only transactions committed |

| trx_nl_ro_commits | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of non-locking auto-commit read-only transactions committed |

| trx_commits_insert_update | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of transactions committed with inserts and updates |

| trx_rollbacks | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of transactions rolled back |

| trx_rollbacks_savepoint | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of transactions rolled back to savepoint |

| trx_rollback_active | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of resurrected active transactions rolled back |

| trx_active_transactions | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of active transactions |

| trx_rseg_history_len | transaction | 923 | 923 | 923 | NULL | 923 | 923 | 923 | NULL | 2019-11-05 19:23:01 | NULL | 45966 | NULL | enabled | value | Length of the TRX_RSEG_HISTORY list |

| trx_undo_slots_used | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of undo slots used |

| trx_undo_slots_cached | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of undo slots cached |

| trx_rseg_current_size | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Current rollback segment size in pages |

| purge_del_mark_records | purge | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of delete-marked rows purged |

| purge_upd_exist_or_extern_records | purge | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of purges on updates of existing records and updates on delete marked record with externally stored field |

| purge_invoked | purge | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of times purge was invoked |

| purge_undo_log_pages | purge | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of undo log pages handled by the purge |

| purge_dml_delay_usec | purge | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Microseconds DML to be delayed due to purge lagging |

| purge_stop_count | purge | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Number of times purge was stopped |

| purge_resume_count | purge | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Number of times purge was resumed |

| log_checkpoints | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of checkpoints |

| log_lsn_last_flush | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | LSN of Last flush |

| log_lsn_last_checkpoint | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | LSN at last checkpoint |

| log_lsn_current | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Current LSN value |

| log_lsn_checkpoint_age | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Current LSN value minus LSN at last checkpoint |

| log_lsn_buf_pool_oldest | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | The oldest modified block LSN in the buffer pool |

| log_max_modified_age_async | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Maximum LSN difference; when exceeded, start asynchronous preflush |

| log_max_modified_age_sync | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Maximum LSN difference; when exceeded, start synchronous preflush |

| log_pending_log_writes | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Pending log writes |

| log_pending_checkpoint_writes | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Pending checkpoints |

| log_num_log_io | recovery | 0 | NULL |

夜半侃侃谈
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
mysql innodb 监控_MySQL5.6监控表之INNODB_METRICS
weixin_39687359的博客
01-19 298
在MySQL5.6的Information_Schema引入新的监控表,此表用来监控InnoDB运行是否正常,并且该表包括很多计数器,本人当前的MySQL版本为5.6.15,那么我们就来一下INNODB_METRICS.此表的结构mysql> desc INNODB_METRICS;+-----------------+--------------+------+-----+--------...
mysql监控innodb_[MySQL 5.6] Innodb 新的监控表 INNODB_METRICS
weixin_28309571的博客
02-28 289
除了Performance Schema外，在MySQL 5.6中还提供了一个新的information_schema表来监控Innodb的内部运行状态——INNODB_METRICS；该表维护了一组计数器，用户可以通过这些计数器，来监控Innodb内部运行是否健康。当前的MySQL5.6.12版本中，共有210个计数器：mysql> select count(*) from INNODB_...
【MySQL精通之路】INFORMATION_SCHEMA库-INNODB_METRICS表
最新发布
Anakki的博客
05-24 825
要启动、停止和重置计数器，请使用计数器的名称、模块的名称、使用“%”字符的通配符匹配或特殊关键字all设置系统变量innodb_monitor_enable、innodb_monitor_disable、innodm_monitor_reset或innodb_monitor _reset_all之一。（_RESET列的作用类似于秒表上的圈计数器：您可以测量某个时间间隔内的活动，而COUNT、MAX_COUNT等中的累积数字仍然可用。可以查看有关此表的列的其他信息，包括数据类型和默认值。
关于 Mysql innodb_metrics
渔夫数据库笔记
01-24 1784
14.15.6 InnoDB INFORMATION_SCHEMA Metrics Table The INNODB_METRICS table, introduced in MySQL 5.6.2, consolidates all InnoDB performance and resource-related counters into a single INFORM
MySQL5.6监控表之INNODB_METRICS
weixin_30954607的博客
06-28 102
http://blog.chinaunix.net/uid-10661836-id-4278807.html 在MySQL5.6的Information_Schema引入新的INNODB_METRICS,此表用来监控InnoDB运行是否正常,并且该表包括很多计数器 mysql> select version(); +--------------...
InnoDB INFORMATION_SCHEMA Metrics Table
风中清淡
08-20 429
InnoDB INFORMATION_SCHEMA Metrics Table INNODB_METRICS表将所有InnoDB性能和资源相关计数器合并到一个INFORMATION_SCHEMA表中。 15. INNODB_METRICS INNODB_METRICS表提供了各种InnoDB性能信息，补充了InnoDB的性能模式表的特定重点领域。通过简单查询，您可以检查系统的整体运行状况。通...
mysql-5.5.6-rc.tar.gz_mysql 5.6_mysql vc_mysql5.5_mysql5.6
09-24
在MySQL 5.6中，进一步提升了性能和功能。例如，SQL查询的优化器得到了显著改进，能够更好地分析和选择执行计划，从而提高查询效率。另外，新的分区功能允许数据以更灵活的方式进行组织，支持更复杂的查询策略。还有...
mysql 5.6 新特性-innodb
01-22
通过上述改进，MySQL 5.6 的 InnoDB 引擎不仅提高了数据库的整体性能，还增加了许多实用的新功能，极大地满足了现代应用程序的需求。这些新特性的加入，使得 MySQL 5.6 成为了一个非常强大的数据库平台，无论是在...
mysql innodb_thread_concurrency.zip
11-10
如果你的服务器的CPU或者IO使用接受饱和，特别是偶尔出现峰值，这时候系统想在超载时能正常处理查询，那么强烈建议关注innodb_thread_concurrency
MySQL修改innodb_data_file_path参数的一些注意事项
09-09
总之，`innodb_data_file_path`是MySQL中一个关键的配置参数，用于管理InnoDB表空间。正确理解并适当地调整这个参数对于优化数据库性能和管理磁盘空间至关重要。在进行更改时，一定要遵循最佳实践，避免不必要的数据...
MySQL数据库INNODB表损坏修复处理过程分享
09-10
在MySQL数据库中，InnoDB存储引擎的表损坏是一种常见的问题，尤其当系统出现异常关机、硬件故障或软件错误时。不同于MyISAM存储引擎，InnoDB表的损坏通常不能简单地通过`REPAIR TABLE`命令来修复。下面将详细介绍...
mysql监控表内容_MySQL监控内容
weixin_32564229的博客
01-20 377
一、liunx操作系统层面1、整体cpu负载的%user最好不长期超过20%(若%user太高，有极大可能性是索引使用不当)2、整体cpu负载的%iowat最好不长期超过10%(确认I/O子系统是否有明显瓶颈)3、整体cpu负载的%idle最好保持在70%以上(让CPU保持低负载)4、关注各个逻辑CPU之间的负载是否均衡(可能是中断不均衡导致性能问题)5、关注是否有swap产生(注意关闭NUMA)...
mysql监控某一张表_mysql常用监控脚本命令列表
weixin_31304817的博客
01-21 692
#/bin/sh#检测mysql server是否正常提供服务mysqladmin -u sky -ppwd -h localhost ping#获取mysql当前的几个状态值mysqladmin -u sky -ppwd -h localhost status#获取数据库当前的连接信息mysqladmin -u sky -ppwd -h localhost processlist#获取当前数据库...
【MySQL精通之路】InnoDB-INFORMATION_SCHEMA库Metrics表
Anakki的博客
05-18 812
INNODB_METRICS表提供了有关和计数器的信息。INNODB_METRICS表列如下所示。有关列描述，请参阅第28.4.21节“库表”。启用、禁用和重置计数器您可以使用以下变量启用、禁用和重置计数器：innodb_monitor_enable: 启用计数innodb_monitor_disable: 禁用计数innodb_monitor_reset: 将计数重置为零innodb_monitor_reset_all：重置所有计数器值。
nagios监控 mysql 表结构
的专栏
09-04 1369
引言 为了给客户演示对m
mysql常用指标_MYSQL常用的性能指标
weixin_39715460的博客
01-19 381
(1) QPS(每秒Query量)QPS = Questions(or Queries) / secondsmysql > show globalstatus like 'Question%';(2) TPS(每秒事务量)TPS = (Com_commit + Com_rollback) / secondsmysql > show global status like'Com_co...
MySQL 性能监控 4 大指标
weixin_33966365的博客
07-10 914
     【编者按】本文作者为 John Matson，主要介绍 mysql 性能监控应该关注的 4 大指标。 文章系国内 ITOM 管理平台 OneAPM 编译呈现。    MySQL 是什么？   MySQL 是现而今最流行的开源关系型数据库服务器。由 Oracle 所有，MySQL 提供了可以免费下载的社区版及包含更多特性与支持的商业版。从 1995 年首发以来，MySQL ...
Debezium系列之：mysql JMX metrics指标详细解读
zhengzaifeidelushang的博客
01-04 1537
一、debezium监控指标 除了 Zookeeper、Kafka 和 Kafka Connect 提供的JMX 指标之外，Debezium MySQL 连接器还提供三种类型的指标。 Snapshot metrics：在执行快照时提供有关连接器操作的信息。 Streaming metrics：当连接器读取二进制日志时，提供有关连接器操作的信息。 Schema history metrics：提供有关连接器模式历史状态的信息。 二、Snapshot metrics快照指标 除非快照操作处于活动状态，或者自
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值