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 | : 18.119.112.17
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 : table_io_aggregate_hist_4u_2t.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. update performance_schema.setup_instruments set enabled='NO' where name='wait/lock/table/sql/handler'; delete from performance_schema.setup_objects where object_name='t2'; select * from performance_schema.setup_actors order by USER, HOST, ROLE; HOST USER ROLE ENABLED HISTORY localhost user1 % YES YES localhost user2 % YES YES localhost user3 % YES YES localhost user4 % YES YES select * from performance_schema.setup_objects order by object_type, object_schema, object_name; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED TABLE test t1 YES YES TABLE test t3 YES NO select * from performance_schema.setup_consumers; NAME ENABLED events_stages_current YES events_stages_history YES events_stages_history_long YES events_statements_current YES events_statements_history YES events_statements_history_long YES events_transactions_current YES events_transactions_history YES events_transactions_history_long YES events_waits_current YES events_waits_history YES events_waits_history_long YES global_instrumentation YES thread_instrumentation YES statements_digest YES flush tables; truncate performance_schema.objects_summary_global_by_type; truncate performance_schema.table_io_waits_summary_by_index_usage; truncate performance_schema.table_io_waits_summary_by_table; truncate performance_schema.table_lock_waits_summary_by_table; truncate performance_schema.events_waits_summary_by_thread_by_event_name; truncate performance_schema.events_waits_summary_by_account_by_event_name; truncate performance_schema.events_waits_summary_by_user_by_event_name; truncate performance_schema.events_waits_summary_by_host_by_event_name; truncate performance_schema.events_waits_summary_global_by_event_name; truncate performance_schema.events_waits_history_long; show global variables like "performance_schema%"; Variable_name Value performance_schema ON performance_schema_accounts_size 100 performance_schema_digests_size 200 performance_schema_events_stages_history_long_size 1000 performance_schema_events_stages_history_size 10 performance_schema_events_statements_history_long_size 1000 performance_schema_events_statements_history_size 10 performance_schema_events_transactions_history_long_size 1000 performance_schema_events_transactions_history_size 10 performance_schema_events_waits_history_long_size 10000 performance_schema_events_waits_history_size 10 performance_schema_hosts_size 100 performance_schema_max_cond_classes 80 performance_schema_max_cond_instances -1 performance_schema_max_digest_length 1024 performance_schema_max_file_classes 80 performance_schema_max_file_handles 32768 performance_schema_max_file_instances -1 performance_schema_max_index_stat -1 performance_schema_max_memory_classes 320 performance_schema_max_metadata_locks -1 performance_schema_max_mutex_classes 210 performance_schema_max_mutex_instances -1 performance_schema_max_prepared_statements_instances -1 performance_schema_max_program_instances -1 performance_schema_max_rwlock_classes 50 performance_schema_max_rwlock_instances -1 performance_schema_max_socket_classes 10 performance_schema_max_socket_instances -1 performance_schema_max_sql_text_length 1024 performance_schema_max_stage_classes 150 performance_schema_max_statement_classes 193 performance_schema_max_statement_stack 10 performance_schema_max_table_handles -1 performance_schema_max_table_instances -1 performance_schema_max_table_lock_stat -1 performance_schema_max_thread_classes 50 performance_schema_max_thread_instances -1 performance_schema_session_connect_attrs_size 2048 performance_schema_setup_actors_size 100 performance_schema_setup_objects_size 100 performance_schema_show_processlist OFF performance_schema_users_size 100 show global status like "performance_schema%"; Variable_name Value Performance_schema_accounts_lost 0 Performance_schema_cond_classes_lost 0 Performance_schema_cond_instances_lost 0 Performance_schema_digest_lost 0 Performance_schema_file_classes_lost 0 Performance_schema_file_handles_lost 0 Performance_schema_file_instances_lost 0 Performance_schema_hosts_lost 0 Performance_schema_index_stat_lost 0 Performance_schema_locker_lost 0 Performance_schema_memory_classes_lost 0 Performance_schema_metadata_lock_lost 0 Performance_schema_mutex_classes_lost 0 Performance_schema_mutex_instances_lost 0 Performance_schema_nested_statement_lost 0 Performance_schema_prepared_statements_lost 0 Performance_schema_program_lost 0 Performance_schema_rwlock_classes_lost 0 Performance_schema_rwlock_instances_lost 0 Performance_schema_session_connect_attrs_lost 0 Performance_schema_socket_classes_lost 0 Performance_schema_socket_instances_lost 0 Performance_schema_stage_classes_lost 0 Performance_schema_statement_classes_lost 0 Performance_schema_table_handles_lost 0 Performance_schema_table_instances_lost 0 Performance_schema_table_lock_stat_lost 0 Performance_schema_thread_classes_lost 0 Performance_schema_thread_instances_lost 0 Performance_schema_users_lost 0 "================== Step 1 ==================" call dump_thread(); username status user1 not found username status user2 not found username status user3 not found username status user4 not found execute dump_waits_account; user host event_name count_star execute dump_waits_user; user event_name count_star execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 0 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 0 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 0 0 0 0 0 0 0 TABLE test t3 index_b 0 0 0 0 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 0 0 0 0 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 0 TABLE test t2 0 TABLE test t3 0 select concat(current_user(), " is connected") as status; status user1@localhost is connected "================== Step 2 ==================" call dump_thread(); username event_name count_star user1 wait/io/table/sql/handler 0 user1 wait/lock/table/sql/handler 0 username status user2 not found username status user3 not found username status user4 not found execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 0 user1 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 0 user1 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 0 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 0 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 0 0 0 0 0 0 0 TABLE test t3 index_b 0 0 0 0 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 0 0 0 0 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 0 TABLE test t2 0 TABLE test t3 0 insert into test.t1 set a=101, b=1, c=1; insert into test.t2 set a=102, b=2, c=2; insert into test.t2 set a=103, b=3, c=3; insert into test.t3 set a=104, b=4, c=4; insert into test.t3 set a=105, b=5, c=5; insert into test.t3 set a=106, b=6, c=6; select * from test.t1; a b c d 101 1 1 0 select * from test.t2; a b c d 102 2 2 0 103 3 3 0 select * from test.t3; a b c d 104 4 4 0 105 5 5 0 106 6 6 0 update test.t1 set d=d+1; update test.t2 set d=d+1; update test.t3 set d=d+1; update test.t1 set d=d+1 where a=101; update test.t2 set d=d+1 where a=101; update test.t3 set d=d+1 where a=101; select * from test.t1 force index(index_b) where b=5; a b c d select * from test.t2 force index(index_b) where b=5; a b c d select * from test.t3 force index(index_b) where b=5; a b c d 105 5 5 1 "================== con1 marker ==================" "================== Step 3-A ==================" call dump_thread(); username event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 username status user2 not found username status user3 not found username status user4 not found execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 22 user1 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 22 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 22 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 7 TABLE test t1 wait/io/table/sql/handler 15 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 4 3 1 3 1 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 3 1 2 1 0 2 0 TABLE test t3 NULL 10 7 3 7 3 0 0 TABLE test t3 index_b 1 1 0 1 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 4 1 3 1 0 3 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 7 4 3 4 1 2 0 TABLE test t3 15 9 6 9 3 3 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 7 TABLE test t2 0 TABLE test t3 15 flush tables; "================== con1 FLUSH ==================" "================== Step 3-B ==================" call dump_thread(); username event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 username status user2 not found username status user3 not found username status user4 not found execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 22 user1 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 22 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 22 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 7 TABLE test t1 wait/io/table/sql/handler 15 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 4 3 1 3 1 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 3 1 2 1 0 2 0 TABLE test t3 NULL 10 7 3 7 3 0 0 TABLE test t3 index_b 1 1 0 1 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 4 1 3 1 0 3 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 7 4 3 4 1 2 0 TABLE test t3 15 9 6 9 3 3 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 7 TABLE test t2 0 TABLE test t3 15 select concat(current_user(), " is connected") as status; status user2@localhost is connected "================== Step 4 ==================" call dump_thread(); username event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 username event_name count_star user2 wait/io/table/sql/handler 0 user2 wait/lock/table/sql/handler 0 username status user3 not found username status user4 not found execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 22 user1 localhost wait/lock/table/sql/handler 0 user2 localhost wait/io/table/sql/handler 0 user2 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 user2 wait/io/table/sql/handler 0 user2 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 22 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 22 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 7 TABLE test t1 wait/io/table/sql/handler 15 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 4 3 1 3 1 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 3 1 2 1 0 2 0 TABLE test t3 NULL 10 7 3 7 3 0 0 TABLE test t3 index_b 1 1 0 1 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 4 1 3 1 0 3 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 7 4 3 4 1 2 0 TABLE test t3 15 9 6 9 3 3 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 7 TABLE test t2 0 TABLE test t3 15 insert into test.t1 set a=201, b=1, c=1; insert into test.t2 set a=202, b=2, c=2; insert into test.t2 set a=203, b=3, c=3; insert into test.t3 set a=204, b=4, c=4; insert into test.t3 set a=205, b=5, c=5; insert into test.t3 set a=206, b=6, c=6; select * from test.t1; a b c d 101 1 1 2 201 1 1 0 select * from test.t2; a b c d 102 2 2 1 103 3 3 1 202 2 2 0 203 3 3 0 select * from test.t3; a b c d 104 4 4 1 105 5 5 1 106 6 6 1 204 4 4 0 205 5 5 0 206 6 6 0 update test.t1 set d=d+1; update test.t2 set d=d+1; update test.t3 set d=d+1; update test.t1 set d=d+1 where a=201; update test.t2 set d=d+1 where a=201; update test.t3 set d=d+1 where a=201; select * from test.t1 force index(index_b) where b=5; a b c d select * from test.t2 force index(index_b) where b=5; a b c d select * from test.t3 force index(index_b) where b=5; a b c d 105 5 5 2 205 5 5 1 "================== con2 marker ==================" "================== Step 5 ==================" call dump_thread(); username event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 username event_name count_star user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 username status user3 not found username status user4 not found execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 22 user1 localhost wait/lock/table/sql/handler 0 user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 57 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 57 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 17 TABLE test t1 wait/io/table/sql/handler 40 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 10 8 2 8 2 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 7 2 5 2 0 5 0 TABLE test t3 NULL 26 20 6 20 6 0 0 TABLE test t3 index_b 3 3 0 3 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 11 2 9 2 0 9 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 17 10 7 10 2 5 0 TABLE test t3 40 25 15 25 6 9 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 17 TABLE test t2 0 TABLE test t3 40 select concat(current_user(), " is connected") as status; status user3@localhost is connected "================== Step 6 ==================" call dump_thread(); username event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 username event_name count_star user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 username event_name count_star user3 wait/io/table/sql/handler 0 user3 wait/lock/table/sql/handler 0 username status user4 not found execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 22 user1 localhost wait/lock/table/sql/handler 0 user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 user3 localhost wait/io/table/sql/handler 0 user3 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 user3 wait/io/table/sql/handler 0 user3 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 57 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 57 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 17 TABLE test t1 wait/io/table/sql/handler 40 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 10 8 2 8 2 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 7 2 5 2 0 5 0 TABLE test t3 NULL 26 20 6 20 6 0 0 TABLE test t3 index_b 3 3 0 3 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 11 2 9 2 0 9 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 17 10 7 10 2 5 0 TABLE test t3 40 25 15 25 6 9 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 17 TABLE test t2 0 TABLE test t3 40 insert into test.t1 set a=301, b=1, c=1; insert into test.t2 set a=302, b=2, c=2; insert into test.t2 set a=303, b=3, c=3; insert into test.t3 set a=304, b=4, c=4; insert into test.t3 set a=305, b=5, c=5; insert into test.t3 set a=306, b=6, c=6; select * from test.t1; a b c d 101 1 1 3 201 1 1 2 301 1 1 0 select * from test.t2; a b c d 102 2 2 2 103 3 3 2 202 2 2 1 203 3 3 1 302 2 2 0 303 3 3 0 select * from test.t3; a b c d 104 4 4 2 105 5 5 2 106 6 6 2 204 4 4 1 205 5 5 1 206 6 6 1 304 4 4 0 305 5 5 0 306 6 6 0 update test.t1 set d=d+1; update test.t2 set d=d+1; update test.t3 set d=d+1; update test.t1 set d=d+1 where a=301; update test.t2 set d=d+1 where a=301; update test.t3 set d=d+1 where a=301; select * from test.t1 force index(index_b) where b=5; a b c d select * from test.t2 force index(index_b) where b=5; a b c d select * from test.t3 force index(index_b) where b=5; a b c d 105 5 5 3 205 5 5 2 305 5 5 1 "================== con3 marker ==================" "================== Step 7 ==================" call dump_thread(); username event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 username event_name count_star user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 username event_name count_star user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 username status user4 not found execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 22 user1 localhost wait/lock/table/sql/handler 0 user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 105 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 105 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 30 TABLE test t1 wait/io/table/sql/handler 75 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 18 15 3 15 3 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 12 3 9 3 0 9 0 TABLE test t3 NULL 48 39 9 39 9 0 0 TABLE test t3 index_b 6 6 0 6 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 21 3 18 3 0 18 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 30 18 12 18 3 9 0 TABLE test t3 75 48 27 48 9 18 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 30 TABLE test t2 0 TABLE test t3 75 select concat(current_user(), " is connected") as status; status user4@localhost is connected "================== Step 8 ==================" call dump_thread(); username event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 username event_name count_star user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 username event_name count_star user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 username event_name count_star user4 wait/io/table/sql/handler 0 user4 wait/lock/table/sql/handler 0 execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 22 user1 localhost wait/lock/table/sql/handler 0 user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 user4 localhost wait/io/table/sql/handler 0 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 user4 wait/io/table/sql/handler 0 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 105 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 105 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 30 TABLE test t1 wait/io/table/sql/handler 75 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 18 15 3 15 3 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 12 3 9 3 0 9 0 TABLE test t3 NULL 48 39 9 39 9 0 0 TABLE test t3 index_b 6 6 0 6 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 21 3 18 3 0 18 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 30 18 12 18 3 9 0 TABLE test t3 75 48 27 48 9 18 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 30 TABLE test t2 0 TABLE test t3 75 insert into test.t1 set a=401, b=1, c=1; insert into test.t2 set a=402, b=2, c=2; insert into test.t2 set a=403, b=3, c=3; insert into test.t3 set a=404, b=4, c=4; insert into test.t3 set a=405, b=5, c=5; insert into test.t3 set a=406, b=6, c=6; select * from test.t1; a b c d 101 1 1 4 201 1 1 3 301 1 1 2 401 1 1 0 select * from test.t2; a b c d 102 2 2 3 103 3 3 3 202 2 2 2 203 3 3 2 302 2 2 1 303 3 3 1 402 2 2 0 403 3 3 0 select * from test.t3; a b c d 104 4 4 3 105 5 5 3 106 6 6 3 204 4 4 2 205 5 5 2 206 6 6 2 304 4 4 1 305 5 5 1 306 6 6 1 404 4 4 0 405 5 5 0 406 6 6 0 update test.t1 set d=d+1; update test.t2 set d=d+1; update test.t3 set d=d+1; update test.t1 set d=d+1 where a=401; update test.t2 set d=d+1 where a=401; update test.t3 set d=d+1 where a=401; select * from test.t1 force index(index_b) where b=5; a b c d select * from test.t2 force index(index_b) where b=5; a b c d select * from test.t3 force index(index_b) where b=5; a b c d 105 5 5 4 205 5 5 3 305 5 5 2 405 5 5 1 "================== con4 marker ==================" "================== Step 9 ==================" call dump_thread(); username event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 username event_name count_star user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 username event_name count_star user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 username event_name count_star user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 22 user1 localhost wait/lock/table/sql/handler 0 user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 user4 localhost wait/io/table/sql/handler 61 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 166 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 166 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 46 TABLE test t1 wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 28 24 4 24 4 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 18 4 14 4 0 14 0 TABLE test t3 NULL 76 64 12 64 12 0 0 TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 34 4 30 4 0 30 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 46 28 18 28 4 14 0 TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 46 TABLE test t2 0 TABLE test t3 120 lock tables test.t1 read, test.t2 read, test.t3 read; unlock tables; lock tables test.t1 write, test.t2 write, test.t3 write; unlock tables; "================== con1 marker ==================" "================== Step 10 ==================" call dump_thread(); username event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 username event_name count_star user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 username event_name count_star user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 username event_name count_star user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 22 user1 localhost wait/lock/table/sql/handler 0 user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 user4 localhost wait/io/table/sql/handler 61 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 166 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 166 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 46 TABLE test t1 wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 28 24 4 24 4 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 18 4 14 4 0 14 0 TABLE test t3 NULL 76 64 12 64 12 0 0 TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 34 4 30 4 0 30 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 46 28 18 28 4 14 0 TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 46 TABLE test t2 0 TABLE test t3 120 flush tables; "================== flush marker ==================" "================== Step 11 ==================" call dump_thread(); username event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 username event_name count_star user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 username event_name count_star user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 username event_name count_star user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 22 user1 localhost wait/lock/table/sql/handler 0 user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 user4 localhost wait/io/table/sql/handler 61 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 166 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 166 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 46 TABLE test t1 wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 28 24 4 24 4 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 18 4 14 4 0 14 0 TABLE test t3 NULL 76 64 12 64 12 0 0 TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 34 4 30 4 0 30 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 46 28 18 28 4 14 0 TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 46 TABLE test t2 0 TABLE test t3 120 set global read_only=1; set global read_only=0; "================== global read_only marker ==================" "================== Step 12 ==================" call dump_thread(); username event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 username event_name count_star user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 username event_name count_star user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 username event_name count_star user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 22 user1 localhost wait/lock/table/sql/handler 0 user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 user4 localhost wait/io/table/sql/handler 61 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 166 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 166 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 46 TABLE test t1 wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 28 24 4 24 4 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 18 4 14 4 0 14 0 TABLE test t3 NULL 76 64 12 64 12 0 0 TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 34 4 30 4 0 30 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 46 28 18 28 4 14 0 TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 46 TABLE test t2 0 TABLE test t3 120 "================== con1 disconnected ==================" "================== Step 13 ==================" call dump_thread(); username status user1 not found username event_name count_star user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 username event_name count_star user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 username event_name count_star user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 22 user1 localhost wait/lock/table/sql/handler 0 user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 user4 localhost wait/io/table/sql/handler 61 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 166 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 166 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 46 TABLE test t1 wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 28 24 4 24 4 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 18 4 14 4 0 14 0 TABLE test t3 NULL 76 64 12 64 12 0 0 TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 34 4 30 4 0 30 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 46 28 18 28 4 14 0 TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 46 TABLE test t2 0 TABLE test t3 120 "================== con2 disconnected ==================" "================== Step 14 ==================" call dump_thread(); username status user1 not found username status user2 not found username event_name count_star user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 username event_name count_star user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 22 user1 localhost wait/lock/table/sql/handler 0 user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 user4 localhost wait/io/table/sql/handler 61 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 166 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 166 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 46 TABLE test t1 wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 28 24 4 24 4 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 18 4 14 4 0 14 0 TABLE test t3 NULL 76 64 12 64 12 0 0 TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 34 4 30 4 0 30 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 46 28 18 28 4 14 0 TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 46 TABLE test t2 0 TABLE test t3 120 "================== con3 disconnected ==================" "================== Step 15 ==================" call dump_thread(); username status user1 not found username status user2 not found username status user3 not found username event_name count_star user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 22 user1 localhost wait/lock/table/sql/handler 0 user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 user4 localhost wait/io/table/sql/handler 61 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 166 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 166 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 46 TABLE test t1 wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 28 24 4 24 4 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 18 4 14 4 0 14 0 TABLE test t3 NULL 76 64 12 64 12 0 0 TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 34 4 30 4 0 30 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 46 28 18 28 4 14 0 TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 46 TABLE test t2 0 TABLE test t3 120 "================== con4 disconnected ==================" "================== Step 16 ==================" call dump_thread(); username status user1 not found username status user2 not found username status user3 not found username status user4 not found execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 22 user1 localhost wait/lock/table/sql/handler 0 user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 user4 localhost wait/io/table/sql/handler 61 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 166 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 166 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 46 TABLE test t1 wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 28 24 4 24 4 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 18 4 14 4 0 14 0 TABLE test t3 NULL 76 64 12 64 12 0 0 TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 34 4 30 4 0 30 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 46 28 18 28 4 14 0 TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 46 TABLE test t2 0 TABLE test t3 120 truncate performance_schema.events_waits_summary_by_thread_by_event_name; "================== BY_THREAD truncated ==================" "================== Step 17 ==================" call dump_thread(); username status user1 not found username status user2 not found username status user3 not found username status user4 not found execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 22 user1 localhost wait/lock/table/sql/handler 0 user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 user4 localhost wait/io/table/sql/handler 61 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 166 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 166 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 46 TABLE test t1 wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 28 24 4 24 4 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 18 4 14 4 0 14 0 TABLE test t3 NULL 76 64 12 64 12 0 0 TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 34 4 30 4 0 30 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 46 28 18 28 4 14 0 TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 46 TABLE test t2 0 TABLE test t3 120 truncate performance_schema.events_waits_summary_by_account_by_event_name; "================== BY_ACCOUNT truncated ==================" "================== Step 18 ==================" call dump_thread(); username status user1 not found username status user2 not found username status user3 not found username status user4 not found execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 0 user1 localhost wait/lock/table/sql/handler 0 user2 localhost wait/io/table/sql/handler 0 user2 localhost wait/lock/table/sql/handler 0 user3 localhost wait/io/table/sql/handler 0 user3 localhost wait/lock/table/sql/handler 0 user4 localhost wait/io/table/sql/handler 0 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 22 user1 wait/lock/table/sql/handler 0 user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 166 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 166 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 46 TABLE test t1 wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 28 24 4 24 4 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 18 4 14 4 0 14 0 TABLE test t3 NULL 76 64 12 64 12 0 0 TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 34 4 30 4 0 30 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 46 28 18 28 4 14 0 TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 46 TABLE test t2 0 TABLE test t3 120 truncate performance_schema.events_waits_summary_by_user_by_event_name; "================== BY_USER truncated ==================" "================== Step 19 ==================" call dump_thread(); username status user1 not found username status user2 not found username status user3 not found username status user4 not found execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 0 user1 localhost wait/lock/table/sql/handler 0 user2 localhost wait/io/table/sql/handler 0 user2 localhost wait/lock/table/sql/handler 0 user3 localhost wait/io/table/sql/handler 0 user3 localhost wait/lock/table/sql/handler 0 user4 localhost wait/io/table/sql/handler 0 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 0 user1 wait/lock/table/sql/handler 0 user2 wait/io/table/sql/handler 0 user2 wait/lock/table/sql/handler 0 user3 wait/io/table/sql/handler 0 user3 wait/lock/table/sql/handler 0 user4 wait/io/table/sql/handler 0 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 166 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 166 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 46 TABLE test t1 wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 28 24 4 24 4 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 18 4 14 4 0 14 0 TABLE test t3 NULL 76 64 12 64 12 0 0 TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 34 4 30 4 0 30 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 46 28 18 28 4 14 0 TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 46 TABLE test t2 0 TABLE test t3 120 truncate performance_schema.events_waits_summary_by_host_by_event_name; "================== BY_HOST truncated ==================" "================== Step 21 ==================" call dump_thread(); username status user1 not found username status user2 not found username status user3 not found username status user4 not found execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 0 user1 localhost wait/lock/table/sql/handler 0 user2 localhost wait/io/table/sql/handler 0 user2 localhost wait/lock/table/sql/handler 0 user3 localhost wait/io/table/sql/handler 0 user3 localhost wait/lock/table/sql/handler 0 user4 localhost wait/io/table/sql/handler 0 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 0 user1 wait/lock/table/sql/handler 0 user2 wait/io/table/sql/handler 0 user2 wait/lock/table/sql/handler 0 user3 wait/io/table/sql/handler 0 user3 wait/lock/table/sql/handler 0 user4 wait/io/table/sql/handler 0 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 0 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 166 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 46 TABLE test t1 wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 28 24 4 24 4 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 18 4 14 4 0 14 0 TABLE test t3 NULL 76 64 12 64 12 0 0 TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 34 4 30 4 0 30 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 46 28 18 28 4 14 0 TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 46 TABLE test t2 0 TABLE test t3 120 truncate performance_schema.events_waits_summary_global_by_event_name; "================== GLOBAL truncated ==================" "================== Step 21 ==================" call dump_thread(); username status user1 not found username status user2 not found username status user3 not found username status user4 not found execute dump_waits_account; user host event_name count_star user1 localhost wait/io/table/sql/handler 0 user1 localhost wait/lock/table/sql/handler 0 user2 localhost wait/io/table/sql/handler 0 user2 localhost wait/lock/table/sql/handler 0 user3 localhost wait/io/table/sql/handler 0 user3 localhost wait/lock/table/sql/handler 0 user4 localhost wait/io/table/sql/handler 0 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star user1 wait/io/table/sql/handler 0 user1 wait/lock/table/sql/handler 0 user2 wait/io/table/sql/handler 0 user2 wait/lock/table/sql/handler 0 user3 wait/io/table/sql/handler 0 user3 wait/lock/table/sql/handler 0 user4 wait/io/table/sql/handler 0 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star localhost wait/io/table/sql/handler 0 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star wait/io/table/sql/handler 0 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 46 TABLE test t1 wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 0 0 0 0 0 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 0 0 0 0 0 0 0 TABLE test t3 NULL 0 0 0 0 0 0 0 TABLE test t3 index_b 0 0 0 0 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 0 0 0 0 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 execute dump_waits_table_lock; object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external TABLE test t1 0 0 0 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 0 TABLE test t2 0 TABLE test t3 0 show global status like "performance_schema%"; Variable_name Value Performance_schema_accounts_lost 0 Performance_schema_cond_classes_lost 0 Performance_schema_cond_instances_lost 0 Performance_schema_digest_lost 0 Performance_schema_file_classes_lost 0 Performance_schema_file_handles_lost 0 Performance_schema_file_instances_lost 0 Performance_schema_hosts_lost 0 Performance_schema_index_stat_lost 0 Performance_schema_locker_lost 0 Performance_schema_memory_classes_lost 0 Performance_schema_metadata_lock_lost 0 Performance_schema_mutex_classes_lost 0 Performance_schema_mutex_instances_lost 0 Performance_schema_nested_statement_lost 0 Performance_schema_prepared_statements_lost 0 Performance_schema_program_lost 0 Performance_schema_rwlock_classes_lost 0 Performance_schema_rwlock_instances_lost 0 Performance_schema_session_connect_attrs_lost 0 Performance_schema_socket_classes_lost 0 Performance_schema_socket_instances_lost 0 Performance_schema_stage_classes_lost 0 Performance_schema_statement_classes_lost 0 Performance_schema_table_handles_lost 0 Performance_schema_table_instances_lost 0 Performance_schema_table_lock_stat_lost 0 Performance_schema_thread_classes_lost 0 Performance_schema_thread_instances_lost 0 Performance_schema_users_lost 0
Close