mysql查看内存使用情况

找到MySQL里到底谁消耗了更多内存：
select event_name,SUM_NUMBER_OF_BYTES_ALLOC  from
performance_schema.memory_summary_global_by_event_name
order by SUM_NUMBER_OF_BYTES_ALLOC desc LIMIT 30;


查看都有哪些内部线程消耗了更多内存：
select event_name, CURRENT_NUMBER_OF_BYTES_USED 
from performance_schema.memory_summary_global_by_event_name 
where event_name like '%mem%root%' 
order by CURRENT_NUMBER_OF_BYTES_USED desc limit 10;

select *
from sys.memory_by_user_by_current_bytes;


select thread_id tid, user, current_count_used ccu, current_allocated ca, current_avg_alloc caa, current_max_alloc cma, total_allocated 
from sys.memory_by_thread_by_current_bytes;

 

统计账户消耗内存：
select USER, HOST, EVENT_NAME, SUM_NUMBER_OF_BYTES_ALLOC 
from performance_schema.memory_summary_by_account_by_event_name 
order by SUM_NUMBER_OF_BYTES_ALLOC desc limit 10; 


统计用户消耗内存：
select  USER, EVENT_NAME, SUM_NUMBER_OF_BYTES_ALLOC 
from performance_schema.memory_summary_by_user_by_event_name 
order by SUM_NUMBER_OF_BYTES_ALLOC desc limit 10; 
 

统计主机消耗内存：
select  HOST, EVENT_NAME, SUM_NUMBER_OF_BYTES_ALLOC 
from performance_schema.memory_summary_by_host_by_event_name 
order by SUM_NUMBER_OF_BYTES_ALLOC desc limit 10; 


select host, current_count_used ccu, current_allocated, current_avg_alloc, current_max_alloc, total_allocated 
from sys.memory_by_host_by_current_bytes
WHERE host IS NOT NULL;