5.7 中的performance_schema 已经有能力监控mysql 的内存使用情况了,对于这一点也是要通过instrument 来实现的,由于内存这一块没有对应的consumer 所以只要
配置好instrument 就行了
1、例子:
/etc/my.cnf
[mysqld]
datadir =/usr/local/mysql/data
basedir =/usr/local/mysql
performance_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_histo