查询mysql 的内存使用_检查MySQL内存使用情况

=========================================================================================================================

#启用收集内存指标

UPDATE setup_instruments SET ENABLED = ‘YES‘ WHERE NAME LIKE ‘memory/%‘;

#查看运行sys schema里面内存分配的报告

select event_name,current_alloc,high_alloc from sys.memory_global_by_current_bytes where current_count > 0;

#获得每个事件更高级别活动的总体报告

select substring_index(substring_index(event_name,‘/‘,2),‘/‘,-1