mysql 线程占用_RDS MySQL如何查看消耗内存高的事件和线程

您也可以参考如下SQL语句，查看详细的监控信息。

select * from sys.x$memory_by_host_by_current_bytes;

select * from sys.x$memory_by_thread_by_current_bytes;

select * from sys.x$memory_by_user_by_current_bytes;

select * from sys.x$memory_global_by_current_bytes;

select * from sys.x$memory_global_total;

select * from performance_schema.memory_summary_by_account_by_event_name;

select * from performance_schema.memory_summary_by_host_by_event_name;

select * from performance_schema.memory_summary_by_thread_by_event_name;

select * from performance_schema.memory_summary_by_user_by_event_name;

select * from performance_schema.memory_summary_global_by_event_name;

select event_name,

current_alloc

from sys.memory_global_by_current_bytes

where event_name like '%innodb%';

select event_name,current_alloc from sys.memory_global_by_current_bytes limit 5;

select m.thread_id tid,

USER,

esc.DIGEST_TEXT,

total_allocated

FROM sys.memory_by_thread_by_current_bytes m,

performance_schema.events_statements_current esc

WHERE m.`thread_id` = esc.THREAD_ID \G