Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 3.15.10.50
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
perfschema /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
all_tests.result
1.38
KB
-rw-r--r--
alter_table_progress.result
2.96
KB
-rw-r--r--
bad_option.result
342
B
-rw-r--r--
batch_table_io_func.result
6.2
KB
-rw-r--r--
binlog_edge_mix.result
8.28
KB
-rw-r--r--
binlog_edge_row.result
8.58
KB
-rw-r--r--
binlog_edge_stmt.result
15.31
KB
-rw-r--r--
binlog_ok_mix.result
4.6
KB
-rw-r--r--
binlog_ok_row.result
4.6
KB
-rw-r--r--
binlog_ok_stmt.result
4.6
KB
-rw-r--r--
checksum.result
7.33
KB
-rw-r--r--
cnf_option.result
263
B
-rw-r--r--
column_privilege.result
2.06
KB
-rw-r--r--
connect_attrs.result
1.47
KB
-rw-r--r--
connection.result
26.22
KB
-rw-r--r--
connection_3a.result
25.15
KB
-rw-r--r--
connection_3a_3u.result
24.58
KB
-rw-r--r--
connection_3u.result
25.66
KB
-rw-r--r--
connection_type_notwin.result
3.24
KB
-rw-r--r--
connection_type_win.result
3.33
KB
-rw-r--r--
csv_table_io.result
5.69
KB
-rw-r--r--
ddl_accounts.result
539
B
-rw-r--r--
ddl_cond_instances.result
580
B
-rw-r--r--
ddl_esgs_by_account_by_event_n...
669
B
-rw-r--r--
ddl_esgs_by_host_by_event_name...
657
B
-rw-r--r--
ddl_esgs_by_thread_by_event_na...
667
B
-rw-r--r--
ddl_esgs_by_user_by_event_name...
657
B
-rw-r--r--
ddl_esgs_global_by_event_name....
657
B
-rw-r--r--
ddl_esms_by_account_by_event_n...
685
B
-rw-r--r--
ddl_esms_by_digest.result
621
B
-rw-r--r--
ddl_esms_by_host_by_event_name...
673
B
-rw-r--r--
ddl_esms_by_program.result
635
B
-rw-r--r--
ddl_esms_by_thread_by_event_na...
683
B
-rw-r--r--
ddl_esms_by_user_by_event_name...
673
B
-rw-r--r--
ddl_esms_global_by_event_name....
673
B
-rw-r--r--
ddl_ets_by_account_by_event_na...
693
B
-rw-r--r--
ddl_ets_by_host_by_event_name....
681
B
-rw-r--r--
ddl_ets_by_thread_by_event_nam...
691
B
-rw-r--r--
ddl_ets_by_user_by_event_name....
681
B
-rw-r--r--
ddl_ets_global_by_event_name.r...
681
B
-rw-r--r--
ddl_events_stages_current.resu...
1.18
KB
-rw-r--r--
ddl_events_stages_history.resu...
1.18
KB
-rw-r--r--
ddl_events_stages_history_long...
1.21
KB
-rw-r--r--
ddl_events_statements_current....
585
B
-rw-r--r--
ddl_events_statements_history....
585
B
-rw-r--r--
ddl_events_statements_history_...
605
B
-rw-r--r--
ddl_events_transactions_curren...
593
B
-rw-r--r--
ddl_events_transactions_histor...
593
B
-rw-r--r--
ddl_events_transactions_histor...
613
B
-rw-r--r--
ddl_events_waits_current.resul...
565
B
-rw-r--r--
ddl_events_waits_history.resul...
565
B
-rw-r--r--
ddl_events_waits_history_long....
585
B
-rw-r--r--
ddl_ews_by_account_by_event_na...
665
B
-rw-r--r--
ddl_ews_by_host_by_event_name....
653
B
-rw-r--r--
ddl_ews_by_instance.result
617
B
-rw-r--r--
ddl_ews_by_thread_by_event_nam...
663
B
-rw-r--r--
ddl_ews_by_user_by_event_name....
653
B
-rw-r--r--
ddl_ews_global_by_event_name.r...
653
B
-rw-r--r--
ddl_file_instances.result
590
B
-rw-r--r--
ddl_fs_by_event_name.result
581
B
-rw-r--r--
ddl_fs_by_instance.result
573
B
-rw-r--r--
ddl_global_status.result
547
B
-rw-r--r--
ddl_global_variables.result
606
B
-rw-r--r--
ddl_host_cache.result
513
B
-rw-r--r--
ddl_hosts.result
527
B
-rw-r--r--
ddl_mems_by_account_by_event_n...
641
B
-rw-r--r--
ddl_mems_by_host_by_event_name...
629
B
-rw-r--r--
ddl_mems_by_thread_by_event_na...
637
B
-rw-r--r--
ddl_mems_by_user_by_event_name...
629
B
-rw-r--r--
ddl_mems_global_by_event_name....
625
B
-rw-r--r--
ddl_metadata_locks.result
592
B
-rw-r--r--
ddl_mutex_instances.result
584
B
-rw-r--r--
ddl_os_global_by_type.result
611
B
-rw-r--r--
ddl_performance_timers.result
608
B
-rw-r--r--
ddl_prepared_statements_instan...
619
B
-rw-r--r--
ddl_processlist.result
1
KB
-rw-r--r--
ddl_replication_applier_config...
674
B
-rw-r--r--
ddl_replication_applier_status...
650
B
-rw-r--r--
ddl_replication_applier_status...
698
B
-rw-r--r--
ddl_replication_applier_status...
678
B
-rw-r--r--
ddl_replication_connection_con...
668
B
-rw-r--r--
ddl_replication_connection_sta...
650
B
-rw-r--r--
ddl_replication_group_member_s...
654
B
-rw-r--r--
ddl_replication_group_members....
634
B
-rw-r--r--
ddl_rwlock_instances.result
588
B
-rw-r--r--
ddl_session_account_connect_at...
650
B
-rw-r--r--
ddl_session_connect_attrs.resu...
618
B
-rw-r--r--
ddl_session_status.result
598
B
-rw-r--r--
ddl_session_variables.result
610
B
-rw-r--r--
ddl_setup_actors.result
972
B
-rw-r--r--
ddl_setup_consumers.result
584
B
-rw-r--r--
ddl_setup_instruments.result
592
B
-rw-r--r--
ddl_setup_objects.result
843
B
-rw-r--r--
ddl_setup_timers.result
572
B
-rw-r--r--
ddl_socket_instances.result
598
B
-rw-r--r--
ddl_socket_summary_by_event_na...
591
B
-rw-r--r--
ddl_socket_summary_by_instance...
591
B
-rw-r--r--
ddl_status_by_account.result
563
B
-rw-r--r--
ddl_status_by_host.result
551
B
-rw-r--r--
ddl_status_by_thread.result
559
B
-rw-r--r--
ddl_status_by_user.result
551
B
-rw-r--r--
ddl_table_handles.result
588
B
-rw-r--r--
ddl_threads.result
572
B
-rw-r--r--
ddl_tiws_by_index_usage.result
637
B
-rw-r--r--
ddl_tiws_by_table.result
613
B
-rw-r--r--
ddl_tlws_by_table.result
621
B
-rw-r--r--
ddl_users.result
527
B
-rw-r--r--
ddl_uvar_by_thread.result
638
B
-rw-r--r--
ddl_variables_by_thread.result
618
B
-rw-r--r--
digest_null_literal.result
804
B
-rw-r--r--
digest_table_full.result
3.63
KB
-rw-r--r--
digest_view.result
6.42
KB
-rw-r--r--
dml_accounts.result
1.19
KB
-rw-r--r--
dml_cond_instances.result
1.06
KB
-rw-r--r--
dml_esgs_by_account_by_event_n...
1.85
KB
-rw-r--r--
dml_esgs_by_host_by_event_name...
1.79
KB
-rw-r--r--
dml_esgs_by_thread_by_event_na...
1.83
KB
-rw-r--r--
dml_esgs_by_user_by_event_name...
1.79
KB
-rw-r--r--
dml_esgs_global_by_event_name....
1.77
KB
-rw-r--r--
dml_esms_by_account_by_event_n...
1.92
KB
-rw-r--r--
dml_esms_by_digest.result
2.57
KB
-rw-r--r--
dml_esms_by_host_by_event_name...
1.86
KB
-rw-r--r--
dml_esms_by_program.result
2.77
KB
-rw-r--r--
dml_esms_by_thread_by_event_na...
1.89
KB
-rw-r--r--
dml_esms_by_user_by_event_name...
1.86
KB
-rw-r--r--
dml_esms_global_by_event_name....
1.83
KB
-rw-r--r--
dml_ets_by_account_by_event_na...
1.95
KB
-rw-r--r--
dml_ets_by_host_by_event_name....
1.89
KB
-rw-r--r--
dml_ets_by_thread_by_event_nam...
1.92
KB
-rw-r--r--
dml_ets_by_user_by_event_name....
1.89
KB
-rw-r--r--
dml_ets_global_by_event_name.r...
1.86
KB
-rw-r--r--
dml_events_stages_current.resu...
1.41
KB
-rw-r--r--
dml_events_stages_history.resu...
1.64
KB
-rw-r--r--
dml_events_stages_history_long...
1.73
KB
-rw-r--r--
dml_events_statements_current....
1.48
KB
-rw-r--r--
dml_events_statements_history....
1.73
KB
-rw-r--r--
dml_events_statements_history_...
1.81
KB
-rw-r--r--
dml_events_transactions_curren...
1.51
KB
-rw-r--r--
dml_events_transactions_histor...
1.76
KB
-rw-r--r--
dml_events_transactions_histor...
1.85
KB
-rw-r--r--
dml_events_waits_current.resul...
1.4
KB
-rw-r--r--
dml_events_waits_history.resul...
1.64
KB
-rw-r--r--
dml_events_waits_history_long....
1.73
KB
-rw-r--r--
dml_ews_by_account_by_event_na...
2.04
KB
-rw-r--r--
dml_ews_by_host_by_event_name....
1.97
KB
-rw-r--r--
dml_ews_by_instance.result
2.07
KB
-rw-r--r--
dml_ews_by_thread_by_event_nam...
1.81
KB
-rw-r--r--
dml_ews_by_user_by_event_name....
1.97
KB
-rw-r--r--
dml_ews_global_by_event_name.r...
1.75
KB
-rw-r--r--
dml_file_instances.result
3.21
KB
-rw-r--r--
dml_fs_by_event_name.result
1.52
KB
-rw-r--r--
dml_fs_by_instance.result
1.49
KB
-rw-r--r--
dml_global_status.result
1.13
KB
-rw-r--r--
dml_global_variables.result
1.17
KB
-rw-r--r--
dml_handler.result
19.35
KB
-rw-r--r--
dml_host_cache.result
1.28
KB
-rw-r--r--
dml_hosts.result
1.12
KB
-rw-r--r--
dml_mems_by_account_by_event_n...
1.76
KB
-rw-r--r--
dml_mems_by_host_by_event_name...
1.71
KB
-rw-r--r--
dml_mems_by_thread_by_event_na...
1.74
KB
-rw-r--r--
dml_mems_by_user_by_event_name...
1.71
KB
-rw-r--r--
dml_mems_global_by_event_name....
1.68
KB
-rw-r--r--
dml_metadata_locks.result
1.22
KB
-rw-r--r--
dml_mutex_instances.result
1.07
KB
-rw-r--r--
dml_os_global_by_type.result
2.81
KB
-rw-r--r--
dml_performance_timers.result
1.56
KB
-rw-r--r--
dml_prepared_statements_instan...
2.82
KB
-rw-r--r--
dml_processlist.result
1.26
KB
-rw-r--r--
dml_replication_applier_config...
1.33
KB
-rw-r--r--
dml_replication_applier_status...
1.46
KB
-rw-r--r--
dml_replication_applier_status...
1.75
KB
-rw-r--r--
dml_replication_applier_status...
1.67
KB
-rw-r--r--
dml_replication_connection_con...
1.64
KB
-rw-r--r--
dml_replication_connection_sta...
1.59
KB
-rw-r--r--
dml_replication_group_member_s...
1.89
KB
-rw-r--r--
dml_replication_group_members....
1.4
KB
-rw-r--r--
dml_rwlock_instances.result
1.08
KB
-rw-r--r--
dml_session_account_connect_at...
1.52
KB
-rw-r--r--
dml_session_connect_attrs.resu...
1.4
KB
-rw-r--r--
dml_session_status.result
1.14
KB
-rw-r--r--
dml_session_variables.result
1.18
KB
-rw-r--r--
dml_setup_actors.result
3.61
KB
-rw-r--r--
dml_setup_consumers.result
1.95
KB
-rw-r--r--
dml_setup_instruments.result
3.72
KB
-rw-r--r--
dml_setup_objects.result
3.04
KB
-rw-r--r--
dml_setup_timers.result
4.16
KB
-rw-r--r--
dml_socket_instances.result
1.08
KB
-rw-r--r--
dml_socket_summary_by_event_na...
1.52
KB
-rw-r--r--
dml_socket_summary_by_instance...
1.51
KB
-rw-r--r--
dml_status_by_account.result
1.38
KB
-rw-r--r--
dml_status_by_host.result
1.32
KB
-rw-r--r--
dml_status_by_thread.result
1.34
KB
-rw-r--r--
dml_status_by_user.result
1.32
KB
-rw-r--r--
dml_table_handles.result
1.19
KB
-rw-r--r--
dml_threads.result
1.29
KB
-rw-r--r--
dml_tiws_by_index_usage.result
1.7
KB
-rw-r--r--
dml_tiws_by_table.result
1.61
KB
-rw-r--r--
dml_tlws_by_table.result
1.64
KB
-rw-r--r--
dml_users.result
1.12
KB
-rw-r--r--
dml_uvar_by_thread.result
1.65
KB
-rw-r--r--
dml_variables_by_thread.result
1.39
KB
-rw-r--r--
event_aggregate.result
245.64
KB
-rw-r--r--
event_aggregate_no_a.result
169.86
KB
-rw-r--r--
event_aggregate_no_a_no_h.resu...
149.82
KB
-rw-r--r--
event_aggregate_no_a_no_u.resu...
110.6
KB
-rw-r--r--
event_aggregate_no_a_no_u_no_h...
90.56
KB
-rw-r--r--
event_aggregate_no_h.result
225.59
KB
-rw-r--r--
event_aggregate_no_u.result
186.38
KB
-rw-r--r--
event_aggregate_no_u_no_h.resu...
166.33
KB
-rw-r--r--
file_misc.result
62
B
-rw-r--r--
func_file_io.result
6.55
KB
-rw-r--r--
func_mutex.result
5.51
KB
-rw-r--r--
global_objects.result
1.02
KB
-rw-r--r--
global_read_lock.result
1.93
KB
-rw-r--r--
hostcache_ipv4_addrinfo_again_...
3.18
KB
-rw-r--r--
hostcache_ipv4_addrinfo_again_...
2.5
KB
-rw-r--r--
hostcache_ipv4_addrinfo_bad_al...
3.18
KB
-rw-r--r--
hostcache_ipv4_addrinfo_bad_de...
2.5
KB
-rw-r--r--
hostcache_ipv4_addrinfo_good_a...
3.31
KB
-rw-r--r--
hostcache_ipv4_addrinfo_good_d...
2.57
KB
-rw-r--r--
hostcache_ipv4_addrinfo_noname...
3.51
KB
-rw-r--r--
hostcache_ipv4_addrinfo_noname...
2.5
KB
-rw-r--r--
hostcache_ipv4_auth_plugin.res...
5.81
KB
-rw-r--r--
hostcache_ipv4_blocked.result
12.56
KB
-rw-r--r--
hostcache_ipv4_format.result
2.46
KB
-rw-r--r--
hostcache_ipv4_max_con.result
18.74
KB
-rw-r--r--
hostcache_ipv4_nameinfo_again_...
5.28
KB
-rw-r--r--
hostcache_ipv4_nameinfo_again_...
4.25
KB
-rw-r--r--
hostcache_ipv4_nameinfo_noname...
3.14
KB
-rw-r--r--
hostcache_ipv4_nameinfo_noname...
2.46
KB
-rw-r--r--
hostcache_ipv4_passwd.result
6.34
KB
-rw-r--r--
hostcache_ipv4_ssl.result
5.16
KB
-rw-r--r--
hostcache_ipv6_addrinfo_again_...
3.21
KB
-rw-r--r--
hostcache_ipv6_addrinfo_again_...
2.51
KB
-rw-r--r--
hostcache_ipv6_addrinfo_bad_al...
3.21
KB
-rw-r--r--
hostcache_ipv6_addrinfo_bad_de...
2.51
KB
-rw-r--r--
hostcache_ipv6_addrinfo_good_a...
3.32
KB
-rw-r--r--
hostcache_ipv6_addrinfo_good_d...
2.54
KB
-rw-r--r--
hostcache_ipv6_addrinfo_noname...
3.54
KB
-rw-r--r--
hostcache_ipv6_addrinfo_noname...
2.51
KB
-rw-r--r--
hostcache_ipv6_auth_plugin.res...
5.83
KB
-rw-r--r--
hostcache_ipv6_blocked.result
12.63
KB
-rw-r--r--
hostcache_ipv6_max_con.result
18.81
KB
-rw-r--r--
hostcache_ipv6_nameinfo_again_...
5.32
KB
-rw-r--r--
hostcache_ipv6_nameinfo_again_...
4.27
KB
-rw-r--r--
hostcache_ipv6_nameinfo_noname...
3.17
KB
-rw-r--r--
hostcache_ipv6_nameinfo_noname...
2.48
KB
-rw-r--r--
hostcache_ipv6_passwd.result
6.37
KB
-rw-r--r--
hostcache_ipv6_ssl.result
5.17
KB
-rw-r--r--
hostcache_peer_addr.result
1.93
KB
-rw-r--r--
indexed_table_io.result
5.89
KB
-rw-r--r--
information_schema.result
37.19
KB
-rw-r--r--
innodb_table_io.result
5.74
KB
-rw-r--r--
io_cache.result
8.78
KB
-rw-r--r--
max_program_zero.result
11.01
KB
-rw-r--r--
mdl_func.result
22.87
KB
-rw-r--r--
memory_aggregate.result
130.6
KB
-rw-r--r--
memory_aggregate_32bit.result
130.5
KB
-rw-r--r--
memory_aggregate_no_a.result
95.47
KB
-rw-r--r--
memory_aggregate_no_a_no_h.res...
82.7
KB
-rw-r--r--
memory_aggregate_no_a_no_u.res...
60.58
KB
-rw-r--r--
memory_aggregate_no_a_no_u_no_...
47.81
KB
-rw-r--r--
memory_aggregate_no_h.result
117.82
KB
-rw-r--r--
memory_aggregate_no_u.result
95.71
KB
-rw-r--r--
memory_aggregate_no_u_no_h.res...
82.93
KB
-rw-r--r--
memory_table_io.result
5.7
KB
-rw-r--r--
merge_table_io.result
7
KB
-rw-r--r--
misc.result
9.73
KB
-rw-r--r--
misc_global_status.result
2.52
KB
-rw-r--r--
multi_table_io.result
4.56
KB
-rw-r--r--
myisam_file_io.result
3.47
KB
-rw-r--r--
myisam_table_io.result
5.65
KB
-rw-r--r--
nesting.result
11.54
KB
-rw-r--r--
no_threads.result
1.82
KB
-rw-r--r--
one_thread_per_con.result
1.35
KB
-rw-r--r--
ortho_iter.result
51.59
KB
-rw-r--r--
part_table_io.result
6.54
KB
-rw-r--r--
pfs_upgrade_event.result
7.48
KB
-rw-r--r--
pfs_upgrade_func.result
7.45
KB
-rw-r--r--
pfs_upgrade_proc.result
7.46
KB
-rw-r--r--
pfs_upgrade_table.result
7.42
KB
-rw-r--r--
pfs_upgrade_view.result
7.44
KB
-rw-r--r--
prepared_statements.result
20.55
KB
-rw-r--r--
prepared_stmts_by_stored_progr...
6.38
KB
-rw-r--r--
privilege.result
36.39
KB
-rw-r--r--
privilege_table_io.result
7.44
KB
-rw-r--r--
processlist.result
8.57
KB
-rw-r--r--
processlist_57.result
13.07
KB
-rw-r--r--
processlist_acl.result
10.36
KB
-rw-r--r--
processlist_anonymous.result
2.4
KB
-rw-r--r--
processlist_no_pfs.result
8.54
KB
-rw-r--r--
processlist_port.result
5.15
KB
-rw-r--r--
processlist_reg_user.result
3.3
KB
-rw-r--r--
query_cache.result
2.28
KB
-rw-r--r--
read_only.result
5.95
KB
-rw-r--r--
relaylog.result
12.62
KB
-rw-r--r--
rollback_table_io.result
3.74
KB
-rw-r--r--
rpl_group_member_stats.result
597
B
-rw-r--r--
rpl_group_members.result
310
B
-rw-r--r--
rpl_gtid_func.result
4.42
KB
-rw-r--r--
rpl_statements.result
13.92
KB
-rw-r--r--
rpl_threads.result
2.45
KB
-rw-r--r--
schema.result
65.31
KB
-rw-r--r--
selects.result
3.68
KB
-rw-r--r--
server_init.result
4.09
KB
-rw-r--r--
setup_actors.result
6.46
KB
-rw-r--r--
setup_actors_enabled.result
5.31
KB
-rw-r--r--
setup_actors_history.result
5.26
KB
-rw-r--r--
setup_consumers_defaults.resul...
882
B
-rw-r--r--
setup_instruments_defaults.res...
2.22
KB
-rw-r--r--
setup_object_table_lock_io.res...
3.9
KB
-rw-r--r--
setup_objects.result
6.44
KB
-rw-r--r--
short_option_1.result
755
B
-rw-r--r--
short_option_2.result
356
B
-rw-r--r--
show_aggregate.result
20.89
KB
-rw-r--r--
show_coverage.result
4.1
KB
-rw-r--r--
show_misc.result
3.49
KB
-rw-r--r--
show_plugin.result
30.45
KB
-rw-r--r--
show_plugin_56.result
29.67
KB
-rw-r--r--
show_sanity.result
31.28
KB
-rw-r--r--
socket_connect.result
5.85
KB
-rw-r--r--
socket_instances_func.result
7.03
KB
-rw-r--r--
socket_instances_func_win.resu...
4.97
KB
-rw-r--r--
socket_summary_by_event_name_f...
3.9
KB
-rw-r--r--
socket_summary_by_instance_fun...
12.19
KB
-rw-r--r--
socket_summary_by_instance_fun...
12.26
KB
-rw-r--r--
stage_mdl_function.result
1.57
KB
-rw-r--r--
stage_mdl_global.result
1.75
KB
-rw-r--r--
stage_mdl_procedure.result
1.6
KB
-rw-r--r--
stage_mdl_table.result
2.1
KB
-rw-r--r--
start_server_1_digest.result
272
B
-rw-r--r--
start_server_disable_idle.resu...
9.02
KB
-rw-r--r--
start_server_disable_stages.re...
8.89
KB
-rw-r--r--
start_server_disable_statement...
10.62
KB
-rw-r--r--
start_server_disable_transacti...
9.89
KB
-rw-r--r--
start_server_disable_waits.res...
9.03
KB
-rw-r--r--
start_server_innodb.result
9.1
KB
-rw-r--r--
start_server_low_digest.result
951
B
-rw-r--r--
start_server_low_digest_sql_le...
772
B
-rw-r--r--
start_server_low_index.result
12.86
KB
-rw-r--r--
start_server_low_table_lock.re...
10.91
KB
-rw-r--r--
start_server_no_account.result
8.18
KB
-rw-r--r--
start_server_no_cond_class.res...
8.42
KB
-rw-r--r--
start_server_no_cond_inst.resu...
8.56
KB
-rw-r--r--
start_server_no_digests.result
3.47
KB
-rw-r--r--
start_server_no_file_class.res...
8.42
KB
-rw-r--r--
start_server_no_file_inst.resu...
8.55
KB
-rw-r--r--
start_server_no_host.result
8.17
KB
-rw-r--r--
start_server_no_index.result
8.96
KB
-rw-r--r--
start_server_no_mdl.result
8.23
KB
-rw-r--r--
start_server_no_memory_class.r...
12.18
KB
-rw-r--r--
start_server_no_mutex_class.re...
8.43
KB
-rw-r--r--
start_server_no_mutex_inst.res...
8.57
KB
-rw-r--r--
start_server_no_prepared_stmts...
9.41
KB
-rw-r--r--
start_server_no_rwlock_class.r...
8.44
KB
-rw-r--r--
start_server_no_rwlock_inst.re...
8.57
KB
-rw-r--r--
start_server_no_setup_actors.r...
8.05
KB
-rw-r--r--
start_server_no_setup_objects....
8.05
KB
-rw-r--r--
start_server_no_socket_class.r...
8.44
KB
-rw-r--r--
start_server_no_socket_inst.re...
8.57
KB
-rw-r--r--
start_server_no_stage_class.re...
8.64
KB
-rw-r--r--
start_server_no_stages_history...
8.13
KB
-rw-r--r--
start_server_no_stages_history...
8.15
KB
-rw-r--r--
start_server_no_statement_clas...
8.67
KB
-rw-r--r--
start_server_no_statements_his...
8.15
KB
-rw-r--r--
start_server_no_statements_his...
8.17
KB
-rw-r--r--
start_server_no_table_hdl.resu...
8.59
KB
-rw-r--r--
start_server_no_table_inst.res...
8.59
KB
-rw-r--r--
start_server_no_table_lock.res...
8.72
KB
-rw-r--r--
start_server_no_thread_class.r...
8.42
KB
-rw-r--r--
start_server_no_thread_inst.re...
8.45
KB
-rw-r--r--
start_server_no_transactions_h...
8.16
KB
-rw-r--r--
start_server_no_transactions_h...
8.17
KB
-rw-r--r--
start_server_no_user.result
8.17
KB
-rw-r--r--
start_server_no_waits_history....
8.13
KB
-rw-r--r--
start_server_no_waits_history_...
8.15
KB
-rw-r--r--
start_server_nothing.result
26.2
KB
-rw-r--r--
start_server_off.result
13.44
KB
-rw-r--r--
start_server_on.result
9.1
KB
-rw-r--r--
start_server_zero_digest_sql_l...
682
B
-rw-r--r--
statement_digest.result
6.59
KB
-rw-r--r--
statement_digest_charset.resul...
991
B
-rw-r--r--
statement_digest_consumers.res...
6.7
KB
-rw-r--r--
statement_digest_consumers2.re...
3.78
KB
-rw-r--r--
statement_digest_long_query.re...
2.9
KB
-rw-r--r--
statement_program_concurrency....
3.96
KB
-rw-r--r--
statement_program_lost_inst.re...
11.83
KB
-rw-r--r--
statement_program_nested.resul...
110.37
KB
-rw-r--r--
statement_program_nesting_even...
55.05
KB
-rw-r--r--
statement_program_non_nested.r...
25.42
KB
-rw-r--r--
status_reprepare.result
1.65
KB
-rw-r--r--
sxlock_func.result
2.5
KB
-rw-r--r--
table_aggregate_global_2u_2t.r...
63.78
KB
-rw-r--r--
table_aggregate_global_2u_3t.r...
68.29
KB
-rw-r--r--
table_aggregate_global_4u_2t.r...
63.75
KB
-rw-r--r--
table_aggregate_global_4u_3t.r...
68.27
KB
-rw-r--r--
table_aggregate_hist_2u_2t.res...
67.07
KB
-rw-r--r--
table_aggregate_hist_2u_3t.res...
73.23
KB
-rw-r--r--
table_aggregate_hist_4u_2t.res...
67.42
KB
-rw-r--r--
table_aggregate_hist_4u_3t.res...
73.65
KB
-rw-r--r--
table_aggregate_off.result
65.5
KB
-rw-r--r--
table_aggregate_thread_2u_2t.r...
63.72
KB
-rw-r--r--
table_aggregate_thread_2u_3t.r...
68.16
KB
-rw-r--r--
table_aggregate_thread_4u_2t.r...
64.05
KB
-rw-r--r--
table_aggregate_thread_4u_3t.r...
68.56
KB
-rw-r--r--
table_io_aggregate_global_2u_2...
63.77
KB
-rw-r--r--
table_io_aggregate_global_2u_3...
68.23
KB
-rw-r--r--
table_io_aggregate_global_4u_2...
63.75
KB
-rw-r--r--
table_io_aggregate_global_4u_3...
68.21
KB
-rw-r--r--
table_io_aggregate_hist_2u_2t....
65.25
KB
-rw-r--r--
table_io_aggregate_hist_2u_3t....
70.53
KB
-rw-r--r--
table_io_aggregate_hist_4u_2t....
65.51
KB
-rw-r--r--
table_io_aggregate_hist_4u_3t....
70.81
KB
-rw-r--r--
table_io_aggregate_thread_2u_2...
63.65
KB
-rw-r--r--
table_io_aggregate_thread_2u_3...
68.08
KB
-rw-r--r--
table_io_aggregate_thread_4u_2...
63.89
KB
-rw-r--r--
table_io_aggregate_thread_4u_3...
68.35
KB
-rw-r--r--
table_lock_aggregate_global_2u...
62.19
KB
-rw-r--r--
table_lock_aggregate_global_2u...
65.9
KB
-rw-r--r--
table_lock_aggregate_global_4u...
62.17
KB
-rw-r--r--
table_lock_aggregate_global_4u...
65.88
KB
-rw-r--r--
table_lock_aggregate_hist_2u_2...
63.91
KB
-rw-r--r--
table_lock_aggregate_hist_2u_3...
68.48
KB
-rw-r--r--
table_lock_aggregate_hist_4u_2...
63.99
KB
-rw-r--r--
table_lock_aggregate_hist_4u_3...
68.58
KB
-rw-r--r--
table_lock_aggregate_thread_2u...
62.23
KB
-rw-r--r--
table_lock_aggregate_thread_2u...
65.92
KB
-rw-r--r--
table_lock_aggregate_thread_4u...
62.3
KB
-rw-r--r--
table_lock_aggregate_thread_4u...
66.02
KB
-rw-r--r--
table_name.result
4.73
KB
-rw-r--r--
table_schema.result
208.92
KB
-rw-r--r--
tampered_perfschema_table1.res...
358
B
-rw-r--r--
temp_table_io.result
4.59
KB
-rw-r--r--
thread_cache.result
896
B
-rw-r--r--
thread_misc.result
62
B
-rw-r--r--
threads_history.result
15.41
KB
-rw-r--r--
threads_innodb.result
1.59
KB
-rw-r--r--
threads_mysql.result
4
KB
-rw-r--r--
threads_mysql_freebsd.result
125
B
-rw-r--r--
threads_mysql_linux.result
125
B
-rw-r--r--
threads_mysql_windows.result
125
B
-rw-r--r--
transaction.result
23.04
KB
-rw-r--r--
transaction_gtid.result
4.81
KB
-rw-r--r--
transaction_nested_events.resu...
40.69
KB
-rw-r--r--
trigger_table_io.result
7.63
KB
-rw-r--r--
unary_digest.result
2.63
KB
-rw-r--r--
user_var_func.result
2.22
KB
-rw-r--r--
view_table_io.result
5.9
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : memory_aggregate_no_h.result
Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. Warnings: Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. Warnings: Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. Warnings: Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. Warnings: Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. show global status like "performance_schema_memory_classes_lost"; Variable_name Value Performance_schema_memory_classes_lost 0 "================== Step 1 ==================" call dump_thread(); username user1 status not found username user2 status not found username user3 status not found username user4 status not found execute dump_memory_account; execute dump_memory_user; execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 1 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 138 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 138 HIGH_NUMBER_OF_BYTES_USED 138 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS "================== con1 connected ==================" "================== Step 2 ==================" call dump_thread(); username user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 username user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 username user2 status not found username user3 status not found username user4 status not found execute dump_memory_account; USER user1 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 execute dump_memory_user; USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 1 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 138 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 138 HIGH_NUMBER_OF_BYTES_USED 138 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 1 1 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS set GLOBAL query_cache_size=1000*1024; Warnings: Warning 1287 '@@query_cache_size' is deprecated and will be removed in a future release. select get_lock("marker_1", 10); get_lock("marker_1", 10) 1 select release_lock("marker_1"); release_lock("marker_1") 1 set @v1 = repeat("a", 1000); set @v2 = repeat("b", 2000); set @v3 = repeat("c", 4000); "================== con1 marker ==================" "================== Step 3 ==================" call dump_thread(); username user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 username user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user2 status not found username user3 status not found username user4 status not found execute dump_memory_account; USER user1 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 execute dump_memory_user; USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 1040384 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 1040384 HIGH_NUMBER_OF_BYTES_USED 1040384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 4 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7141 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 4 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 7141 HIGH_NUMBER_OF_BYTES_USED 7141 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 1 1 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS "================== con2 connected ==================" "================== Step 4 ==================" call dump_thread(); username user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 username user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 username user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 username user3 status not found username user4 status not found execute dump_memory_account; USER user1 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 execute dump_memory_user; USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 1040384 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 1040384 HIGH_NUMBER_OF_BYTES_USED 1040384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 4 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7141 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 4 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 7141 HIGH_NUMBER_OF_BYTES_USED 7141 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 1 1 user2 localhost 1 1 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 1 1 user2 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS set GLOBAL query_cache_size=2000*1024; Warnings: Warning 1287 '@@query_cache_size' is deprecated and will be removed in a future release. select get_lock("marker_2", 10); get_lock("marker_2", 10) 1 select release_lock("marker_2"); release_lock("marker_2") 1 set @v1 = repeat("a", 1000); set @v2 = repeat("b", 2000); set @v3 = repeat("c", 4000); "================== con2 marker ==================" "================== Step 5 ==================" call dump_thread(); username user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 username user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 username user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user3 status not found username user4 status not found execute dump_memory_account; USER user1 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 execute dump_memory_user; USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 6 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 3104768 SUM_NUMBER_OF_BYTES_FREE 1040384 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 2064384 HIGH_NUMBER_OF_BYTES_USED 2064384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 544 SUM_NUMBER_OF_BYTES_FREE 32 LOW_COUNT_USED 0 CURRENT_COUNT_USED 2 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 512 HIGH_NUMBER_OF_BYTES_USED 544 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 7 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 14144 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 7 HIGH_COUNT_USED 7 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 14144 HIGH_NUMBER_OF_BYTES_USED 14144 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 1 1 user2 localhost 1 1 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 1 1 user2 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS truncate table performance_schema.memory_summary_by_thread_by_event_name; "================== MEMORY_BY_THREAD truncated ==================" "================== Step 5b ==================" call dump_thread(); username user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 1 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 256 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 LOW_NUMBER_OF_BYTES_USED 256 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 256 username user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 3 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 7003 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 1 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 256 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 LOW_NUMBER_OF_BYTES_USED 256 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 256 username user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 3 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 7003 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user3 status not found username user4 status not found execute dump_memory_account; USER user1 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 execute dump_memory_user; USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 6 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 3104768 SUM_NUMBER_OF_BYTES_FREE 1040384 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 2064384 HIGH_NUMBER_OF_BYTES_USED 2064384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 544 SUM_NUMBER_OF_BYTES_FREE 32 LOW_COUNT_USED 0 CURRENT_COUNT_USED 2 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 512 HIGH_NUMBER_OF_BYTES_USED 544 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 7 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 14144 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 7 HIGH_COUNT_USED 7 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 14144 HIGH_NUMBER_OF_BYTES_USED 14144 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 1 1 user2 localhost 1 1 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 1 1 user2 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS "================== con3 connected ==================" "================== Step 6 ==================" call dump_thread(); username user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 1 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 256 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 LOW_NUMBER_OF_BYTES_USED 256 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 256 username user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 3 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 7003 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 1 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 256 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 LOW_NUMBER_OF_BYTES_USED 256 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 256 username user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 3 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 7003 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 username user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 username user4 status not found execute dump_memory_account; USER user1 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user3 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 execute dump_memory_user; USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 6 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 3104768 SUM_NUMBER_OF_BYTES_FREE 1040384 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 2064384 HIGH_NUMBER_OF_BYTES_USED 2064384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 544 SUM_NUMBER_OF_BYTES_FREE 32 LOW_COUNT_USED 0 CURRENT_COUNT_USED 2 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 512 HIGH_NUMBER_OF_BYTES_USED 544 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 7 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 14144 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 7 HIGH_COUNT_USED 7 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 14144 HIGH_NUMBER_OF_BYTES_USED 14144 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 1 1 user2 localhost 1 1 user3 localhost 1 1 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 1 1 user2 1 1 user3 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS set GLOBAL query_cache_size=500*1024; Warnings: Warning 1287 '@@query_cache_size' is deprecated and will be removed in a future release. select get_lock("marker_3", 10); get_lock("marker_3", 10) 1 select release_lock("marker_3"); release_lock("marker_3") 1 set @v1 = repeat("a", 1000); set @v2 = repeat("b", 2000); set @v3 = repeat("c", 4000); "================== con3 marker ==================" "================== Step 7 ==================" call dump_thread(); username user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 1 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 256 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 LOW_NUMBER_OF_BYTES_USED 256 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 256 username user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 3 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 7003 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 1 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 256 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 LOW_NUMBER_OF_BYTES_USED 256 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 256 username user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 3 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 7003 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 username user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user4 status not found execute dump_memory_account; USER user1 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user3 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 execute dump_memory_user; USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 9 COUNT_FREE 6 SUM_NUMBER_OF_BYTES_ALLOC 3633152 SUM_NUMBER_OF_BYTES_FREE 3104768 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 528384 HIGH_NUMBER_OF_BYTES_USED 2064384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 6 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 816 SUM_NUMBER_OF_BYTES_FREE 48 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 6 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 768 HIGH_NUMBER_OF_BYTES_USED 816 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 10 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 21147 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 10 HIGH_COUNT_USED 10 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 21147 HIGH_NUMBER_OF_BYTES_USED 21147 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 1 1 user2 localhost 1 1 user3 localhost 1 1 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 1 1 user2 1 1 user3 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS "================== con4/con5 (both user4) connected ==================" "================== Step 8 ==================" call dump_thread(); username user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 1 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 256 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 LOW_NUMBER_OF_BYTES_USED 256 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 256 username user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 3 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 7003 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 1 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 256 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 LOW_NUMBER_OF_BYTES_USED 256 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 256 username user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 3 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 7003 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 username user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 username user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 execute dump_memory_account; USER user1 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user3 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user4 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user4 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 execute dump_memory_user; USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 9 COUNT_FREE 6 SUM_NUMBER_OF_BYTES_ALLOC 3633152 SUM_NUMBER_OF_BYTES_FREE 3104768 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 528384 HIGH_NUMBER_OF_BYTES_USED 2064384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 6 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 816 SUM_NUMBER_OF_BYTES_FREE 48 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 6 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 768 HIGH_NUMBER_OF_BYTES_USED 816 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 10 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 21147 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 10 HIGH_COUNT_USED 10 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 21147 HIGH_NUMBER_OF_BYTES_USED 21147 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 1 1 user2 localhost 1 1 user3 localhost 1 1 user4 localhost 2 2 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 1 1 user2 1 1 user3 1 1 user4 2 2 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS set GLOBAL query_cache_size=4000*1024; Warnings: Warning 1287 '@@query_cache_size' is deprecated and will be removed in a future release. select get_lock("marker_4", 10); get_lock("marker_4", 10) 1 select release_lock("marker_4"); release_lock("marker_4") 1 set @v1 = repeat("a", 1000); set @v2 = repeat("b", 2000); set @v3 = repeat("c", 4000); select get_lock("marker_5", 10); get_lock("marker_5", 10) 1 select release_lock("marker_5"); release_lock("marker_5") 1 set @v1 = repeat("a", 1000); set @v2 = repeat("b", 2000); set @v3 = repeat("c", 4000); "================== con4/con5 marker ==================" "================== Step 9 ==================" call dump_thread(); username user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 1 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 256 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 LOW_NUMBER_OF_BYTES_USED 256 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 256 username user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 3 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 7003 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 1 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 256 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 LOW_NUMBER_OF_BYTES_USED 256 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 256 username user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 3 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 7003 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 username user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 username user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 execute dump_memory_account; USER user1 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user3 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user4 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 544 SUM_NUMBER_OF_BYTES_FREE 32 LOW_COUNT_USED 0 CURRENT_COUNT_USED 2 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 512 HIGH_NUMBER_OF_BYTES_USED 544 USER user4 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 14006 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 6 HIGH_COUNT_USED 6 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 14006 HIGH_NUMBER_OF_BYTES_USED 14006 execute dump_memory_user; USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 544 SUM_NUMBER_OF_BYTES_FREE 32 LOW_COUNT_USED 0 CURRENT_COUNT_USED 2 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 512 HIGH_NUMBER_OF_BYTES_USED 544 USER user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 14006 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 6 HIGH_COUNT_USED 6 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 14006 HIGH_NUMBER_OF_BYTES_USED 14006 execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 12 COUNT_FREE 9 SUM_NUMBER_OF_BYTES_ALLOC 7745536 SUM_NUMBER_OF_BYTES_FREE 3633152 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 4112384 HIGH_NUMBER_OF_BYTES_USED 4112384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 5 SUM_NUMBER_OF_BYTES_ALLOC 1360 SUM_NUMBER_OF_BYTES_FREE 80 LOW_COUNT_USED 0 CURRENT_COUNT_USED 5 HIGH_COUNT_USED 10 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 1280 HIGH_NUMBER_OF_BYTES_USED 1360 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 35153 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 16 HIGH_COUNT_USED 16 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 35153 HIGH_NUMBER_OF_BYTES_USED 35153 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 1 1 user2 localhost 1 1 user3 localhost 1 1 user4 localhost 2 2 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 1 1 user2 1 1 user3 1 1 user4 2 2 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS "================== con1/con5 disconnected ==================" "================== Step 10 ==================" call dump_thread(); username user1 status not found username user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 1 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 256 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 LOW_NUMBER_OF_BYTES_USED 256 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 256 username user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 3 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 7003 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 username user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 username user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 execute dump_memory_account; USER user1 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user3 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user4 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 544 SUM_NUMBER_OF_BYTES_FREE 288 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 544 USER user4 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 14006 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 6 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 14006 execute dump_memory_user; USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 544 SUM_NUMBER_OF_BYTES_FREE 288 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 544 USER user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 14006 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 6 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 14006 execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 12 COUNT_FREE 9 SUM_NUMBER_OF_BYTES_ALLOC 7745536 SUM_NUMBER_OF_BYTES_FREE 3633152 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 4112384 HIGH_NUMBER_OF_BYTES_USED 4112384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 7 SUM_NUMBER_OF_BYTES_ALLOC 1360 SUM_NUMBER_OF_BYTES_FREE 592 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 10 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 768 HIGH_NUMBER_OF_BYTES_USED 1360 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 6 SUM_NUMBER_OF_BYTES_ALLOC 35153 SUM_NUMBER_OF_BYTES_FREE 14006 LOW_COUNT_USED 1 CURRENT_COUNT_USED 10 HIGH_COUNT_USED 16 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 21147 HIGH_NUMBER_OF_BYTES_USED 35153 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 0 1 user2 localhost 1 1 user3 localhost 1 1 user4 localhost 1 2 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 0 1 user2 1 1 user3 1 1 user4 1 2 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS "================== con2 disconnected ==================" "================== Step 11 ==================" call dump_thread(); username user1 status not found username user2 status not found username user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 username user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 username user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 username user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 execute dump_memory_account; USER user1 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user3 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user4 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 544 SUM_NUMBER_OF_BYTES_FREE 288 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 544 USER user4 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 14006 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 6 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 14006 execute dump_memory_user; USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 USER user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 544 SUM_NUMBER_OF_BYTES_FREE 288 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 544 USER user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 14006 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 6 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 14006 execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 12 COUNT_FREE 9 SUM_NUMBER_OF_BYTES_ALLOC 7745536 SUM_NUMBER_OF_BYTES_FREE 3633152 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 4112384 HIGH_NUMBER_OF_BYTES_USED 4112384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 8 SUM_NUMBER_OF_BYTES_ALLOC 1360 SUM_NUMBER_OF_BYTES_FREE 848 LOW_COUNT_USED 0 CURRENT_COUNT_USED 2 HIGH_COUNT_USED 10 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 512 HIGH_NUMBER_OF_BYTES_USED 1360 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 9 SUM_NUMBER_OF_BYTES_ALLOC 35153 SUM_NUMBER_OF_BYTES_FREE 21009 LOW_COUNT_USED 1 CURRENT_COUNT_USED 7 HIGH_COUNT_USED 16 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 14144 HIGH_NUMBER_OF_BYTES_USED 35153 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 0 1 user2 localhost 0 1 user3 localhost 1 1 user4 localhost 1 2 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 0 1 user2 0 1 user3 1 1 user4 1 2 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS "================== con3 disconnected ==================" "================== Step 12 ==================" call dump_thread(); username user1 status not found username user2 status not found username user3 status not found username user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 272 username user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 7003 execute dump_memory_account; USER user1 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user3 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user4 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 544 SUM_NUMBER_OF_BYTES_FREE 288 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 544 USER user4 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 14006 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 6 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 14006 execute dump_memory_user; USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 544 SUM_NUMBER_OF_BYTES_FREE 288 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 544 USER user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 14006 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 6 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 7003 HIGH_NUMBER_OF_BYTES_USED 14006 execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 12 COUNT_FREE 9 SUM_NUMBER_OF_BYTES_ALLOC 7745536 SUM_NUMBER_OF_BYTES_FREE 3633152 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 4112384 HIGH_NUMBER_OF_BYTES_USED 4112384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 9 SUM_NUMBER_OF_BYTES_ALLOC 1360 SUM_NUMBER_OF_BYTES_FREE 1104 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 10 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 256 HIGH_NUMBER_OF_BYTES_USED 1360 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 12 SUM_NUMBER_OF_BYTES_ALLOC 35153 SUM_NUMBER_OF_BYTES_FREE 28012 LOW_COUNT_USED 1 CURRENT_COUNT_USED 4 HIGH_COUNT_USED 16 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 7141 HIGH_NUMBER_OF_BYTES_USED 35153 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 0 1 user2 localhost 0 1 user3 localhost 0 1 user4 localhost 1 2 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 1 2 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS "================== con4 disconnected ==================" "================== Step 13 ==================" call dump_thread(); username user1 status not found username user2 status not found username user3 status not found username user4 status not found execute dump_memory_account; USER user1 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user3 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user4 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 4 SUM_NUMBER_OF_BYTES_ALLOC 544 SUM_NUMBER_OF_BYTES_FREE 544 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 544 USER user4 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 6 SUM_NUMBER_OF_BYTES_ALLOC 14006 SUM_NUMBER_OF_BYTES_FREE 14006 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 6 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 14006 execute dump_memory_user; USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 4 SUM_NUMBER_OF_BYTES_ALLOC 544 SUM_NUMBER_OF_BYTES_FREE 544 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 544 USER user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 6 SUM_NUMBER_OF_BYTES_ALLOC 14006 SUM_NUMBER_OF_BYTES_FREE 14006 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 6 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 14006 execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 12 COUNT_FREE 9 SUM_NUMBER_OF_BYTES_ALLOC 7745536 SUM_NUMBER_OF_BYTES_FREE 3633152 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 4112384 HIGH_NUMBER_OF_BYTES_USED 4112384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 10 SUM_NUMBER_OF_BYTES_ALLOC 1360 SUM_NUMBER_OF_BYTES_FREE 1360 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 10 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 1360 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 15 SUM_NUMBER_OF_BYTES_ALLOC 35153 SUM_NUMBER_OF_BYTES_FREE 35015 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 16 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 138 HIGH_NUMBER_OF_BYTES_USED 35153 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 0 1 user2 localhost 0 1 user3 localhost 0 1 user4 localhost 0 2 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 2 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS truncate performance_schema.memory_summary_by_thread_by_event_name; "================== MEMORY_BY_THREAD truncated ==================" "================== Step 14 ==================" call dump_thread(); username user1 status not found username user2 status not found username user3 status not found username user4 status not found execute dump_memory_account; USER user1 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user3 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user4 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 4 SUM_NUMBER_OF_BYTES_ALLOC 544 SUM_NUMBER_OF_BYTES_FREE 544 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 544 USER user4 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 6 SUM_NUMBER_OF_BYTES_ALLOC 14006 SUM_NUMBER_OF_BYTES_FREE 14006 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 6 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 14006 execute dump_memory_user; USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 4 SUM_NUMBER_OF_BYTES_ALLOC 544 SUM_NUMBER_OF_BYTES_FREE 544 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 544 USER user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 6 SUM_NUMBER_OF_BYTES_ALLOC 14006 SUM_NUMBER_OF_BYTES_FREE 14006 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 6 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 14006 execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 12 COUNT_FREE 9 SUM_NUMBER_OF_BYTES_ALLOC 7745536 SUM_NUMBER_OF_BYTES_FREE 3633152 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 4112384 HIGH_NUMBER_OF_BYTES_USED 4112384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 10 SUM_NUMBER_OF_BYTES_ALLOC 1360 SUM_NUMBER_OF_BYTES_FREE 1360 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 10 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 1360 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 15 SUM_NUMBER_OF_BYTES_ALLOC 35153 SUM_NUMBER_OF_BYTES_FREE 35015 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 16 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 138 HIGH_NUMBER_OF_BYTES_USED 35153 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 0 1 user2 localhost 0 1 user3 localhost 0 1 user4 localhost 0 2 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 2 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS truncate performance_schema.memory_summary_by_account_by_event_name; "================== MEMORY_BY_ACCOUNT truncated ==================" "================== Step 15 ==================" call dump_thread(); username user1 status not found username user2 status not found username user3 status not found username user4 status not found execute dump_memory_account; USER user1 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user2 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user3 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user4 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user4 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 execute dump_memory_user; USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 SUM_NUMBER_OF_BYTES_ALLOC 272 SUM_NUMBER_OF_BYTES_FREE 272 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 272 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 SUM_NUMBER_OF_BYTES_ALLOC 7003 SUM_NUMBER_OF_BYTES_FREE 7003 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 7003 USER user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 4 SUM_NUMBER_OF_BYTES_ALLOC 544 SUM_NUMBER_OF_BYTES_FREE 544 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 544 USER user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 6 SUM_NUMBER_OF_BYTES_ALLOC 14006 SUM_NUMBER_OF_BYTES_FREE 14006 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 6 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 14006 execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 12 COUNT_FREE 9 SUM_NUMBER_OF_BYTES_ALLOC 7745536 SUM_NUMBER_OF_BYTES_FREE 3633152 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 4112384 HIGH_NUMBER_OF_BYTES_USED 4112384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 10 SUM_NUMBER_OF_BYTES_ALLOC 1360 SUM_NUMBER_OF_BYTES_FREE 1360 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 10 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 1360 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 15 SUM_NUMBER_OF_BYTES_ALLOC 35153 SUM_NUMBER_OF_BYTES_FREE 35015 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 16 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 138 HIGH_NUMBER_OF_BYTES_USED 35153 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 0 1 user2 localhost 0 1 user3 localhost 0 1 user4 localhost 0 2 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 2 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS truncate performance_schema.memory_summary_by_user_by_event_name; "================== MEMORY_BY_USER truncated ==================" "================== Step 16 ==================" call dump_thread(); username user1 status not found username user2 status not found username user3 status not found username user4 status not found execute dump_memory_account; USER user1 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user2 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user3 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user4 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user4 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 execute dump_memory_user; USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 12 COUNT_FREE 9 SUM_NUMBER_OF_BYTES_ALLOC 7745536 SUM_NUMBER_OF_BYTES_FREE 3633152 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 4112384 HIGH_NUMBER_OF_BYTES_USED 4112384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 10 SUM_NUMBER_OF_BYTES_ALLOC 1360 SUM_NUMBER_OF_BYTES_FREE 1360 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 10 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 1360 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 15 SUM_NUMBER_OF_BYTES_ALLOC 35153 SUM_NUMBER_OF_BYTES_FREE 35015 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 16 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 138 HIGH_NUMBER_OF_BYTES_USED 35153 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 0 1 user2 localhost 0 1 user3 localhost 0 1 user4 localhost 0 2 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 2 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS truncate performance_schema.memory_summary_by_host_by_event_name; "================== MEMORY_BY_HOST truncated ==================" "================== Step 17 ==================" call dump_thread(); username user1 status not found username user2 status not found username user3 status not found username user4 status not found execute dump_memory_account; USER user1 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user2 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user3 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user4 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user4 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 execute dump_memory_user; USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 12 COUNT_FREE 9 SUM_NUMBER_OF_BYTES_ALLOC 7745536 SUM_NUMBER_OF_BYTES_FREE 3633152 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 4112384 HIGH_NUMBER_OF_BYTES_USED 4112384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 10 SUM_NUMBER_OF_BYTES_ALLOC 1360 SUM_NUMBER_OF_BYTES_FREE 1360 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 10 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 1360 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 15 SUM_NUMBER_OF_BYTES_ALLOC 35153 SUM_NUMBER_OF_BYTES_FREE 35015 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 16 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 138 HIGH_NUMBER_OF_BYTES_USED 35153 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 0 1 user2 localhost 0 1 user3 localhost 0 1 user4 localhost 0 2 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 2 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS truncate performance_schema.memory_summary_global_by_event_name; "================== MEMORY_GLOBAL truncated ==================" "================== Step 18 ==================" call dump_thread(); username user1 status not found username user2 status not found username user3 status not found username user4 status not found execute dump_memory_account; USER user1 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user2 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user3 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user4 HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user4 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 execute dump_memory_user; USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 4112384 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 3 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 4112384 CURRENT_NUMBER_OF_BYTES_USED 4112384 HIGH_NUMBER_OF_BYTES_USED 4112384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 1 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 138 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 138 HIGH_NUMBER_OF_BYTES_USED 138 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 0 1 user2 localhost 0 1 user3 localhost 0 1 user4 localhost 0 2 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 2 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS truncate performance_schema.accounts; "================== ACCOUNTS truncated ==================" "================== Step 19 ==================" call dump_thread(); username user1 status not found username user2 status not found username user3 status not found username user4 status not found execute dump_memory_account; execute dump_memory_user; USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 USER user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 4112384 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 3 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 4112384 CURRENT_NUMBER_OF_BYTES_USED 4112384 HIGH_NUMBER_OF_BYTES_USED 4112384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 1 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 138 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 138 HIGH_NUMBER_OF_BYTES_USED 138 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 2 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS truncate performance_schema.users; "================== USERS truncated ==================" "================== Step 20 ==================" call dump_thread(); username user1 status not found username user2 status not found username user3 status not found username user4 status not found execute dump_memory_account; execute dump_memory_user; execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 4112384 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 3 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 4112384 CURRENT_NUMBER_OF_BYTES_USED 4112384 HIGH_NUMBER_OF_BYTES_USED 4112384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 1 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 138 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 138 HIGH_NUMBER_OF_BYTES_USED 138 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS truncate performance_schema.hosts; "================== HOSTS truncated ==================" "================== Step 21 ==================" call dump_thread(); username user1 status not found username user2 status not found username user3 status not found username user4 status not found execute dump_memory_account; execute dump_memory_user; execute dump_memory_host; execute dump_memory_global; EVENT_NAME memory/sql/Query_cache COUNT_ALLOC 3 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 4112384 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 3 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 3 LOW_NUMBER_OF_BYTES_USED 4112384 CURRENT_NUMBER_OF_BYTES_USED 4112384 HIGH_NUMBER_OF_BYTES_USED 4112384 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 0 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 CURRENT_COUNT_USED 0 HIGH_COUNT_USED 0 LOW_NUMBER_OF_BYTES_USED 0 CURRENT_NUMBER_OF_BYTES_USED 0 HIGH_NUMBER_OF_BYTES_USED 0 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 1 COUNT_FREE 0 SUM_NUMBER_OF_BYTES_ALLOC 138 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 LOW_NUMBER_OF_BYTES_USED 138 CURRENT_NUMBER_OF_BYTES_USED 138 HIGH_NUMBER_OF_BYTES_USED 138 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 execute dump_users; USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS Warnings: Warning 1287 '@@query_cache_size' is deprecated and will be removed in a future release.
Close