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.217.163.75
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 /
t /
[ HOME SHELL ]
Name
Size
Permission
Action
all_tests.test
2.51
KB
-rw-r--r--
alter_table_progress.test
3.31
KB
-rw-r--r--
bad_option.test
2.95
KB
-rw-r--r--
batch_table_io_func.test
3.53
KB
-rw-r--r--
binlog_edge_mix-master.opt
41
B
-rw-r--r--
binlog_edge_mix.test
208
B
-rw-r--r--
binlog_edge_row-master.opt
41
B
-rw-r--r--
binlog_edge_row.test
206
B
-rw-r--r--
binlog_edge_stmt-master.opt
41
B
-rw-r--r--
binlog_edge_stmt.test
212
B
-rw-r--r--
binlog_ok_mix-master.opt
41
B
-rw-r--r--
binlog_ok_mix.test
206
B
-rw-r--r--
binlog_ok_row-master.opt
41
B
-rw-r--r--
binlog_ok_row.test
204
B
-rw-r--r--
binlog_ok_stmt-master.opt
41
B
-rw-r--r--
binlog_ok_stmt.test
210
B
-rw-r--r--
checksum.test
7.57
KB
-rw-r--r--
cnf_option.cnf
273
B
-rw-r--r--
cnf_option.test
295
B
-rw-r--r--
column_privilege.test
1.82
KB
-rw-r--r--
connect_attrs.test
2.22
KB
-rw-r--r--
connection.test
163
B
-rw-r--r--
connection_3a-master.opt
43
B
-rw-r--r--
connection_3a.test
163
B
-rw-r--r--
connection_3a_3u-master.opt
83
B
-rw-r--r--
connection_3a_3u.test
163
B
-rw-r--r--
connection_3u-master.opt
40
B
-rw-r--r--
connection_3u.test
163
B
-rw-r--r--
connection_type_notwin.test
2.87
KB
-rw-r--r--
connection_type_win.test
2.86
KB
-rw-r--r--
csv_table_io.test
791
B
-rw-r--r--
ddl_accounts.test
487
B
-rw-r--r--
ddl_cond_instances.test
514
B
-rw-r--r--
ddl_esgs_by_account_by_event_n...
621
B
-rw-r--r--
ddl_esgs_by_host_by_event_name...
609
B
-rw-r--r--
ddl_esgs_by_thread_by_event_na...
617
B
-rw-r--r--
ddl_esgs_by_user_by_event_name...
609
B
-rw-r--r--
ddl_esgs_global_by_event_name....
609
B
-rw-r--r--
ddl_esms_by_account_by_event_n...
637
B
-rw-r--r--
ddl_esms_by_digest.test
571
B
-rw-r--r--
ddl_esms_by_host_by_event_name...
625
B
-rw-r--r--
ddl_esms_by_program.test
760
B
-rw-r--r--
ddl_esms_by_thread_by_event_na...
633
B
-rw-r--r--
ddl_esms_by_user_by_event_name...
625
B
-rw-r--r--
ddl_esms_global_by_event_name....
625
B
-rw-r--r--
ddl_ets_by_account_by_event_na...
645
B
-rw-r--r--
ddl_ets_by_host_by_event_name....
633
B
-rw-r--r--
ddl_ets_by_thread_by_event_nam...
641
B
-rw-r--r--
ddl_ets_by_user_by_event_name....
633
B
-rw-r--r--
ddl_ets_global_by_event_name.t...
633
B
-rw-r--r--
ddl_events_stages_current.test
798
B
-rw-r--r--
ddl_events_stages_history.test
797
B
-rw-r--r--
ddl_events_stages_history_long...
822
B
-rw-r--r--
ddl_events_statements_current....
531
B
-rw-r--r--
ddl_events_statements_history....
531
B
-rw-r--r--
ddl_events_statements_history_...
551
B
-rw-r--r--
ddl_events_transactions_curren...
539
B
-rw-r--r--
ddl_events_transactions_histor...
539
B
-rw-r--r--
ddl_events_transactions_histor...
559
B
-rw-r--r--
ddl_events_waits_current.test
511
B
-rw-r--r--
ddl_events_waits_history.test
511
B
-rw-r--r--
ddl_events_waits_history_long....
531
B
-rw-r--r--
ddl_ews_by_account_by_event_na...
617
B
-rw-r--r--
ddl_ews_by_host_by_event_name....
605
B
-rw-r--r--
ddl_ews_by_instance.test
563
B
-rw-r--r--
ddl_ews_by_thread_by_event_nam...
613
B
-rw-r--r--
ddl_ews_by_user_by_event_name....
605
B
-rw-r--r--
ddl_ews_global_by_event_name.t...
605
B
-rw-r--r--
ddl_file_instances.test
524
B
-rw-r--r--
ddl_fs_by_event_name.test
527
B
-rw-r--r--
ddl_fs_by_instance.test
519
B
-rw-r--r--
ddl_global_status.test
499
B
-rw-r--r--
ddl_global_variables.test
546
B
-rw-r--r--
ddl_host_cache.test
459
B
-rw-r--r--
ddl_hosts.test
475
B
-rw-r--r--
ddl_mems_by_account_by_event_n...
593
B
-rw-r--r--
ddl_mems_by_host_by_event_name...
581
B
-rw-r--r--
ddl_mems_by_thread_by_event_na...
589
B
-rw-r--r--
ddl_mems_by_user_by_event_name...
581
B
-rw-r--r--
ddl_mems_global_by_event_name....
577
B
-rw-r--r--
ddl_metadata_locks.test
526
B
-rw-r--r--
ddl_mutex_instances.test
518
B
-rw-r--r--
ddl_os_global_by_type.test
563
B
-rw-r--r--
ddl_performance_timers.test
542
B
-rw-r--r--
ddl_prepared_statements_instan...
744
B
-rw-r--r--
ddl_processlist.test
880
B
-rw-r--r--
ddl_replication_applier_config...
740
B
-rw-r--r--
ddl_replication_applier_status...
708
B
-rw-r--r--
ddl_replication_applier_status...
771
B
-rw-r--r--
ddl_replication_applier_status...
747
B
-rw-r--r--
ddl_replication_connection_con...
737
B
-rw-r--r--
ddl_replication_connection_sta...
712
B
-rw-r--r--
ddl_replication_group_member_s...
712
B
-rw-r--r--
ddl_replication_group_members....
688
B
-rw-r--r--
ddl_rwlock_instances.test
522
B
-rw-r--r--
ddl_session_account_connect_at...
553
B
-rw-r--r--
ddl_session_connect_attrs.test
521
B
-rw-r--r--
ddl_session_status.test
538
B
-rw-r--r--
ddl_session_variables.test
550
B
-rw-r--r--
ddl_setup_actors.test
898
B
-rw-r--r--
ddl_setup_consumers.test
518
B
-rw-r--r--
ddl_setup_instruments.test
526
B
-rw-r--r--
ddl_setup_objects.test
823
B
-rw-r--r--
ddl_setup_timers.test
506
B
-rw-r--r--
ddl_socket_instances.test
532
B
-rw-r--r--
ddl_socket_summary_by_event_na...
537
B
-rw-r--r--
ddl_socket_summary_by_instance...
537
B
-rw-r--r--
ddl_status_by_account.test
515
B
-rw-r--r--
ddl_status_by_host.test
503
B
-rw-r--r--
ddl_status_by_thread.test
511
B
-rw-r--r--
ddl_status_by_user.test
503
B
-rw-r--r--
ddl_table_handles.test
522
B
-rw-r--r--
ddl_threads.test
506
B
-rw-r--r--
ddl_tiws_by_index_usage.test
585
B
-rw-r--r--
ddl_tiws_by_table.test
561
B
-rw-r--r--
ddl_tlws_by_table.test
569
B
-rw-r--r--
ddl_users.test
475
B
-rw-r--r--
ddl_uvar_by_thread.test
578
B
-rw-r--r--
ddl_variables_by_thread.test
558
B
-rw-r--r--
digest_null_literal.test
872
B
-rw-r--r--
digest_table_full-master.opt
42
B
-rw-r--r--
digest_table_full.test
1.01
KB
-rw-r--r--
digest_view.test
1.88
KB
-rw-r--r--
disabled.def
505
B
-rw-r--r--
dml_accounts.test
1.01
KB
-rw-r--r--
dml_cond_instances.test
901
B
-rw-r--r--
dml_esgs_by_account_by_event_n...
1.41
KB
-rw-r--r--
dml_esgs_by_host_by_event_name...
1.38
KB
-rw-r--r--
dml_esgs_by_thread_by_event_na...
1.39
KB
-rw-r--r--
dml_esgs_by_user_by_event_name...
1.38
KB
-rw-r--r--
dml_esgs_global_by_event_name....
1.35
KB
-rw-r--r--
dml_esms_by_account_by_event_n...
1.45
KB
-rw-r--r--
dml_esms_by_digest.test
1.29
KB
-rw-r--r--
dml_esms_by_host_by_event_name...
1.42
KB
-rw-r--r--
dml_esms_by_program.test
1.49
KB
-rw-r--r--
dml_esms_by_thread_by_event_na...
1.43
KB
-rw-r--r--
dml_esms_by_user_by_event_name...
1.42
KB
-rw-r--r--
dml_esms_global_by_event_name....
1.39
KB
-rw-r--r--
dml_ets_by_account_by_event_na...
1.47
KB
-rw-r--r--
dml_ets_by_host_by_event_name....
1.43
KB
-rw-r--r--
dml_ets_by_thread_by_event_nam...
1.45
KB
-rw-r--r--
dml_ets_by_user_by_event_name....
1.43
KB
-rw-r--r--
dml_ets_global_by_event_name.t...
1.41
KB
-rw-r--r--
dml_events_stages_current.test
1.14
KB
-rw-r--r--
dml_events_stages_history.test
1.38
KB
-rw-r--r--
dml_events_stages_history_long...
1.43
KB
-rw-r--r--
dml_events_statements_current....
1.18
KB
-rw-r--r--
dml_events_statements_history....
1.43
KB
-rw-r--r--
dml_events_statements_history_...
1.49
KB
-rw-r--r--
dml_events_transactions_curren...
1.2
KB
-rw-r--r--
dml_events_transactions_histor...
1.46
KB
-rw-r--r--
dml_events_transactions_histor...
1.51
KB
-rw-r--r--
dml_events_waits_current.test
1.14
KB
-rw-r--r--
dml_events_waits_history.test
1.38
KB
-rw-r--r--
dml_events_waits_history_long....
1.44
KB
-rw-r--r--
dml_ews_by_account_by_event_na...
1.42
KB
-rw-r--r--
dml_ews_by_host_by_event_name....
1.38
KB
-rw-r--r--
dml_ews_by_instance.test
1.74
KB
-rw-r--r--
dml_ews_by_thread_by_event_nam...
1.39
KB
-rw-r--r--
dml_ews_by_user_by_event_name....
1.38
KB
-rw-r--r--
dml_ews_global_by_event_name.t...
1.35
KB
-rw-r--r--
dml_file_instances.test
3
KB
-rw-r--r--
dml_fs_by_event_name.test
1.21
KB
-rw-r--r--
dml_fs_by_instance.test
1.2
KB
-rw-r--r--
dml_global_status.test
979
B
-rw-r--r--
dml_global_variables.test
1007
B
-rw-r--r--
dml_handler.test
1.29
KB
-rw-r--r--
dml_host_cache.test
1.08
KB
-rw-r--r--
dml_hosts.test
985
B
-rw-r--r--
dml_mems_by_account_by_event_n...
1.37
KB
-rw-r--r--
dml_mems_by_host_by_event_name...
1.34
KB
-rw-r--r--
dml_mems_by_thread_by_event_na...
1.36
KB
-rw-r--r--
dml_mems_by_user_by_event_name...
1.34
KB
-rw-r--r--
dml_mems_global_by_event_name....
1.32
KB
-rw-r--r--
dml_metadata_locks.test
932
B
-rw-r--r--
dml_mutex_instances.test
909
B
-rw-r--r--
dml_os_global_by_type.test
1.98
KB
-rw-r--r--
dml_performance_timers.test
1.06
KB
-rw-r--r--
dml_prepared_statements_instan...
1.47
KB
-rw-r--r--
dml_processlist.test
1.07
KB
-rw-r--r--
dml_replication_applier_config...
1.16
KB
-rw-r--r--
dml_replication_applier_status...
1.27
KB
-rw-r--r--
dml_replication_applier_status...
1.48
KB
-rw-r--r--
dml_replication_applier_status...
1.42
KB
-rw-r--r--
dml_replication_connection_con...
1.39
KB
-rw-r--r--
dml_replication_connection_sta...
1.38
KB
-rw-r--r--
dml_replication_group_member_s...
1.19
KB
-rw-r--r--
dml_replication_group_members....
1.18
KB
-rw-r--r--
dml_rwlock_instances.test
917
B
-rw-r--r--
dml_session_account_connect_at...
1.17
KB
-rw-r--r--
dml_session_connect_attrs.test
1.1
KB
-rw-r--r--
dml_session_status.test
987
B
-rw-r--r--
dml_session_variables.test
1011
B
-rw-r--r--
dml_setup_actors.test
3.33
KB
-rw-r--r--
dml_setup_consumers.test
1008
B
-rw-r--r--
dml_setup_instruments.test
2.93
KB
-rw-r--r--
dml_setup_objects.test
2.65
KB
-rw-r--r--
dml_setup_timers.test
1.97
KB
-rw-r--r--
dml_socket_instances.test
918
B
-rw-r--r--
dml_socket_summary_by_event_na...
1.2
KB
-rw-r--r--
dml_socket_summary_by_instance...
1.21
KB
-rw-r--r--
dml_status_by_account.test
1.13
KB
-rw-r--r--
dml_status_by_host.test
1.09
KB
-rw-r--r--
dml_status_by_thread.test
1.1
KB
-rw-r--r--
dml_status_by_user.test
1.09
KB
-rw-r--r--
dml_table_handles.test
922
B
-rw-r--r--
dml_threads.test
1.27
KB
-rw-r--r--
dml_tiws_by_index_usage.test
1.32
KB
-rw-r--r--
dml_tiws_by_table.test
1.27
KB
-rw-r--r--
dml_tlws_by_table.test
1.29
KB
-rw-r--r--
dml_users.test
985
B
-rw-r--r--
dml_uvar_by_thread.test
1.35
KB
-rw-r--r--
dml_variables_by_thread.test
1.13
KB
-rw-r--r--
event_aggregate-master.opt
32
B
-rw-r--r--
event_aggregate.test
280
B
-rw-r--r--
event_aggregate_no_a-master.op...
75
B
-rw-r--r--
event_aggregate_no_a.test
281
B
-rw-r--r--
event_aggregate_no_a_no_h-mast...
115
B
-rw-r--r--
event_aggregate_no_a_no_h.test
281
B
-rw-r--r--
event_aggregate_no_a_no_u-mast...
115
B
-rw-r--r--
event_aggregate_no_a_no_u.test
281
B
-rw-r--r--
event_aggregate_no_a_no_u_no_h...
155
B
-rw-r--r--
event_aggregate_no_a_no_u_no_h...
281
B
-rw-r--r--
event_aggregate_no_h-master.op...
72
B
-rw-r--r--
event_aggregate_no_h.test
281
B
-rw-r--r--
event_aggregate_no_u-master.op...
72
B
-rw-r--r--
event_aggregate_no_u.test
281
B
-rw-r--r--
event_aggregate_no_u_no_h-mast...
112
B
-rw-r--r--
event_aggregate_no_u_no_h.test
281
B
-rw-r--r--
file_misc-master.opt
48
B
-rw-r--r--
file_misc.test
258
B
-rw-r--r--
func_file_io.test
5.69
KB
-rw-r--r--
func_mutex.test
4.47
KB
-rw-r--r--
global_objects-master.opt
46
B
-rw-r--r--
global_objects.test
1.13
KB
-rw-r--r--
global_read_lock.test
2.33
KB
-rw-r--r--
hostcache_ipv4_addrinfo_again_...
1.41
KB
-rw-r--r--
hostcache_ipv4_addrinfo_again_...
1.17
KB
-rw-r--r--
hostcache_ipv4_addrinfo_bad_al...
1.53
KB
-rw-r--r--
hostcache_ipv4_addrinfo_bad_de...
1.29
KB
-rw-r--r--
hostcache_ipv4_addrinfo_good_a...
1.46
KB
-rw-r--r--
hostcache_ipv4_addrinfo_good_d...
1.16
KB
-rw-r--r--
hostcache_ipv4_addrinfo_noname...
1.58
KB
-rw-r--r--
hostcache_ipv4_addrinfo_noname...
1.16
KB
-rw-r--r--
hostcache_ipv4_auth_plugin-mas...
35
B
-rw-r--r--
hostcache_ipv4_auth_plugin.tes...
2.57
KB
-rw-r--r--
hostcache_ipv4_blocked.test
4.08
KB
-rw-r--r--
hostcache_ipv4_format.test
1.07
KB
-rw-r--r--
hostcache_ipv4_max_con.test
6.37
KB
-rw-r--r--
hostcache_ipv4_nameinfo_again_...
1.98
KB
-rw-r--r--
hostcache_ipv4_nameinfo_again_...
1.58
KB
-rw-r--r--
hostcache_ipv4_nameinfo_noname...
1.35
KB
-rw-r--r--
hostcache_ipv4_nameinfo_noname...
1.11
KB
-rw-r--r--
hostcache_ipv4_passwd.test
2.28
KB
-rw-r--r--
hostcache_ipv4_ssl.test
1.9
KB
-rw-r--r--
hostcache_ipv6_addrinfo_again_...
18
B
-rw-r--r--
hostcache_ipv6_addrinfo_again_...
1.44
KB
-rw-r--r--
hostcache_ipv6_addrinfo_again_...
18
B
-rw-r--r--
hostcache_ipv6_addrinfo_again_...
1.19
KB
-rw-r--r--
hostcache_ipv6_addrinfo_bad_al...
18
B
-rw-r--r--
hostcache_ipv6_addrinfo_bad_al...
1.56
KB
-rw-r--r--
hostcache_ipv6_addrinfo_bad_de...
18
B
-rw-r--r--
hostcache_ipv6_addrinfo_bad_de...
1.31
KB
-rw-r--r--
hostcache_ipv6_addrinfo_good_a...
18
B
-rw-r--r--
hostcache_ipv6_addrinfo_good_a...
1.47
KB
-rw-r--r--
hostcache_ipv6_addrinfo_good_d...
18
B
-rw-r--r--
hostcache_ipv6_addrinfo_good_d...
1.05
KB
-rw-r--r--
hostcache_ipv6_addrinfo_noname...
18
B
-rw-r--r--
hostcache_ipv6_addrinfo_noname...
1.61
KB
-rw-r--r--
hostcache_ipv6_addrinfo_noname...
18
B
-rw-r--r--
hostcache_ipv6_addrinfo_noname...
1.18
KB
-rw-r--r--
hostcache_ipv6_auth_plugin-mas...
53
B
-rw-r--r--
hostcache_ipv6_auth_plugin.tes...
2.57
KB
-rw-r--r--
hostcache_ipv6_blocked-master....
18
B
-rw-r--r--
hostcache_ipv6_blocked.test
4.03
KB
-rw-r--r--
hostcache_ipv6_max_con-master....
18
B
-rw-r--r--
hostcache_ipv6_max_con.test
5.42
KB
-rw-r--r--
hostcache_ipv6_nameinfo_again_...
18
B
-rw-r--r--
hostcache_ipv6_nameinfo_again_...
2
KB
-rw-r--r--
hostcache_ipv6_nameinfo_again_...
18
B
-rw-r--r--
hostcache_ipv6_nameinfo_again_...
1.58
KB
-rw-r--r--
hostcache_ipv6_nameinfo_noname...
18
B
-rw-r--r--
hostcache_ipv6_nameinfo_noname...
1.38
KB
-rw-r--r--
hostcache_ipv6_nameinfo_noname...
18
B
-rw-r--r--
hostcache_ipv6_nameinfo_noname...
1.13
KB
-rw-r--r--
hostcache_ipv6_passwd-master.o...
18
B
-rw-r--r--
hostcache_ipv6_passwd.test
2.19
KB
-rw-r--r--
hostcache_ipv6_ssl-master.opt
18
B
-rw-r--r--
hostcache_ipv6_ssl.test
1.91
KB
-rw-r--r--
hostcache_peer_addr-master.opt
16
B
-rw-r--r--
hostcache_peer_addr.test
1.12
KB
-rw-r--r--
indexed_table_io.test
4.15
KB
-rw-r--r--
information_schema.test
2.12
KB
-rw-r--r--
innodb_table_io.test
794
B
-rw-r--r--
io_cache-master.opt
76
B
-rw-r--r--
io_cache.test
9.63
KB
-rw-r--r--
max_program_zero-master.opt
122
B
-rw-r--r--
max_program_zero.test
1.57
KB
-rw-r--r--
mdl_func.test
10.41
KB
-rw-r--r--
memory_aggregate-master.opt
37
B
-rw-r--r--
memory_aggregate.test
212
B
-rw-r--r--
memory_aggregate_32bit-master....
37
B
-rw-r--r--
memory_aggregate_32bit.test
212
B
-rw-r--r--
memory_aggregate_no_a-master.o...
80
B
-rw-r--r--
memory_aggregate_no_a.test
212
B
-rw-r--r--
memory_aggregate_no_a_no_h-mas...
120
B
-rw-r--r--
memory_aggregate_no_a_no_h.tes...
212
B
-rw-r--r--
memory_aggregate_no_a_no_u-mas...
120
B
-rw-r--r--
memory_aggregate_no_a_no_u.tes...
212
B
-rw-r--r--
memory_aggregate_no_a_no_u_no_...
160
B
-rw-r--r--
memory_aggregate_no_a_no_u_no_...
212
B
-rw-r--r--
memory_aggregate_no_h-master.o...
77
B
-rw-r--r--
memory_aggregate_no_h.test
212
B
-rw-r--r--
memory_aggregate_no_u-master.o...
77
B
-rw-r--r--
memory_aggregate_no_u.test
212
B
-rw-r--r--
memory_aggregate_no_u_no_h-mas...
117
B
-rw-r--r--
memory_aggregate_no_u_no_h.tes...
212
B
-rw-r--r--
memory_table_io.test
794
B
-rw-r--r--
merge_table_io.test
1.44
KB
-rw-r--r--
misc.test
7.99
KB
-rw-r--r--
misc_global_status-master.opt
40
B
-rw-r--r--
misc_global_status.test
4.32
KB
-rw-r--r--
multi_table_io.test
1.52
KB
-rw-r--r--
myisam_file_io.opt
57
B
-rw-r--r--
myisam_file_io.test
1.88
KB
-rw-r--r--
myisam_table_io.test
794
B
-rw-r--r--
nesting.test
6.29
KB
-rw-r--r--
no_threads-master.opt
148
B
-rw-r--r--
no_threads.test
1.89
KB
-rw-r--r--
one_thread_per_con-master.opt
44
B
-rw-r--r--
one_thread_per_con.test
1.71
KB
-rw-r--r--
ortho_iter.test
9.96
KB
-rw-r--r--
part_table_io.test
864
B
-rw-r--r--
pfs_upgrade_event-master.opt
37
B
-rw-r--r--
pfs_upgrade_event.test
987
B
-rw-r--r--
pfs_upgrade_func-master.opt
37
B
-rw-r--r--
pfs_upgrade_func.test
955
B
-rw-r--r--
pfs_upgrade_proc-master.opt
37
B
-rw-r--r--
pfs_upgrade_proc.test
967
B
-rw-r--r--
pfs_upgrade_table-master.opt
37
B
-rw-r--r--
pfs_upgrade_table.test
1.12
KB
-rw-r--r--
pfs_upgrade_view-master.opt
37
B
-rw-r--r--
pfs_upgrade_view.test
1.13
KB
-rw-r--r--
prepared_statements.test
4.48
KB
-rw-r--r--
prepared_stmts_by_stored_progr...
3.25
KB
-rw-r--r--
privilege.test
11.88
KB
-rw-r--r--
privilege_table_io.test
1.65
KB
-rw-r--r--
processlist-master.opt
18
B
-rw-r--r--
processlist.test
5.06
KB
-rw-r--r--
processlist_57.test
8.49
KB
-rw-r--r--
processlist_acl-master.opt
18
B
-rw-r--r--
processlist_acl.test
5.14
KB
-rw-r--r--
processlist_anonymous.test
2.38
KB
-rw-r--r--
processlist_no_pfs-master.opt
82
B
-rw-r--r--
processlist_no_pfs.test
732
B
-rw-r--r--
processlist_port-master.opt
18
B
-rw-r--r--
processlist_port.test
4.47
KB
-rw-r--r--
processlist_reg_user.test
3.13
KB
-rw-r--r--
query_cache-master.opt
21
B
-rw-r--r--
query_cache.test
1.57
KB
-rw-r--r--
read_only.test
5.88
KB
-rw-r--r--
relaylog-slave.opt
16
B
-rw-r--r--
relaylog.test
6.47
KB
-rw-r--r--
rollback_table_io.test
1.13
KB
-rw-r--r--
rpl_group_member_stats.test
2.76
KB
-rw-r--r--
rpl_group_members.test
1.62
KB
-rw-r--r--
rpl_gtid_func.test
2.39
KB
-rw-r--r--
rpl_statements-master.opt
22
B
-rw-r--r--
rpl_statements-slave.opt
22
B
-rw-r--r--
rpl_statements.test
8.79
KB
-rw-r--r--
rpl_threads-slave.opt
16
B
-rw-r--r--
rpl_threads.test
2.25
KB
-rw-r--r--
schema.test
200
B
-rw-r--r--
selects-master.opt
18
B
-rw-r--r--
selects.test
4.53
KB
-rw-r--r--
server_init.test
5.1
KB
-rw-r--r--
setup_actors.test
9.05
KB
-rw-r--r--
setup_actors_enabled.test
6.71
KB
-rw-r--r--
setup_actors_history.test
5.41
KB
-rw-r--r--
setup_consumers_defaults-maste...
913
B
-rw-r--r--
setup_consumers_defaults.test
493
B
-rw-r--r--
setup_instruments_defaults-mas...
1.79
KB
-rw-r--r--
setup_instruments_defaults.tes...
2.9
KB
-rw-r--r--
setup_object_table_lock_io.tes...
4.05
KB
-rw-r--r--
setup_objects.test
5.52
KB
-rw-r--r--
short_option_1-master.opt
50
B
-rw-r--r--
short_option_1.test
466
B
-rw-r--r--
short_option_2-master.opt
5
B
-rw-r--r--
short_option_2.test
458
B
-rw-r--r--
show_aggregate-master.opt
16
B
-rw-r--r--
show_aggregate.test
12.92
KB
-rw-r--r--
show_coverage.test
7.05
KB
-rw-r--r--
show_misc.test
3.38
KB
-rw-r--r--
show_plugin-master.opt
22
B
-rw-r--r--
show_plugin.test
17.86
KB
-rw-r--r--
show_plugin_56-master.opt
22
B
-rw-r--r--
show_plugin_56.test
16.74
KB
-rw-r--r--
show_sanity.test
101.52
KB
-rw-r--r--
socket_connect.test
8.91
KB
-rw-r--r--
socket_instances_func-master.o...
20
B
-rw-r--r--
socket_instances_func.test
12.2
KB
-rw-r--r--
socket_instances_func_win-mast...
20
B
-rw-r--r--
socket_instances_func_win.test
8.92
KB
-rw-r--r--
socket_summary_by_event_name_f...
11.98
KB
-rw-r--r--
socket_summary_by_instance_fun...
62.74
KB
-rw-r--r--
socket_summary_by_instance_fun...
62.89
KB
-rw-r--r--
stage_mdl_function.test
1.37
KB
-rw-r--r--
stage_mdl_global-master.opt
21
B
-rw-r--r--
stage_mdl_global.test
1.24
KB
-rw-r--r--
stage_mdl_procedure.test
1.63
KB
-rw-r--r--
stage_mdl_table.test
1.3
KB
-rw-r--r--
start_server_1_digest-master.o...
36
B
-rw-r--r--
start_server_1_digest.test
484
B
-rw-r--r--
start_server_disable_idle-mast...
49
B
-rw-r--r--
start_server_disable_idle.test
965
B
-rw-r--r--
start_server_disable_stages-ma...
52
B
-rw-r--r--
start_server_disable_stages.te...
841
B
-rw-r--r--
start_server_disable_statement...
56
B
-rw-r--r--
start_server_disable_statement...
873
B
-rw-r--r--
start_server_disable_transacti...
56
B
-rw-r--r--
start_server_disable_transacti...
883
B
-rw-r--r--
start_server_disable_waits-mas...
51
B
-rw-r--r--
start_server_disable_waits.tes...
978
B
-rw-r--r--
start_server_innodb-master.opt
34
B
-rw-r--r--
start_server_innodb.test
279
B
-rw-r--r--
start_server_low_digest-master...
23
B
-rw-r--r--
start_server_low_digest.test
996
B
-rw-r--r--
start_server_low_digest_sql_le...
95
B
-rw-r--r--
start_server_low_digest_sql_le...
1.02
KB
-rw-r--r--
start_server_low_index-master....
79
B
-rw-r--r--
start_server_low_index.test
6.03
KB
-rw-r--r--
start_server_low_table_lock-ma...
83
B
-rw-r--r--
start_server_low_table_lock.te...
4.02
KB
-rw-r--r--
start_server_no_account-master...
77
B
-rw-r--r--
start_server_no_account.test
472
B
-rw-r--r--
start_server_no_cond_class-mas...
80
B
-rw-r--r--
start_server_no_cond_class.tes...
702
B
-rw-r--r--
start_server_no_cond_inst-mast...
82
B
-rw-r--r--
start_server_no_cond_inst.test
767
B
-rw-r--r--
start_server_no_digests-master...
42
B
-rw-r--r--
start_server_no_digests.test
1.01
KB
-rw-r--r--
start_server_no_file_class-mas...
80
B
-rw-r--r--
start_server_no_file_class.tes...
699
B
-rw-r--r--
start_server_no_file_inst-mast...
82
B
-rw-r--r--
start_server_no_file_inst.test
764
B
-rw-r--r--
start_server_no_host-master.op...
74
B
-rw-r--r--
start_server_no_host.test
463
B
-rw-r--r--
start_server_no_index-master.o...
78
B
-rw-r--r--
start_server_no_index.test
2.07
KB
-rw-r--r--
start_server_no_mdl-master.opt
82
B
-rw-r--r--
start_server_no_mdl.test
649
B
-rw-r--r--
start_server_no_memory_class-m...
82
B
-rw-r--r--
start_server_no_memory_class.t...
755
B
-rw-r--r--
start_server_no_mutex_class-ma...
81
B
-rw-r--r--
start_server_no_mutex_class.te...
707
B
-rw-r--r--
start_server_no_mutex_inst-mas...
83
B
-rw-r--r--
start_server_no_mutex_inst.tes...
773
B
-rw-r--r--
start_server_no_prepared_stmts...
97
B
-rw-r--r--
start_server_no_prepared_stmts...
1.15
KB
-rw-r--r--
start_server_no_rwlock_class-m...
82
B
-rw-r--r--
start_server_no_rwlock_class.t...
712
B
-rw-r--r--
start_server_no_rwlock_inst-ma...
84
B
-rw-r--r--
start_server_no_rwlock_inst.te...
779
B
-rw-r--r--
start_server_no_setup_actors-m...
81
B
-rw-r--r--
start_server_no_setup_actors.t...
322
B
-rw-r--r--
start_server_no_setup_objects-...
82
B
-rw-r--r--
start_server_no_setup_objects....
326
B
-rw-r--r--
start_server_no_socket_class-m...
82
B
-rw-r--r--
start_server_no_socket_class.t...
709
B
-rw-r--r--
start_server_no_socket_inst-ma...
84
B
-rw-r--r--
start_server_no_socket_inst.te...
776
B
-rw-r--r--
start_server_no_stage_class-ma...
81
B
-rw-r--r--
start_server_no_stage_class.te...
934
B
-rw-r--r--
start_server_no_stages_history...
90
B
-rw-r--r--
start_server_no_stages_history...
396
B
-rw-r--r--
start_server_no_stages_history...
95
B
-rw-r--r--
start_server_no_stages_history...
416
B
-rw-r--r--
start_server_no_statement_clas...
85
B
-rw-r--r--
start_server_no_statement_clas...
974
B
-rw-r--r--
start_server_no_statements_his...
94
B
-rw-r--r--
start_server_no_statements_his...
408
B
-rw-r--r--
start_server_no_statements_his...
99
B
-rw-r--r--
start_server_no_statements_his...
428
B
-rw-r--r--
start_server_no_table_hdl-mast...
81
B
-rw-r--r--
start_server_no_table_hdl.test
888
B
-rw-r--r--
start_server_no_table_inst-mas...
176
B
-rw-r--r--
start_server_no_table_inst.tes...
885
B
-rw-r--r--
start_server_no_table_lock-mas...
83
B
-rw-r--r--
start_server_no_table_lock.tes...
1.65
KB
-rw-r--r--
start_server_no_thread_class-m...
82
B
-rw-r--r--
start_server_no_thread_class.t...
692
B
-rw-r--r--
start_server_no_thread_inst-ma...
84
B
-rw-r--r--
start_server_no_thread_inst.te...
784
B
-rw-r--r--
start_server_no_transactions_h...
96
B
-rw-r--r--
start_server_no_transactions_h...
414
B
-rw-r--r--
start_server_no_transactions_h...
101
B
-rw-r--r--
start_server_no_transactions_h...
434
B
-rw-r--r--
start_server_no_user-master.op...
74
B
-rw-r--r--
start_server_no_user.test
463
B
-rw-r--r--
start_server_no_waits_history-...
89
B
-rw-r--r--
start_server_no_waits_history....
393
B
-rw-r--r--
start_server_no_waits_history_...
94
B
-rw-r--r--
start_server_no_waits_history_...
413
B
-rw-r--r--
start_server_nothing-master.op...
1.78
KB
-rw-r--r--
start_server_nothing.test
3.21
KB
-rw-r--r--
start_server_off-master.opt
35
B
-rw-r--r--
start_server_off.test
2.18
KB
-rw-r--r--
start_server_on-master.opt
34
B
-rw-r--r--
start_server_on.test
246
B
-rw-r--r--
start_server_zero_digest_sql_l...
93
B
-rw-r--r--
start_server_zero_digest_sql_l...
971
B
-rw-r--r--
statement_digest.test
887
B
-rw-r--r--
statement_digest_charset.test
995
B
-rw-r--r--
statement_digest_consumers-mas...
120
B
-rw-r--r--
statement_digest_consumers.tes...
1.21
KB
-rw-r--r--
statement_digest_consumers2-ma...
120
B
-rw-r--r--
statement_digest_consumers2.te...
1.3
KB
-rw-r--r--
statement_digest_long_query-ma...
22
B
-rw-r--r--
statement_digest_long_query.te...
2.46
KB
-rw-r--r--
statement_program_concurrency-...
51
B
-rw-r--r--
statement_program_concurrency....
2.83
KB
-rw-r--r--
statement_program_lost_inst-ma...
122
B
-rw-r--r--
statement_program_lost_inst.te...
2.76
KB
-rw-r--r--
statement_program_nested-maste...
22
B
-rw-r--r--
statement_program_nested.test
2.99
KB
-rw-r--r--
statement_program_nesting_even...
22
B
-rw-r--r--
statement_program_nesting_even...
1.71
KB
-rw-r--r--
statement_program_non_nested-m...
22
B
-rw-r--r--
statement_program_non_nested.t...
4.73
KB
-rw-r--r--
status_reprepare.test
1.99
KB
-rw-r--r--
sxlock_func.test
2.48
KB
-rw-r--r--
table_aggregate_global_2u_2t.t...
495
B
-rw-r--r--
table_aggregate_global_2u_3t.t...
435
B
-rw-r--r--
table_aggregate_global_4u_2t.t...
426
B
-rw-r--r--
table_aggregate_global_4u_3t.t...
366
B
-rw-r--r--
table_aggregate_hist_2u_2t.tes...
406
B
-rw-r--r--
table_aggregate_hist_2u_3t.tes...
346
B
-rw-r--r--
table_aggregate_hist_4u_2t.tes...
337
B
-rw-r--r--
table_aggregate_hist_4u_3t.tes...
277
B
-rw-r--r--
table_aggregate_off.test
320
B
-rw-r--r--
table_aggregate_thread_2u_2t.t...
484
B
-rw-r--r--
table_aggregate_thread_2u_3t.t...
424
B
-rw-r--r--
table_aggregate_thread_4u_2t.t...
415
B
-rw-r--r--
table_aggregate_thread_4u_3t.t...
355
B
-rw-r--r--
table_io_aggregate_global_2u_2...
574
B
-rw-r--r--
table_io_aggregate_global_2u_3...
514
B
-rw-r--r--
table_io_aggregate_global_4u_2...
505
B
-rw-r--r--
table_io_aggregate_global_4u_3...
445
B
-rw-r--r--
table_io_aggregate_hist_2u_2t....
485
B
-rw-r--r--
table_io_aggregate_hist_2u_3t....
425
B
-rw-r--r--
table_io_aggregate_hist_4u_2t....
416
B
-rw-r--r--
table_io_aggregate_hist_4u_3t....
356
B
-rw-r--r--
table_io_aggregate_thread_2u_2...
563
B
-rw-r--r--
table_io_aggregate_thread_2u_3...
503
B
-rw-r--r--
table_io_aggregate_thread_4u_2...
494
B
-rw-r--r--
table_io_aggregate_thread_4u_3...
434
B
-rw-r--r--
table_lock_aggregate_global_2u...
674
B
-rw-r--r--
table_lock_aggregate_global_2u...
614
B
-rw-r--r--
table_lock_aggregate_global_4u...
605
B
-rw-r--r--
table_lock_aggregate_global_4u...
545
B
-rw-r--r--
table_lock_aggregate_hist_2u_2...
585
B
-rw-r--r--
table_lock_aggregate_hist_2u_3...
525
B
-rw-r--r--
table_lock_aggregate_hist_4u_2...
516
B
-rw-r--r--
table_lock_aggregate_hist_4u_3...
456
B
-rw-r--r--
table_lock_aggregate_thread_2u...
663
B
-rw-r--r--
table_lock_aggregate_thread_2u...
603
B
-rw-r--r--
table_lock_aggregate_thread_4u...
594
B
-rw-r--r--
table_lock_aggregate_thread_4u...
534
B
-rw-r--r--
table_name.test
5.45
KB
-rw-r--r--
table_schema.test
2.05
KB
-rw-r--r--
tampered_perfschema_table1-mas...
44
B
-rw-r--r--
tampered_perfschema_table1.tes...
776
B
-rw-r--r--
temp_table_io.test
826
B
-rw-r--r--
thread_cache-master.opt
48
B
-rw-r--r--
thread_cache.test
4.43
KB
-rw-r--r--
thread_misc-master.opt
61
B
-rw-r--r--
thread_misc.test
263
B
-rw-r--r--
threads_history.test
26.93
KB
-rw-r--r--
threads_innodb.test
898
B
-rw-r--r--
threads_mysql-master.opt
40
B
-rw-r--r--
threads_mysql.test
4.56
KB
-rw-r--r--
threads_mysql_freebsd.test
723
B
-rw-r--r--
threads_mysql_linux.test
719
B
-rw-r--r--
threads_mysql_windows.test
723
B
-rw-r--r--
transaction-master.opt
84
B
-rw-r--r--
transaction.test
25.95
KB
-rw-r--r--
transaction_gtid.test
6.1
KB
-rw-r--r--
transaction_nested_events-mast...
1.05
KB
-rw-r--r--
transaction_nested_events.test
10.58
KB
-rw-r--r--
trigger_table_io.test
1.92
KB
-rw-r--r--
unary_digest.test
3.32
KB
-rw-r--r--
user_var_func.test
2.47
KB
-rw-r--r--
view_table_io.test
1.25
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : mdl_func.test
--source include/not_embedded.inc --source include/have_perfschema.inc UPDATE performance_schema.setup_instruments SET enabled = 'NO', timed = 'YES'; UPDATE performance_schema.setup_instruments SET enabled = 'YES' WHERE name in ('wait/io/table/sql/handler', 'wait/lock/table/sql/handler', 'wait/lock/metadata/sql/mdl'); set @orig_sql_mode= @@sql_mode; set sql_mode= (select replace(@@sql_mode,'NO_AUTO_CREATE_USER','')); grant ALL on *.* to user1@localhost; grant ALL on *.* to user2@localhost; set sql_mode= @orig_sql_mode; insert into performance_schema.setup_objects (object_type, object_schema, object_name, enabled, timed) values ('TABLE', 'mtr', '%', 'NO', 'NO'); --echo # Switch to (con1, localhost, user1, , ) connect (con1, localhost, user1, , ); let $user1_tid=`select THREAD_ID from performance_schema.threads where PROCESSLIST_ID=connection_id()`; --echo # Switch to (con2, localhost, user2, , ) connect (con2, localhost, user2, , ); let $user2_tid=`select THREAD_ID from performance_schema.threads where PROCESSLIST_ID=connection_id()`; --connection default --disable_query_log --eval set @user1_tid= $user1_tid; --eval set @user2_tid= $user2_tid; --enable_query_log --disable_warnings drop function if exists thread_id_name; --enable_warnings --delimiter // create function thread_id_name(THREAD_ID int) returns varchar(16) begin if (THREAD_ID IS NULL) then return NULL; end if; if (THREAD_ID = @user1_tid) then return "USER1"; end if; if (THREAD_ID = @user2_tid) then return "USER2"; end if; return "OTHER"; end; // delimiter ;// select thread_id_name(NULL); select thread_id_name(@user1_tid); select thread_id_name(@user2_tid); prepare dump_metadata_locks from "select OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS, thread_id_name(OWNER_THREAD_ID) as OWNER_THREAD_ID from performance_schema.metadata_locks order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS, OWNER_THREAD_ID;"; prepare dump_table_handles from "select OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INTERNAL_LOCK, EXTERNAL_LOCK, thread_id_name(OWNER_THREAD_ID) as OWNER_THREAD_ID from performance_schema.table_handles order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INTERNAL_LOCK, EXTERNAL_LOCK, OWNER_THREAD_ID;"; prepare dump_waits_current from "select thread_id_name(THREAD_ID) as THREAD_ID, EVENT_NAME, TIMER_START is not NULL as TIMER_START_SET, TIMER_END is not NULL as TIMER_END_SET, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, OPERATION from performance_schema.events_waits_current where event_name = \'wait/lock/metadata/sql/mdl\';"; prepare dump_waits_history_long from "select thread_id_name(THREAD_ID) as THREAD_ID, EVENT_NAME, TIMER_START is not NULL as TIMER_START_SET, TIMER_END is not NULL as TIMER_END_SET, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, OPERATION from performance_schema.events_waits_history_long where event_name = \'wait/lock/metadata/sql/mdl\';"; # reset lost counters truncate table performance_schema.events_statements_summary_by_digest; flush status; flush tables; --disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings CREATE TABLE t1 (id INT PRIMARY KEY, b CHAR(100) DEFAULT 'initial value'); INSERT INTO t1 (id) VALUES (1), (2), (3), (4), (5), (6), (7), (8); TRUNCATE TABLE performance_schema.events_waits_history_long; TRUNCATE TABLE performance_schema.events_waits_history; TRUNCATE TABLE performance_schema.events_waits_current; --connection con1 BEGIN; # MDL lock granted immediately, no wait. SELECT * from t1 where id=1; --connection default echo "---- Marker 1 ----"; --vertical_results execute dump_metadata_locks; execute dump_table_handles; execute dump_waits_current; execute dump_waits_history_long; --horizontal_results --connection con1 # The MDL lock is now released COMMIT; --connection default echo "---- Marker 2 ----"; --vertical_results execute dump_metadata_locks; execute dump_table_handles; execute dump_waits_current; execute dump_waits_history_long; --horizontal_results --connection con1 BEGIN; # MDL lock is granted immediately, no wait UPDATE t1 set b="new value" where id=2; --connection default echo "---- Marker 3 ----"; --vertical_results execute dump_metadata_locks; execute dump_table_handles; execute dump_waits_current; execute dump_waits_history_long; --horizontal_results --connection con2 BEGIN; # MDL lock is PENDING : waiting for the update transaction --send DROP TABLE t1; --connection default # Wait for the DROP TABLE t1 to block let $wait_condition= select count(*) = 1 from performance_schema.events_waits_current where event_name = 'wait/lock/metadata/sql/mdl' and object_name = 't1'; --source include/wait_condition.inc echo "---- Marker 4 ----"; --vertical_results execute dump_metadata_locks; execute dump_table_handles; execute dump_waits_current; execute dump_waits_history_long; --horizontal_results --connection con1 # MDL lock on the update is released, # MDL pending lock is granted for the drop table, then released. COMMIT; --connection con2 # complete DROP TABLE t1 --reap --connection default echo "---- Marker 5 ----"; --vertical_results execute dump_metadata_locks; execute dump_table_handles; execute dump_waits_current; execute dump_waits_history_long; --horizontal_results --connection default TRUNCATE TABLE performance_schema.events_waits_history_long; TRUNCATE TABLE performance_schema.events_waits_history; TRUNCATE TABLE performance_schema.events_waits_current; create table t1 (a int); --connection con1 # Get MDL read lock LOCK TABLE t1 READ; --connection default echo "---- Marker 6 ----"; --vertical_results execute dump_metadata_locks; execute dump_table_handles; execute dump_waits_current; execute dump_waits_history_long; --horizontal_results --connection con2 # User1 has a READ LOCK # User2 waiting for WRITE LOCK --send LOCK TABLE t1 write; --connection default # Wait for the LOCK TABLE t1 write to block let $wait_condition= select count(*) = 1 from performance_schema.events_waits_current where event_name = 'wait/lock/metadata/sql/mdl' and object_name = 't1'; --source include/wait_condition.inc echo "---- Marker 7 ----"; --vertical_results execute dump_metadata_locks; execute dump_table_handles; execute dump_waits_current; execute dump_waits_history_long; --horizontal_results --connection con1 # User1 releases a READ LOCK # User2 granted a WRITE LOCK UNLOCK TABLES; --connection con2 # Complete LOCK TABLE t1 write --reap --connection default echo "---- Marker 8 ----"; --vertical_results execute dump_metadata_locks; execute dump_table_handles; execute dump_waits_current; execute dump_waits_history_long; --horizontal_results --connection con1 # User2 granted a WRITE LOCK # User1 waits for a READ LOCK --send LOCK TABLES t1 read; --connection default # Wait for the LOCK TABLES t1 READ to block let $wait_condition= select count(*) = 1 from performance_schema.events_waits_current where event_name = 'wait/lock/metadata/sql/mdl' and object_name = 't1'; --source include/wait_condition.inc echo "---- Marker 9 ----"; --vertical_results execute dump_metadata_locks; execute dump_table_handles; execute dump_waits_current; execute dump_waits_history_long; --horizontal_results --connection con2 UNLOCK TABLES; --connection con1 # Complete LOCK TABLE t1 read --reap --connection default echo "---- Marker 10 ----"; --vertical_results execute dump_metadata_locks; execute dump_table_handles; execute dump_waits_current; execute dump_waits_history_long; --horizontal_results --connection con1 UNLOCK TABLES; --connection default echo "---- Marker 11 ----"; --vertical_results execute dump_metadata_locks; execute dump_table_handles; execute dump_waits_current; execute dump_waits_history_long; --horizontal_results TRUNCATE TABLE performance_schema.events_waits_history_long; TRUNCATE TABLE performance_schema.events_waits_history; TRUNCATE TABLE performance_schema.events_waits_current; --connection con1 BEGIN; # MDL lock is granted immediately, no wait UPDATE LOW_PRIORITY t1 SET a=8; --connection default echo "---- Marker 12 ----"; --vertical_results execute dump_metadata_locks; execute dump_table_handles; execute dump_waits_current; execute dump_waits_history_long; --horizontal_results --connection con1 COMMIT; --connection default TRUNCATE TABLE performance_schema.events_waits_history_long; TRUNCATE TABLE performance_schema.events_waits_history; TRUNCATE TABLE performance_schema.events_waits_current; --connection con1 SELECT GET_LOCK('test', 0); --connection default echo "---- Marker 13 ----"; --vertical_results execute dump_metadata_locks; execute dump_table_handles; execute dump_waits_current; execute dump_waits_history_long; --horizontal_results --connection con2 --send SELECT GET_LOCK('test', 120); --connection default let $wait_condition= select count(*) = 1 from performance_schema.events_waits_current where event_name = 'wait/lock/metadata/sql/mdl' and object_name = 'test'; --source include/wait_condition.inc echo "---- Marker 14 ----"; --vertical_results execute dump_metadata_locks; execute dump_table_handles; execute dump_waits_current; execute dump_waits_history_long; --horizontal_results --connection con1 SELECT RELEASE_LOCK('test'); --connection con2 --reap --connection default echo "---- Marker 15 ----"; --vertical_results execute dump_metadata_locks; execute dump_table_handles; execute dump_waits_current; execute dump_waits_history_long; --horizontal_results --connection con2 SELECT RELEASE_LOCK('test'); --connection default echo "---- Marker 16 ----"; --vertical_results execute dump_metadata_locks; execute dump_table_handles; execute dump_waits_current; execute dump_waits_history_long; --horizontal_results # Cleanup --disconnect con1 --disconnect con2 --connection default drop table t1; UPDATE performance_schema.setup_instruments SET enabled = 'YES', timed = 'YES'; revoke all privileges, grant option from user1@localhost; revoke all privileges, grant option from user2@localhost; drop user user1@localhost; drop user user2@localhost; drop function thread_id_name; drop prepare dump_metadata_locks; drop prepare dump_table_handles; drop prepare dump_waits_current; drop prepare dump_waits_history_long; delete from performance_schema.setup_objects where object_schema='mtr'; # In case of failure, will indicate the root cause show global status like "performance_schema%";
Close