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 /
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 : mdl_func.result
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','')); Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. grant ALL on *.* to user1@localhost; 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. grant ALL on *.* to user2@localhost; 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. set sql_mode= @orig_sql_mode; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. insert into performance_schema.setup_objects (object_type, object_schema, object_name, enabled, timed) values ('TABLE', 'mtr', '%', 'NO', 'NO'); # Switch to (con1, localhost, user1, , ) # Switch to (con2, localhost, user2, , ) drop function if exists thread_id_name; 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; // select thread_id_name(NULL); thread_id_name(NULL) NULL select thread_id_name(@user1_tid); thread_id_name(@user1_tid) USER1 select thread_id_name(@user2_tid); thread_id_name(@user2_tid) USER2 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\';"; truncate table performance_schema.events_statements_summary_by_digest; flush status; flush tables; DROP TABLE IF EXISTS t1; 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; BEGIN; SELECT * from t1 where id=1; id b 1 initial value "---- Marker 1 ----" execute dump_metadata_locks; OBJECT_TYPE FUNCTION OBJECT_SCHEMA test OBJECT_NAME thread_id_name LOCK_TYPE SHARED LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA performance_schema OBJECT_NAME metadata_locks LOCK_TYPE SHARED_READ LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 LOCK_TYPE SHARED_READ LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID USER1 execute dump_table_handles; OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER execute dump_waits_current; execute dump_waits_history_long; COMMIT; "---- Marker 2 ----" execute dump_metadata_locks; OBJECT_TYPE FUNCTION OBJECT_SCHEMA test OBJECT_NAME thread_id_name LOCK_TYPE SHARED LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA performance_schema OBJECT_NAME metadata_locks LOCK_TYPE SHARED_READ LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER execute dump_table_handles; OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER execute dump_waits_current; execute dump_waits_history_long; BEGIN; UPDATE t1 set b="new value" where id=2; "---- Marker 3 ----" execute dump_metadata_locks; OBJECT_TYPE FUNCTION OBJECT_SCHEMA test OBJECT_NAME thread_id_name LOCK_TYPE SHARED LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA performance_schema OBJECT_NAME metadata_locks LOCK_TYPE SHARED_READ LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 LOCK_TYPE SHARED_WRITE LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID USER1 execute dump_table_handles; OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER execute dump_waits_current; execute dump_waits_history_long; BEGIN; DROP TABLE t1;; "---- Marker 4 ----" execute dump_metadata_locks; OBJECT_TYPE FUNCTION OBJECT_SCHEMA test OBJECT_NAME thread_id_name LOCK_TYPE SHARED LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE GLOBAL OBJECT_SCHEMA NULL OBJECT_NAME NULL LOCK_TYPE INTENTION_EXCLUSIVE LOCK_DURATION STATEMENT LOCK_STATUS GRANTED OWNER_THREAD_ID USER2 OBJECT_TYPE SCHEMA OBJECT_SCHEMA test OBJECT_NAME NULL LOCK_TYPE INTENTION_EXCLUSIVE LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID USER2 OBJECT_TYPE TABLE OBJECT_SCHEMA performance_schema OBJECT_NAME metadata_locks LOCK_TYPE SHARED_READ LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 LOCK_TYPE EXCLUSIVE LOCK_DURATION TRANSACTION LOCK_STATUS PENDING OWNER_THREAD_ID USER2 OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 LOCK_TYPE SHARED_WRITE LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID USER1 execute dump_table_handles; OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER execute dump_waits_current; THREAD_ID USER2 EVENT_NAME wait/lock/metadata/sql/mdl TIMER_START_SET 1 TIMER_END_SET 1 OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INDEX_NAME NULL OPERATION metadata lock execute dump_waits_history_long; COMMIT; "---- Marker 5 ----" execute dump_metadata_locks; OBJECT_TYPE FUNCTION OBJECT_SCHEMA test OBJECT_NAME thread_id_name LOCK_TYPE SHARED LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA performance_schema OBJECT_NAME metadata_locks LOCK_TYPE SHARED_READ LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER execute dump_table_handles; execute dump_waits_current; THREAD_ID USER2 EVENT_NAME wait/lock/metadata/sql/mdl TIMER_START_SET 1 TIMER_END_SET 1 OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INDEX_NAME NULL OPERATION metadata lock execute dump_waits_history_long; THREAD_ID USER2 EVENT_NAME wait/lock/metadata/sql/mdl TIMER_START_SET 1 TIMER_END_SET 1 OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INDEX_NAME NULL OPERATION metadata lock 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); LOCK TABLE t1 READ; "---- Marker 6 ----" execute dump_metadata_locks; OBJECT_TYPE FUNCTION OBJECT_SCHEMA test OBJECT_NAME thread_id_name LOCK_TYPE SHARED LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA performance_schema OBJECT_NAME metadata_locks LOCK_TYPE SHARED_READ LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 LOCK_TYPE SHARED_READ_ONLY LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID USER1 execute dump_table_handles; OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK READ EXTERNAL OWNER_THREAD_ID USER1 execute dump_waits_current; execute dump_waits_history_long; LOCK TABLE t1 write;; "---- Marker 7 ----" execute dump_metadata_locks; OBJECT_TYPE FUNCTION OBJECT_SCHEMA test OBJECT_NAME thread_id_name LOCK_TYPE SHARED LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE GLOBAL OBJECT_SCHEMA NULL OBJECT_NAME NULL LOCK_TYPE INTENTION_EXCLUSIVE LOCK_DURATION STATEMENT LOCK_STATUS GRANTED OWNER_THREAD_ID USER2 OBJECT_TYPE SCHEMA OBJECT_SCHEMA test OBJECT_NAME NULL LOCK_TYPE INTENTION_EXCLUSIVE LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID USER2 OBJECT_TYPE TABLE OBJECT_SCHEMA performance_schema OBJECT_NAME metadata_locks LOCK_TYPE SHARED_READ LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 LOCK_TYPE SHARED_NO_READ_WRITE LOCK_DURATION TRANSACTION LOCK_STATUS PENDING OWNER_THREAD_ID USER2 OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 LOCK_TYPE SHARED_READ_ONLY LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID USER1 execute dump_table_handles; OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK READ EXTERNAL OWNER_THREAD_ID USER1 execute dump_waits_current; THREAD_ID USER2 EVENT_NAME wait/lock/metadata/sql/mdl TIMER_START_SET 1 TIMER_END_SET 1 OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INDEX_NAME NULL OPERATION metadata lock execute dump_waits_history_long; UNLOCK TABLES; "---- Marker 8 ----" execute dump_metadata_locks; OBJECT_TYPE FUNCTION OBJECT_SCHEMA test OBJECT_NAME thread_id_name LOCK_TYPE SHARED LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE GLOBAL OBJECT_SCHEMA NULL OBJECT_NAME NULL LOCK_TYPE INTENTION_EXCLUSIVE LOCK_DURATION STATEMENT LOCK_STATUS GRANTED OWNER_THREAD_ID USER2 OBJECT_TYPE SCHEMA OBJECT_SCHEMA test OBJECT_NAME NULL LOCK_TYPE INTENTION_EXCLUSIVE LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID USER2 OBJECT_TYPE TABLE OBJECT_SCHEMA performance_schema OBJECT_NAME metadata_locks LOCK_TYPE SHARED_READ LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 LOCK_TYPE SHARED_NO_READ_WRITE LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID USER2 execute dump_table_handles; OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK WRITE EXTERNAL OWNER_THREAD_ID USER2 execute dump_waits_current; execute dump_waits_history_long; THREAD_ID USER2 EVENT_NAME wait/lock/metadata/sql/mdl TIMER_START_SET 1 TIMER_END_SET 1 OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INDEX_NAME NULL OPERATION metadata lock LOCK TABLES t1 read;; "---- Marker 9 ----" execute dump_metadata_locks; OBJECT_TYPE FUNCTION OBJECT_SCHEMA test OBJECT_NAME thread_id_name LOCK_TYPE SHARED LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE GLOBAL OBJECT_SCHEMA NULL OBJECT_NAME NULL LOCK_TYPE INTENTION_EXCLUSIVE LOCK_DURATION STATEMENT LOCK_STATUS GRANTED OWNER_THREAD_ID USER2 OBJECT_TYPE SCHEMA OBJECT_SCHEMA test OBJECT_NAME NULL LOCK_TYPE INTENTION_EXCLUSIVE LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID USER2 OBJECT_TYPE TABLE OBJECT_SCHEMA performance_schema OBJECT_NAME metadata_locks LOCK_TYPE SHARED_READ LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 LOCK_TYPE SHARED_NO_READ_WRITE LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID USER2 OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 LOCK_TYPE SHARED_READ_ONLY LOCK_DURATION TRANSACTION LOCK_STATUS PENDING OWNER_THREAD_ID USER1 execute dump_table_handles; OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK WRITE EXTERNAL OWNER_THREAD_ID USER2 execute dump_waits_current; THREAD_ID USER1 EVENT_NAME wait/lock/metadata/sql/mdl TIMER_START_SET 1 TIMER_END_SET 1 OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INDEX_NAME NULL OPERATION metadata lock execute dump_waits_history_long; THREAD_ID USER2 EVENT_NAME wait/lock/metadata/sql/mdl TIMER_START_SET 1 TIMER_END_SET 1 OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INDEX_NAME NULL OPERATION metadata lock UNLOCK TABLES; "---- Marker 10 ----" execute dump_metadata_locks; OBJECT_TYPE FUNCTION OBJECT_SCHEMA test OBJECT_NAME thread_id_name LOCK_TYPE SHARED LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA performance_schema OBJECT_NAME metadata_locks LOCK_TYPE SHARED_READ LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 LOCK_TYPE SHARED_READ_ONLY LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID USER1 execute dump_table_handles; OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK READ EXTERNAL OWNER_THREAD_ID USER1 execute dump_waits_current; execute dump_waits_history_long; THREAD_ID USER2 EVENT_NAME wait/lock/metadata/sql/mdl TIMER_START_SET 1 TIMER_END_SET 1 OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INDEX_NAME NULL OPERATION metadata lock THREAD_ID USER1 EVENT_NAME wait/lock/metadata/sql/mdl TIMER_START_SET 1 TIMER_END_SET 1 OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INDEX_NAME NULL OPERATION metadata lock UNLOCK TABLES; "---- Marker 11 ----" execute dump_metadata_locks; OBJECT_TYPE FUNCTION OBJECT_SCHEMA test OBJECT_NAME thread_id_name LOCK_TYPE SHARED LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA performance_schema OBJECT_NAME metadata_locks LOCK_TYPE SHARED_READ LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER execute dump_table_handles; OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER execute dump_waits_current; execute dump_waits_history_long; THREAD_ID USER2 EVENT_NAME wait/lock/metadata/sql/mdl TIMER_START_SET 1 TIMER_END_SET 1 OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INDEX_NAME NULL OPERATION metadata lock THREAD_ID USER1 EVENT_NAME wait/lock/metadata/sql/mdl TIMER_START_SET 1 TIMER_END_SET 1 OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INDEX_NAME NULL OPERATION metadata lock TRUNCATE TABLE performance_schema.events_waits_history_long; TRUNCATE TABLE performance_schema.events_waits_history; TRUNCATE TABLE performance_schema.events_waits_current; BEGIN; UPDATE LOW_PRIORITY t1 SET a=8; "---- Marker 12 ----" execute dump_metadata_locks; OBJECT_TYPE FUNCTION OBJECT_SCHEMA test OBJECT_NAME thread_id_name LOCK_TYPE SHARED LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA performance_schema OBJECT_NAME metadata_locks LOCK_TYPE SHARED_READ LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 LOCK_TYPE SHARED_WRITE_LOW_PRIO LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID USER1 execute dump_table_handles; OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER execute dump_waits_current; execute dump_waits_history_long; COMMIT; TRUNCATE TABLE performance_schema.events_waits_history_long; TRUNCATE TABLE performance_schema.events_waits_history; TRUNCATE TABLE performance_schema.events_waits_current; SELECT GET_LOCK('test', 0); GET_LOCK('test', 0) 1 "---- Marker 13 ----" execute dump_metadata_locks; OBJECT_TYPE FUNCTION OBJECT_SCHEMA test OBJECT_NAME thread_id_name LOCK_TYPE SHARED LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA performance_schema OBJECT_NAME metadata_locks LOCK_TYPE SHARED_READ LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE USER LEVEL LOCK OBJECT_SCHEMA NULL OBJECT_NAME test LOCK_TYPE EXCLUSIVE LOCK_DURATION EXPLICIT LOCK_STATUS GRANTED OWNER_THREAD_ID USER1 execute dump_table_handles; OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER execute dump_waits_current; execute dump_waits_history_long; SELECT GET_LOCK('test', 120);; "---- Marker 14 ----" execute dump_metadata_locks; OBJECT_TYPE FUNCTION OBJECT_SCHEMA test OBJECT_NAME thread_id_name LOCK_TYPE SHARED LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA performance_schema OBJECT_NAME metadata_locks LOCK_TYPE SHARED_READ LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE USER LEVEL LOCK OBJECT_SCHEMA NULL OBJECT_NAME test LOCK_TYPE EXCLUSIVE LOCK_DURATION EXPLICIT LOCK_STATUS GRANTED OWNER_THREAD_ID USER1 OBJECT_TYPE USER LEVEL LOCK OBJECT_SCHEMA NULL OBJECT_NAME test LOCK_TYPE EXCLUSIVE LOCK_DURATION EXPLICIT LOCK_STATUS PENDING OWNER_THREAD_ID USER2 execute dump_table_handles; OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER execute dump_waits_current; THREAD_ID USER2 EVENT_NAME wait/lock/metadata/sql/mdl TIMER_START_SET 1 TIMER_END_SET 1 OBJECT_TYPE USER LEVEL LOCK OBJECT_SCHEMA NULL OBJECT_NAME test INDEX_NAME NULL OPERATION metadata lock execute dump_waits_history_long; SELECT RELEASE_LOCK('test'); RELEASE_LOCK('test') 1 GET_LOCK('test', 120) 1 "---- Marker 15 ----" execute dump_metadata_locks; OBJECT_TYPE FUNCTION OBJECT_SCHEMA test OBJECT_NAME thread_id_name LOCK_TYPE SHARED LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA performance_schema OBJECT_NAME metadata_locks LOCK_TYPE SHARED_READ LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE USER LEVEL LOCK OBJECT_SCHEMA NULL OBJECT_NAME test LOCK_TYPE EXCLUSIVE LOCK_DURATION EXPLICIT LOCK_STATUS GRANTED OWNER_THREAD_ID USER2 execute dump_table_handles; OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER execute dump_waits_current; THREAD_ID USER2 EVENT_NAME wait/lock/metadata/sql/mdl TIMER_START_SET 1 TIMER_END_SET 1 OBJECT_TYPE USER LEVEL LOCK OBJECT_SCHEMA NULL OBJECT_NAME test INDEX_NAME NULL OPERATION metadata lock execute dump_waits_history_long; THREAD_ID USER2 EVENT_NAME wait/lock/metadata/sql/mdl TIMER_START_SET 1 TIMER_END_SET 1 OBJECT_TYPE USER LEVEL LOCK OBJECT_SCHEMA NULL OBJECT_NAME test INDEX_NAME NULL OPERATION metadata lock SELECT RELEASE_LOCK('test'); RELEASE_LOCK('test') 1 "---- Marker 16 ----" execute dump_metadata_locks; OBJECT_TYPE FUNCTION OBJECT_SCHEMA test OBJECT_NAME thread_id_name LOCK_TYPE SHARED LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA performance_schema OBJECT_NAME metadata_locks LOCK_TYPE SHARED_READ LOCK_DURATION TRANSACTION LOCK_STATUS GRANTED OWNER_THREAD_ID OTHER execute dump_table_handles; OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER OBJECT_TYPE TABLE OBJECT_SCHEMA test OBJECT_NAME t1 INTERNAL_LOCK NULL EXTERNAL_LOCK NULL OWNER_THREAD_ID OTHER execute dump_waits_current; THREAD_ID USER2 EVENT_NAME wait/lock/metadata/sql/mdl TIMER_START_SET 1 TIMER_END_SET 1 OBJECT_TYPE USER LEVEL LOCK OBJECT_SCHEMA NULL OBJECT_NAME test INDEX_NAME NULL OPERATION metadata lock execute dump_waits_history_long; THREAD_ID USER2 EVENT_NAME wait/lock/metadata/sql/mdl TIMER_START_SET 1 TIMER_END_SET 1 OBJECT_TYPE USER LEVEL LOCK OBJECT_SCHEMA NULL OBJECT_NAME test INDEX_NAME NULL OPERATION metadata lock 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'; 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