root@mysql216 15:18: [(none)]> select THREAD_ID, EVENT_NAME, SUM_NUMBER_OF_BYTES_ALLOC/1024/1024/1024, SUM_NUMBER_OF_BYTES_FREE/1024/1024/1024 from performance_schema.memory_summary_by_thread_by_event_name order by SUM_NUMBER_OF_BYTES_ALLOC desc limit 20; +-----------+----------------------------+------------------------------------------+-----------------------------------------+ | THREAD_ID | EVENT_NAME | SUM_NUMBER_OF_BYTES_ALLOC/1024/1024/1024 | SUM_NUMBER_OF_BYTES_FREE/1024/1024/1024 | +-----------+----------------------------+------------------------------------------+-----------------------------------------+ | 33 | memory/innodb/mem0mem | 61.124617055058 | 61.122700333595 | | 1 | memory/innodb/buf_buf_pool | 32.765625000000 | 0.000000000000 | | 35 | memory/innodb/mem0mem | 14.847582187504 | 14.819855483249 | | 34 | memory/innodb/mem0mem | 4.814178101718 | 4.812614925206 | | 34 | memory/sql/Log_event | 4.411010995507 | 0.000006227754 | | 35 | memory/sql/Log_event | 4.026971537620 | 8.401382525451 | | 26 | memory/innodb/mem0mem | 3.941387484781 | 3.941387484781 | | 1 | memory/innodb/hash0hash | 2.655576348305 | 1.691855102777 | | 1 | memory/sql/Log_event | 2.124844557606 | 2.124844147824 | | 33 | memory/innodb/std | 0.975829221308 | 0.857544057071 | | 1 | memory/innodb/os0event | 0.796978607774 | 0.000000000000 | | 33 | memory/innodb/btr0pcur | 0.354918420315 | 0.354816287756 | | 35 | memory/innodb/std | 0.199678502977 | 0.181247323751 | | 74670 | memory/memory/HP_PTRS | 0.131508409977 | 0.131508409977 | | 33 | memory/sql/MYSQL_LOCK | 0.118280977011 | 0.118280977011 | | 35 | memory/innodb/btr0pcur | 0.080127852969 | 0.079814700410 | | 36 | memory/innodb/mem0mem | 0.077137202024 | 0.069444052875 | | 34 | memory/innodb/std | 0.076821677387 | 0.067510232329 | | 74676 | memory/memory/HP_PTRS | 0.074947312474 | 0.074947312474 | | 35 | memory/innodb/fil0fil | 0.062669388950 | 0.062669388950 | +-----------+----------------------------+------------------------------------------+-----------------------------------------+ 20 rows in set (0.03 sec) root@mysql216 15:15: [(none)]> select USER, HOST, EVENT_NAME, COUNT_ALLOC, COUNT_FREE, SUM_NUMBER_OF_BYTES_ALLOC/1024/1024/1024, SUM_NUMBER_OF_BYTES_FREE/1024/1024/1024 from performance_schema.memory_summary_by_account_by_event_name order by SUM_NUMBER_OF_BYTES_ALLOC desc limit 20; +------+---------------+-----------------------------------+-------------+------------+------------------------------------------+-----------------------------------------+ | USER | HOST | EVENT_NAME | COUNT_ALLOC | COUNT_FREE | SUM_NUMBER_OF_BYTES_ALLOC/1024/1024/1024 | SUM_NUMBER_OF_BYTES_FREE/1024/1024/1024 | +------+---------------+-----------------------------------+-------------+------------+------------------------------------------+-----------------------------------------+ | root | 10.25.151.216 | memory/memory/HP_PTRS | 1775044 | 1775236 | 3232.640235915780 | 3232.635222837329 | | root | 10.25.151.216 | memory/innodb/mem0mem | 56460585 | 56480984 | 648.425621422008 | 648.463254543021 | | root | 10.25.151.216 | memory/sql/get_all_tables | 9543186 | 9546162 | 257.856109231710 | 257.807821661234 | | NULL | NULL | memory/innodb/mem0mem | 17370306 | 17357496 | 85.013890000060 | 84.971996369772 | | root | 10.25.151.216 | memory/sql/thd::main_mem_root | 5233370 | 5239574 | 39.920764490962 | 39.923834502697 | | NULL | NULL | memory/innodb/buf_buf_pool | 256 | 0 | 32.765625000000 | 0.000000000000 | | root | 10.25.151.216 | memory/sql/JOIN_CACHE | 12413 | 12413 | 24.250000000000 | 24.250000000000 | | root | 10.25.151.216 | memory/sql/sp_head::main_mem_root | 1644018 | 1644125 | 17.586672417819 | 17.586596272886 | | NULL | NULL | memory/sql/Log_event | 23820603 | 23820598 | 10.592798209749 | 10.592796756886 | | root | 10.25.151.216 | memory/mysys/MY_DIR | 707550 | 707688 | 9.032111942768 | 9.032111942768 | | root | 10.25.151.216 | memory/sql/String::value | 24054314 | 23833146 | 3.366558626294 | 2.248917914927 | | NULL | NULL | memory/innodb/hash0hash | 82 | 6 | 2.655576348305 | 1.691855102777 | | root | 10.25.151.216 | memory/memory/HP_INFO | 3785482 | 3785491 | 2.628651076928 | 2.628727886826 | | root | 10.25.151.216 | memory/memory/HP_SHARE | 7569614 | 7569722 | 1.996448441409 | 1.996671103872 | | root | localhost | memory/memory/HP_PTRS | 1024 | 1024 | 1.992214672267 | 1.992214672267 | | NULL | NULL | memory/innodb/std | 30228538 | 25324280 | 1.253972426057 | 1.107785634696 | | root | 10.25.151.216 | memory/sql/bison_stack | 49503 | 49542 | 1.138178631663 | 1.138040795922 | | root | 10.25.151.216 | memory/myisam/MI_INFO | 140681 | 140686 | 1.103936471045 | 1.103970408440 | | NULL | NULL | memory/innodb/os0event | 6292311 | 0 | 0.796983294189 | 0.000000000000 | | root | 10.25.151.216 | memory/myisam/record_buffer | 404803 | 404943 | 0.631325807422 | 0.631329431199 | +------+---------------+-----------------------------------+-------------+------------+------------------------------------------+-----------------------------------------+ 20 rows in set (0.04 sec)