当前位置:Gxlcms > 数据库问题 > mysql 5.7 内存使用监控

mysql 5.7 内存使用监控

时间:2021-07-01 10:21:17 帮助过:6人阅读

=/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_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 内存使用监控

标签:

人气教程排行