有次遇到我的mysql被OOM了,后来翻看mysql系统表的文档才知道怎么看是哪个mysql对象占用的内存比较多,我的版本是5.7.17
下边两个语句都可以查看是哪个对象消耗的内存比较多
1:select event_name,current_alloc from sys.memory_global_by_current_bytes limit 5
2:select event_name,SUM_NUMBER_OF_BYTES_ALLOC/1024/2014 as SUM_NUMBER_OF_BYTES_ALLOC from
performance_schema.memory_summary_global_by_event_name
order by SUM_NUMBER_OF_BYTES_ALLOC desc LIMIT 5