首页 > 代码库 > mysql 5.7 内存使用监控
mysql 5.7 内存使用监控
5.7 中的performance_schema 已经有能力监控mysql 的内存使用情况了,对于这一点也是要通过instrument 来实现的,由于内存这一块没有对应的consumer 所以只要
配置好instrument 就行了
1、例子:
/etc/my.cnf
[mysqld]datadir =/usr/local/mysql/databasedir =/usr/local/mysqlperformance_schema_instrument =‘memory%=counted‘
select event_name,current_alloc from sys.memory_global_by_current_bytes limit 10;+-----------------------------------------------------------------------------+---------------+| event_name | current_alloc |+-----------------------------------------------------------------------------+---------------+| memory/innodb/buf_buf_pool | 131.06 MiB || memory/innodb/log0log | 32.01 MiB || memory/performance_schema/events_statements_history_long | 13.66 MiB || memory/performance_schema/events_statements_history_long.sqltext | 9.77 MiB || memory/performance_schema/events_statements_history_long.tokens | 9.77 MiB || memory/performance_schema/events_statements_summary_by_digest.tokens | 9.77 MiB || memory/performance_schema/table_handles | 9.06 MiB || memory/performance_schema/events_statements_summary_by_thread_by_event_name | 8.67 MiB || memory/mysys/KEY_CACHE | 8.00 MiB || memory/performance_schema/memory_summary_by_thread_by_event_name | 5.62 MiB |+-----------------------------------------------------------------------------+---------------+
mysql 5.7 内存使用监控
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。