SELECT * FROM sys.memory_global_by_current_bytes;


2016-05-11 15:54:46
event_name	current_count	current_alloc	current_avg_alloc	high_count	high_alloc	high_avg_alloc
memory/innodb/mem0mem	2152508	3.25 GiB	1.58 KiB	3784635	5.99 GiB	1.66 KiB
memory/performance_schema/table_io_waits_summary_by_index_usage	639	214.66 MiB	344.00 KiB	639	214.66 MiB	344.00 KiB
memory/performance_schema/file_instances	240	165.00 MiB	704.00 KiB	240	165.00 MiB	704.00 KiB
memory/innodb/os0event	1130032	146.56 MiB	136 bytes	1812013	235.02 MiB	136 bytes
memory/performance_schema/table_shares	120	120.00 MiB	1.00 MiB	120	120.00 MiB	1.00 MiB
memory/innodb/fil0fil	244099	73.56 MiB	316 bytes	244107	74.52 MiB	320 bytes
memory/performance_schema/rwlock_instances	495	61.88 MiB	128.00 KiB	495	61.88 MiB	128.00 KiB
memory/performance_schema/table_lock_waits_summary_by_table	119	39.05 MiB	336.00 KiB	119	39.05 MiB	336.00 KiB
memory/sql/NET::buff	2	15.36 MiB	7.68 MiB	7	26.02 MiB	3.72 MiB
memory/mysys/lf_node	378311	14.94 MiB	41 bytes	378311	14.94 MiB	41 bytes
memory/performance_schema/events_statements_history_long	1	13.66 MiB	13.66 MiB	1	13.66 MiB	13.66 MiB
memory/performance_schema/events_statements_summary_by_digest.tokens	1	9.77 MiB	9.77 MiB	1	9.77 MiB	9.77 MiB
memory/performance_schema/events_statements_history_long.tokens	1	9.77 MiB	9.77 MiB	1	9.77 MiB	9.77 MiB
memory/performance_schema/events_statements_history_long.sqltext	1	9.77 MiB	9.77 MiB	1	9.77 MiB	9.77 MiB
memory/performance_schema/table_handles	1	9.00 MiB	9.00 MiB	1	9.00 MiB	9.00 MiB
memory/performance_schema/events_statements_summary_by_thread_by_event_name	1	8.67 MiB	8.67 MiB	1	8.67 MiB	8.67 MiB
memory/innodb/dict0dict	58090	8.32 MiB	150 bytes	126836	18.06 MiB	149 bytes
memory/mysys/lf_slist	209140	6.38 MiB	32 bytes	209140	6.38 MiB	32 bytes
memory/performance_schema/memory_summary_by_thread_by_event_name	1	5.62 MiB	5.62 MiB	1	5.62 MiB	5.62 MiB
memory/performance_schema/events_statements_summary_by_digest	1	4.88 MiB	4.88 MiB	1	4.88 MiB	4.88 MiB
memory/performance_schema/events_statements_summary_by_account_by_event_name	1	4.33 MiB	4.33 MiB	1	4.33 MiB	4.33 MiB
memory/performance_schema/events_statements_summary_by_host_by_event_name	1	4.33 MiB	4.33 MiB	1	4.33 MiB	4.33 MiB
memory/performance_schema/events_statements_summary_by_user_by_event_name	1	4.33 MiB	4.33 MiB	1	4.33 MiB	4.33 MiB
memory/sql/Filesort_buffer::sort_keys	1	4.00 MiB	4.00 MiB	4	16.00 MiB	4.00 MiB
memory/performance_schema/events_statements_history	1	3.50 MiB	3.50 MiB	1	3.50 MiB	3.50 MiB
memory/performance_schema/events_statements_current	1	3.50 MiB	3.50 MiB	1	3.50 MiB	3.50 MiB
memory/innodb/std	56510	3.47 MiB	64 bytes	59819	3.78 MiB	66 bytes
memory/performance_schema/events_transactions_history_long	1	3.28 MiB	3.28 MiB	1	3.28 MiB	3.28 MiB
memory/performance_schema/events_waits_summary_by_thread_by_event_name	1	3.23 MiB	3.23 MiB	1	3.23 MiB	3.23 MiB
memory/mysys/lf_dynarray	1612	3.17 MiB	2.02 KiB	1612	3.17 MiB	2.02 KiB
memory/performance_schema/memory_summary_by_account_by_event_name	1	2.81 MiB	2.81 MiB	1	2.81 MiB	2.81 MiB
memory/performance_schema/memory_summary_by_host_by_event_name	1	2.81 MiB	2.81 MiB	1	2.81 MiB	2.81 MiB
memory/performance_schema/memory_summary_by_user_by_event_name	1	2.81 MiB	2.81 MiB	1	2.81 MiB	2.81 MiB
memory/performance_schema/events_statements_history.tokens	1	2.50 MiB	2.50 MiB	1	2.50 MiB	2.50 MiB
memory/performance_schema/events_statements_history.sqltext	1	2.50 MiB	2.50 MiB	1	2.50 MiB	2.50 MiB
memory/performance_schema/events_statements_current.tokens	1	2.50 MiB	2.50 MiB	1	2.50 MiB	2.50 MiB
memory/performance_schema/events_statements_current.sqltext	1	2.50 MiB	2.50 MiB	1	2.50 MiB	2.50 MiB
memory/mysys/IO_CACHE	13	2.10 MiB	165.54 KiB	24	4.16 MiB	177.67 KiB
memory/performance_schema/events_waits_history_long	1	1.68 MiB	1.68 MiB	1	1.68 MiB	1.68 MiB
memory/performance_schema/events_waits_summary_by_account_by_event_name	1	1.62 MiB	1.62 MiB	1	1.62 MiB	1.62 MiB
memory/performance_schema/events_waits_summary_by_host_by_event_name	1	1.62 MiB	1.62 MiB	1	1.62 MiB	1.62 MiB
memory/performance_schema/events_waits_summary_by_user_by_event_name	1	1.62 MiB	1.62 MiB	1	1.62 MiB	1.62 MiB
memory/performance_schema/events_stages_summary_by_thread_by_event_name	1	1.17 MiB	1.17 MiB	1	1.17 MiB	1.17 MiB
memory/performance_schema/events_stages_history_long	1	1015.62 KiB	1015.62 KiB	1	1015.62 KiB	1015.62 KiB
memory/performance_schema/threads	1	928.00 KiB	928.00 KiB	1	928.00 KiB	928.00 KiB
memory/performance_schema/events_transactions_history	1	860.00 KiB	860.00 KiB	1	860.00 KiB	860.00 KiB
memory/sql/TABLE	483	642.73 KiB	1.33 KiB	507	919.12 KiB	1.81 KiB
memory/performance_schema/events_stages_summary_by_account_by_event_name	1	600.00 KiB	600.00 KiB	1	600.00 KiB	600.00 KiB
memory/performance_schema/events_stages_summary_by_host_by_event_name	1	600.00 KiB	600.00 KiB	1	600.00 KiB	600.00 KiB
memory/performance_schema/events_stages_summary_by_user_by_event_name	1	600.00 KiB	600.00 KiB	1	600.00 KiB	600.00 KiB
memory/performance_schema/events_statements_summary_by_program	1	448.00 KiB	448.00 KiB	1	448.00 KiB	448.00 KiB
memory/performance_schema/events_waits_history	1	440.00 KiB	440.00 KiB	1	440.00 KiB	440.00 KiB
memory/performance_schema/mutex_instances	3	384.00 KiB	128.00 KiB	3	384.00 KiB	128.00 KiB
memory/myisam/MI_INFO	32	287.57 KiB	8.99 KiB	32	287.57 KiB	8.99 KiB
memory/performance_schema/events_stages_history	1	260.00 KiB	260.00 KiB	1	260.00 KiB	260.00 KiB
memory/performance_schema/file_handle	1	256.00 KiB	256.00 KiB	1	256.00 KiB	256.00 KiB
memory/sql/sp_head::main_mem_root	22	239.22 KiB	10.87 KiB	67	741.56 KiB	11.07 KiB
memory/performance_schema/session_connect_attrs	1	128.00 KiB	128.00 KiB	1	128.00 KiB	128.00 KiB
memory/performance_schema/scalable_buffer	1626	127.27 KiB	80 bytes	1626	127.27 KiB	80 bytes
memory/sql/dboptions_hash	1200	103.70 KiB	88 bytes	1200	121.21 KiB	103 bytes
memory/performance_schema/accounts	1	88.00 KiB	88.00 KiB	1	88.00 KiB	88.00 KiB
memory/performance_schema/socket_instances	1	80.00 KiB	80.00 KiB	1	80.00 KiB	80.00 KiB
memory/performance_schema/users	1	80.00 KiB	80.00 KiB	1	80.00 KiB	80.00 KiB
memory/sql/thd::main_mem_root	8	79.73 KiB	9.97 KiB	212	46.38 MiB	224.02 KiB
memory/performance_schema/hosts	1	72.00 KiB	72.00 KiB	1	72.00 KiB	72.00 KiB
memory/performance_schema/memory_class	1	60.00 KiB	60.00 KiB	1	60.00 KiB	60.00 KiB
memory/innodb/trx0undo	170	58.44 KiB	352 bytes	188	64.62 KiB	352 bytes
memory/performance_schema/setup_objects	1	56.00 KiB	56.00 KiB	1	56.00 KiB	56.00 KiB
memory/sql/String::value	64	52.14 KiB	834 bytes	102	45.06 MiB	452.41 KiB
memory/performance_schema/mutex_class	1	50.00 KiB	50.00 KiB	1	50.00 KiB	50.00 KiB
memory/performance_schema/setup_actors	1	40.00 KiB	40.00 KiB	1	40.00 KiB	40.00 KiB
memory/performance_schema/stage_class	1	37.50 KiB	37.50 KiB	1	37.50 KiB	37.50 KiB
memory/performance_schema/statement_class	1	36.19 KiB	36.19 KiB	1	36.19 KiB	36.19 KiB
memory/performance_schema/events_statements_summary_global_by_event_name	1	34.68 KiB	34.68 KiB	1	34.68 KiB	34.68 KiB
memory/myisam/record_buffer	32	31.10 KiB	995 bytes	38	43.24 KiB	1.14 KiB
memory/sql/TABLE_SHARE::mem_root	18	26.29 KiB	1.46 KiB	33	114.54 KiB	3.47 KiB
memory/performance_schema/file_class	1	25.00 KiB	25.00 KiB	1	25.00 KiB	25.00 KiB
memory/sql/sql_acl_memex	5	24.98 KiB	5.00 KiB	10	49.97 KiB	5.00 KiB
memory/performance_schema/memory_summary_global_by_event_name	1	22.50 KiB	22.50 KiB	1	22.50 KiB	22.50 KiB
memory/performance_schema/events_transactions_summary_by_thread_by_event_name	1	22.00 KiB	22.00 KiB	1	22.00 KiB	22.00 KiB
memory/performance_schema/cond_class	1	20.00 KiB	20.00 KiB	1	20.00 KiB	20.00 KiB
memory/performance_schema/cond_instances	1	16.00 KiB	16.00 KiB	1	16.00 KiB	16.00 KiB
memory/sql/THD::sp_cache	2	15.97 KiB	7.98 KiB	5	39.92 KiB	7.98 KiB
memory/performance_schema/events_transactions_summary_by_account_by_event_name	1	11.00 KiB	11.00 KiB	1	11.00 KiB	11.00 KiB
memory/performance_schema/events_transactions_summary_by_host_by_event_name	1	11.00 KiB	11.00 KiB	1	11.00 KiB	11.00 KiB
memory/performance_schema/events_transactions_summary_by_user_by_event_name	1	11.00 KiB	11.00 KiB	1	11.00 KiB	11.00 KiB
memory/performance_schema/rwlock_class	1	10.00 KiB	10.00 KiB	1	10.00 KiB	10.00 KiB
memory/performance_schema/thread_class	1	9.38 KiB	9.38 KiB	1	9.38 KiB	9.38 KiB
memory/innodb/ha_innodb	10	8.77 KiB	898 bytes	17	40.91 KiB	2.41 KiB
memory/sql/THD::Session_tracker	8	8.31 KiB	1.04 KiB	45	41.88 KiB	953 bytes
memory/performance_schema/events_stages_summary_global_by_event_name	1	4.69 KiB	4.69 KiB	1	4.69 KiB	4.69 KiB
memory/sql/acl_cache	5	4.22 KiB	865 bytes	5	4.22 KiB	865 bytes
memory/sql/THD::transactions::mem_root	1	4.02 KiB	4.02 KiB	4	16.06 KiB	4.02 KiB
memory/performance_schema/socket_class	1	3.12 KiB	3.12 KiB	1	3.12 KiB	3.12 KiB
memory/myisam/MYISAM_SHARE	1	2.80 KiB	2.80 KiB	1	2.80 KiB	2.80 KiB
memory/sql/user_var_entry	9	1.28 KiB	146 bytes	13	2.28 KiB	180 bytes
memory/innodb/btr0pcur	6	1.05 KiB	180 bytes	6	1.05 KiB	180 bytes
memory/sql/sql_acl_mem	2	1008 bytes	504 bytes	4	2.00 KiB	512 bytes
memory/mysys/my_file_info	38	820 bytes	22 bytes	40	934 bytes	23 bytes
memory/sql/binlog_cache_mngr	1	680 bytes	680 bytes	2	1.33 KiB	680 bytes
memory/innodb/read0read	2	560 bytes	280 bytes	2	560 bytes	280 bytes
memory/sql/LOG_POS_COORD	1	513 bytes	513 bytes	2	1.00 KiB	513 bytes
memory/sql/Prepared_statement_map	2	512 bytes	256 bytes	6	1.50 KiB	256 bytes
memory/vio/vio	1	496 bytes	496 bytes	5	2.42 KiB	496 bytes
memory/sql/Log_event	1	440 bytes	440 bytes	4	1.98 KiB	506 bytes
memory/sql/TABLE::sort_io_cache	1	280 bytes	280 bytes	4	1.09 KiB	280 bytes
memory/innodb/rem0rec	3	264 bytes	88 bytes	8	842 bytes	105 bytes
memory/myisam/keycache_thread_var	3	240 bytes	80 bytes	6	480 bytes	80 bytes
memory/sql/Gtid_set::Interval_chunk	1	200 bytes	200 bytes	2	400 bytes	200 bytes
memory/sql/THD::variables	3	192 bytes	64 bytes	6	384 bytes	64 bytes
memory/sql/THD::Session_sysvar_resource_manager	3	161 bytes	54 bytes	15	805 bytes	54 bytes
memory/sql/user_var_entry::value	2	154 bytes	77 bytes	2	154 bytes	77 bytes
memory/sql/user_conn	1	88 bytes	88 bytes	176	15.97 KiB	93 bytes
memory/sql/MYSQL_LOG::name	2	58 bytes	29 bytes	3	89 bytes	30 bytes
memory/sql/MYSQL_LOCK	1	48 bytes	48 bytes	8	384 bytes	48 bytes
memory/innodb/trx_sys_t::rw_trx_ids	1	40 bytes	40 bytes	1	40 bytes	40 bytes
memory/sql/THD::db	1	34 bytes	34 bytes	7	88 bytes	13 bytes