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.221.207.166
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 : show_plugin.result
================================================================================ SETUP ================================================================================ # Save the initial number of concurrent sessions # Save current SHOW_COMPATIBILITY_56 setting SELECT @@global.show_compatibility_56 INTO @show_compatibility_56_save; # # SET COMPATIBILITY MODE = OFF # SET @@global.show_compatibility_56 = OFF; # Verify EXAMPLE plugin is not loaded SELECT COUNT(*) = 0 AS "Expect 1" FROM information_schema.plugins WHERE plugin_name = "EXAMPLE"; Expect 1 1 # Create one session to force local and global system variables; connect con0, localhost, root,,; connection default; ================================================================================ TEST 1- NO PLUGIN VARS ================================================================================ SHOW GLOBAL STATUS LIKE "example_%"; Variable_name Value SHOW SESSION STATUS LIKE "example_%"; Variable_name Value SHOW GLOBAL VARIABLES LIKE "example_%"; Variable_name Value SHOW SESSION VARIABLES LIKE "example_%"; Variable_name Value SELECT variable_name, variable_value FROM performance_schema.global_status WHERE variable_name LIKE "example_%"; variable_name variable_value SELECT variable_name, variable_value FROM performance_schema.session_status WHERE variable_name LIKE "example_%"; variable_name variable_value SELECT variable_name, variable_value FROM performance_schema.global_variables WHERE variable_name LIKE "example_%"; variable_name variable_value SELECT variable_name, variable_value FROM performance_schema.session_variables WHERE variable_name LIKE "example_%"; variable_name variable_value ================================================================================ TEST 2 - PLUGIN LOAD, UNLOAD, RELOAD ================================================================================ ================================================================================ 2.1 - INSTALL PLUGIN ================================================================================ INSTALL PLUGIN example SONAME 'ha_example.so'; ================================================================================ 2.1a - FORCE SYNC OF LOCAL AND GLOBAL SYSTEM VARS ================================================================================ SHOW GLOBAL STATUS LIKE "example_%"; Variable_name Value example_func_example enum_var is 0, ulong_var is 8, double_var is 8.500000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SHOW SESSION STATUS LIKE "example_%"; Variable_name Value example_func_example enum_var is 0, ulong_var is 8, double_var is 8.500000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SHOW GLOBAL VARIABLES LIKE "example_%"; Variable_name Value example_double_thdvar 8.500000 example_double_var 8.500000 example_enum_var e1 example_ulong_var 8 SHOW SESSION VARIABLES LIKE "example_%"; Variable_name Value example_double_thdvar 8.500000 example_double_var 8.500000 example_enum_var e1 example_ulong_var 8 SELECT variable_name, variable_value FROM performance_schema.global_status WHERE variable_name LIKE "example_%"; variable_name variable_value example_func_example enum_var is 0, ulong_var is 8, double_var is 8.500000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SELECT variable_name, variable_value FROM performance_schema.session_status WHERE variable_name LIKE "example_%"; variable_name variable_value example_func_example enum_var is 0, ulong_var is 8, double_var is 8.500000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SELECT variable_name, variable_value FROM performance_schema.global_variables WHERE variable_name LIKE "example_%"; variable_name variable_value example_double_thdvar 8.500000 example_double_var 8.500000 example_enum_var e1 example_ulong_var 8 SELECT variable_name, variable_value FROM performance_schema.session_variables WHERE variable_name LIKE "example_%"; variable_name variable_value example_double_thdvar 8.500000 example_double_var 8.500000 example_enum_var e1 example_ulong_var 8 disconnect con0; ================================================================================ 2.2 - SET PLUGIN VARS ================================================================================ # GLOBAL SET GLOBAL example_ulong_var = 100; SET GLOBAL example_enum_var = e1; SET GLOBAL example_double_var = 100.9990; SET GLOBAL example_double_thdvar = 101.9991; # SESSION SET SESSION example_double_thdvar = 102.9992; ================================================================================ 2.3 - VERIFY UPDATED PLUGIN VARS ================================================================================ SHOW GLOBAL STATUS LIKE "example_%"; Variable_name Value example_func_example enum_var is 0, ulong_var is 100, double_var is 100.999000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SHOW SESSION STATUS LIKE "example_%"; Variable_name Value example_func_example enum_var is 0, ulong_var is 100, double_var is 100.999000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SHOW GLOBAL VARIABLES LIKE "example_%"; Variable_name Value example_double_thdvar 101.999100 example_double_var 100.999000 example_enum_var e1 example_ulong_var 100 SHOW SESSION VARIABLES LIKE "example_%"; Variable_name Value example_double_thdvar 102.999200 example_double_var 100.999000 example_enum_var e1 example_ulong_var 100 SELECT variable_name, variable_value FROM performance_schema.global_status WHERE variable_name LIKE "example_%"; variable_name variable_value example_func_example enum_var is 0, ulong_var is 100, double_var is 100.999000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SELECT variable_name, variable_value FROM performance_schema.session_status WHERE variable_name LIKE "example_%"; variable_name variable_value example_func_example enum_var is 0, ulong_var is 100, double_var is 100.999000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SELECT variable_name, variable_value FROM performance_schema.global_variables WHERE variable_name LIKE "example_%"; variable_name variable_value example_double_thdvar 101.999100 example_double_var 100.999000 example_enum_var e1 example_ulong_var 100 SELECT variable_name, variable_value FROM performance_schema.session_variables WHERE variable_name LIKE "example_%"; variable_name variable_value example_double_thdvar 102.999200 example_double_var 100.999000 example_enum_var e1 example_ulong_var 100 ================================================================================ 2.4 - UNINSTALL PLUGIN ================================================================================ UNINSTALL PLUGIN example; ================================================================================ 2.5 - VERIFY NO PLUGIN VARS ================================================================================ SHOW GLOBAL STATUS LIKE "example_%"; Variable_name Value SHOW SESSION STATUS LIKE "example_%"; Variable_name Value SHOW GLOBAL VARIABLES LIKE "example_%"; Variable_name Value SHOW SESSION VARIABLES LIKE "example_%"; Variable_name Value SELECT variable_name, variable_value FROM performance_schema.global_status WHERE variable_name LIKE "example_%"; variable_name variable_value SELECT variable_name, variable_value FROM performance_schema.session_status WHERE variable_name LIKE "example_%"; variable_name variable_value SELECT variable_name, variable_value FROM performance_schema.global_variables WHERE variable_name LIKE "example_%"; variable_name variable_value SELECT variable_name, variable_value FROM performance_schema.session_variables WHERE variable_name LIKE "example_%"; variable_name variable_value ================================================================================ 2.6 - REINSTALL PLUGIN ================================================================================ # Reinstall EXAMPLE plugin INSTALL PLUGIN example SONAME 'ha_example.so'; ================================================================================ 2.7 - SET PLUGIN VARS AGAIN ================================================================================ # GLOBAL SET GLOBAL example_ulong_var = 200; SET GLOBAL example_enum_var = e2; SET GLOBAL example_double_var = 200.8880; SET GLOBAL example_double_thdvar = 201.8881; # SESSION SET SESSION example_double_thdvar = 202.8882; ================================================================================ 2.8 - VERIFY PLUGIN VARS ================================================================================ SHOW GLOBAL STATUS LIKE "example_%"; Variable_name Value example_func_example enum_var is 1, ulong_var is 200, double_var is 200.888000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SHOW SESSION STATUS LIKE "example_%"; Variable_name Value example_func_example enum_var is 1, ulong_var is 200, double_var is 200.888000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SHOW GLOBAL VARIABLES LIKE "example_%"; Variable_name Value example_double_thdvar 201.888100 example_double_var 200.888000 example_enum_var e2 example_ulong_var 200 SHOW SESSION VARIABLES LIKE "example_%"; Variable_name Value example_double_thdvar 202.888200 example_double_var 200.888000 example_enum_var e2 example_ulong_var 200 SELECT variable_name, variable_value FROM performance_schema.global_status WHERE variable_name LIKE "example_%"; variable_name variable_value example_func_example enum_var is 1, ulong_var is 200, double_var is 200.888000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SELECT variable_name, variable_value FROM performance_schema.session_status WHERE variable_name LIKE "example_%"; variable_name variable_value example_func_example enum_var is 1, ulong_var is 200, double_var is 200.888000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SELECT variable_name, variable_value FROM performance_schema.global_variables WHERE variable_name LIKE "example_%"; variable_name variable_value example_double_thdvar 201.888100 example_double_var 200.888000 example_enum_var e2 example_ulong_var 200 SELECT variable_name, variable_value FROM performance_schema.session_variables WHERE variable_name LIKE "example_%"; variable_name variable_value example_double_thdvar 202.888200 example_double_var 200.888000 example_enum_var e2 example_ulong_var 200 ================================================================================ 2.9 - UNINSTALL PLUGIN ================================================================================ UNINSTALL PLUGIN example; ================================================================================ 2.10 - VERIFY NO PLUGIN VARS ================================================================================ SHOW GLOBAL STATUS LIKE "example_%"; Variable_name Value SHOW SESSION STATUS LIKE "example_%"; Variable_name Value SHOW GLOBAL VARIABLES LIKE "example_%"; Variable_name Value SHOW SESSION VARIABLES LIKE "example_%"; Variable_name Value SELECT variable_name, variable_value FROM performance_schema.global_status WHERE variable_name LIKE "example_%"; variable_name variable_value SELECT variable_name, variable_value FROM performance_schema.session_status WHERE variable_name LIKE "example_%"; variable_name variable_value SELECT variable_name, variable_value FROM performance_schema.global_variables WHERE variable_name LIKE "example_%"; variable_name variable_value SELECT variable_name, variable_value FROM performance_schema.session_variables WHERE variable_name LIKE "example_%"; variable_name variable_value ================================================================================ TEST 3 - SESSION PLUGIN VARS ON MULTIPLE CONNECTIONS ================================================================================ ================================================================================ 3.1 - INSTALL PLUGIN ================================================================================ INSTALL PLUGIN example SONAME 'ha_example.so'; ================================================================================ 3.2 - SET GLOBAL AND DEFAULT CONNECTION VARS ================================================================================ connection default; SET GLOBAL example_ulong_var = 300; SET GLOBAL example_enum_var = e1; SET GLOBAL example_double_var = 301.0000; SET GLOBAL example_double_thdvar = 302.0000; SET SESSION example_double_thdvar = 300.0000; ================================================================================ 3.3 - CONNECT 3 CLIENTS, SET LOCAL PLUGIN VARS ================================================================================ connect con1, localhost, root,,; SET SESSION example_double_thdvar = 300.1111; connect con2, localhost, root,,; SET SESSION example_double_thdvar = 300.2222; connect con3, localhost, root,,; SET SESSION example_double_thdvar = 300.3333; connection default; ================================================================================ 3.4 - VERIFY GLOBAL AND SESSION PLUGIN VARS ================================================================================ SHOW GLOBAL STATUS LIKE "example_%"; Variable_name Value example_func_example enum_var is 0, ulong_var is 300, double_var is 301.000000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SHOW SESSION STATUS LIKE "example_%"; Variable_name Value example_func_example enum_var is 0, ulong_var is 300, double_var is 301.000000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SHOW GLOBAL VARIABLES LIKE "example_%"; Variable_name Value example_double_thdvar 302.000000 example_double_var 301.000000 example_enum_var e1 example_ulong_var 300 SHOW SESSION VARIABLES LIKE "example_%"; Variable_name Value example_double_thdvar 300.000000 example_double_var 301.000000 example_enum_var e1 example_ulong_var 300 SELECT variable_name, variable_value FROM performance_schema.global_status WHERE variable_name LIKE "example_%"; variable_name variable_value example_func_example enum_var is 0, ulong_var is 300, double_var is 301.000000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SELECT variable_name, variable_value FROM performance_schema.session_status WHERE variable_name LIKE "example_%"; variable_name variable_value example_func_example enum_var is 0, ulong_var is 300, double_var is 301.000000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SELECT variable_name, variable_value FROM performance_schema.global_variables WHERE variable_name LIKE "example_%"; variable_name variable_value example_double_thdvar 302.000000 example_double_var 301.000000 example_enum_var e1 example_ulong_var 300 SELECT variable_name, variable_value FROM performance_schema.session_variables WHERE variable_name LIKE "example_%"; variable_name variable_value example_double_thdvar 300.000000 example_double_var 301.000000 example_enum_var e1 example_ulong_var 300 # Variables by thread SELECT variable_name, variable_value FROM performance_schema.variables_by_thread WHERE variable_name LIKE "example_%" ORDER BY variable_value; variable_name variable_value example_double_thdvar 300.000000 example_double_thdvar 300.111100 example_double_thdvar 300.222200 example_double_thdvar 300.333300 ================================================================================ 3.5 - DISCONNECT CLIENTS ================================================================================ connection con1; disconnect con1; connection con2; disconnect con2; connection con3; disconnect con3; connection default; ================================================================================ 3.6 - VERIFY SESSION VARS ARE REMOVED ================================================================================ SHOW GLOBAL STATUS LIKE "example_%"; Variable_name Value example_func_example enum_var is 0, ulong_var is 300, double_var is 301.000000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SHOW SESSION STATUS LIKE "example_%"; Variable_name Value example_func_example enum_var is 0, ulong_var is 300, double_var is 301.000000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SHOW GLOBAL VARIABLES LIKE "example_%"; Variable_name Value example_double_thdvar 302.000000 example_double_var 301.000000 example_enum_var e1 example_ulong_var 300 SHOW SESSION VARIABLES LIKE "example_%"; Variable_name Value example_double_thdvar 300.000000 example_double_var 301.000000 example_enum_var e1 example_ulong_var 300 SELECT variable_name, variable_value FROM performance_schema.global_status WHERE variable_name LIKE "example_%"; variable_name variable_value example_func_example enum_var is 0, ulong_var is 300, double_var is 301.000000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SELECT variable_name, variable_value FROM performance_schema.session_status WHERE variable_name LIKE "example_%"; variable_name variable_value example_func_example enum_var is 0, ulong_var is 300, double_var is 301.000000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SELECT variable_name, variable_value FROM performance_schema.global_variables WHERE variable_name LIKE "example_%"; variable_name variable_value example_double_thdvar 302.000000 example_double_var 301.000000 example_enum_var e1 example_ulong_var 300 SELECT variable_name, variable_value FROM performance_schema.session_variables WHERE variable_name LIKE "example_%"; variable_name variable_value example_double_thdvar 300.000000 example_double_var 301.000000 example_enum_var e1 example_ulong_var 300 # Variables by thread SELECT variable_name, variable_value FROM performance_schema.variables_by_thread WHERE variable_name LIKE "example_%" ORDER BY variable_value; variable_name variable_value example_double_thdvar 300.000000 ================================================================================ 3.7 - RECONNECT 3 CLIENTS, SET SESSION VARS FOR EACH ================================================================================ connect con1, localhost, root,,; SET SESSION example_double_thdvar = 311.1111; connect con2, localhost, root,,; SET SESSION example_double_thdvar = 322.2222; connect con3, localhost, root,,; SET SESSION example_double_thdvar = 333.3333; connection default; ================================================================================ 3.8 - VERIFY GLOBAL AND SESSION VARS ================================================================================ SHOW GLOBAL STATUS LIKE "example_%"; Variable_name Value example_func_example enum_var is 0, ulong_var is 300, double_var is 301.000000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SHOW SESSION STATUS LIKE "example_%"; Variable_name Value example_func_example enum_var is 0, ulong_var is 300, double_var is 301.000000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SHOW GLOBAL VARIABLES LIKE "example_%"; Variable_name Value example_double_thdvar 302.000000 example_double_var 301.000000 example_enum_var e1 example_ulong_var 300 SHOW SESSION VARIABLES LIKE "example_%"; Variable_name Value example_double_thdvar 300.000000 example_double_var 301.000000 example_enum_var e1 example_ulong_var 300 SELECT variable_name, variable_value FROM performance_schema.global_status WHERE variable_name LIKE "example_%"; variable_name variable_value example_func_example enum_var is 0, ulong_var is 300, double_var is 301.000000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SELECT variable_name, variable_value FROM performance_schema.session_status WHERE variable_name LIKE "example_%"; variable_name variable_value example_func_example enum_var is 0, ulong_var is 300, double_var is 301.000000, really example_status_array_var1 100 example_status_array_var2 20.010000 example_status_var3 three hundred example_status_var4 ON example_status_var5 OFF example_status_var6 8250 SELECT variable_name, variable_value FROM performance_schema.global_variables WHERE variable_name LIKE "example_%"; variable_name variable_value example_double_thdvar 302.000000 example_double_var 301.000000 example_enum_var e1 example_ulong_var 300 SELECT variable_name, variable_value FROM performance_schema.session_variables WHERE variable_name LIKE "example_%"; variable_name variable_value example_double_thdvar 300.000000 example_double_var 301.000000 example_enum_var e1 example_ulong_var 300 # Variables by thread SELECT variable_name, variable_value FROM performance_schema.variables_by_thread WHERE variable_name LIKE "example_%" ORDER BY variable_value; variable_name variable_value example_double_thdvar 300.000000 example_double_thdvar 311.111100 example_double_thdvar 322.222200 example_double_thdvar 333.333300 ================================================================================ 3.9 - UNINSTALL PLUGIN, LEAVE CLIENTS CONNECTED ================================================================================ UNINSTALL PLUGIN example; ================================================================================ 3.10 - VERIFY SESSION VARS ARE REMOVED ================================================================================ SHOW GLOBAL STATUS LIKE "example_%"; Variable_name Value SHOW SESSION STATUS LIKE "example_%"; Variable_name Value SHOW GLOBAL VARIABLES LIKE "example_%"; Variable_name Value SHOW SESSION VARIABLES LIKE "example_%"; Variable_name Value SELECT variable_name, variable_value FROM performance_schema.global_status WHERE variable_name LIKE "example_%"; variable_name variable_value SELECT variable_name, variable_value FROM performance_schema.session_status WHERE variable_name LIKE "example_%"; variable_name variable_value SELECT variable_name, variable_value FROM performance_schema.global_variables WHERE variable_name LIKE "example_%"; variable_name variable_value SELECT variable_name, variable_value FROM performance_schema.session_variables WHERE variable_name LIKE "example_%"; variable_name variable_value # VARIABLES BY THREAD SELECT variable_name, variable_value FROM performance_schema.variables_by_thread WHERE variable_name LIKE "example_%" ORDER BY variable_value; variable_name variable_value ================================================================================ 3.11 - DISCONNECT CLIENTS ================================================================================ connection con1; disconnect con1; connection con2; disconnect con2; connection con3; disconnect con3; connection default; ================================================================================ 3.12 - VERIFY CLIENTS ARE REMOVED ================================================================================ SHOW GLOBAL STATUS LIKE "example_%"; Variable_name Value SHOW SESSION STATUS LIKE "example_%"; Variable_name Value SHOW GLOBAL VARIABLES LIKE "example_%"; Variable_name Value SHOW SESSION VARIABLES LIKE "example_%"; Variable_name Value SELECT variable_name, variable_value FROM performance_schema.global_status WHERE variable_name LIKE "example_%"; variable_name variable_value SELECT variable_name, variable_value FROM performance_schema.session_status WHERE variable_name LIKE "example_%"; variable_name variable_value SELECT variable_name, variable_value FROM performance_schema.global_variables WHERE variable_name LIKE "example_%"; variable_name variable_value SELECT variable_name, variable_value FROM performance_schema.session_variables WHERE variable_name LIKE "example_%"; variable_name variable_value # VARIABLES BY THREAD SELECT variable_name, variable_value FROM performance_schema.variables_by_thread WHERE variable_name LIKE "example_%" ORDER BY variable_value; variable_name variable_value ================================================================================ TEST 4 - BUG#18008907: DEADLOCK WITH CHANGE_USER, SHOW VARIABLES, INSTALL PLUGIN ================================================================================ CREATE PROCEDURE install_no_such_plugin() BEGIN INSTALL PLUGIN no_such_plugin SONAME 'no_such_object'; END| CREATE PROCEDURE show_vars() BEGIN -- select on information_schema.global_variables -- will fail, still need to cover execution of the code -- to verify potential dead locks. declare continue handler for sqlexception begin end; SELECT COUNT(*) FROM information_schema.global_variables; SELECT COUNT(*) FROM performance_schema.global_variables; END| ================================================================================ 4.1 - DEADLOCK SCENARIO 1: con1 - has LOCK_system_variables_hash and waits on LOCK_plugin AND default - has LOCK_plugin and waits on LOCK_system_variables_hash ================================================================================ connect con1, localhost, root,,; SET DEBUG_SYNC='acquired_LOCK_system_variables_hash SIGNAL install_plugin WAIT_FOR cont_show_vars'; call show_vars();; connection default; SET DEBUG_SYNC='now WAIT_FOR install_plugin'; SET DEBUG_SYNC='acquired_LOCK_plugin SIGNAL cont_show_vars'; call install_no_such_plugin();; connection con1; # Without fix, reap will hang. COUNT(*) # SET DEBUG_SYNC='RESET'; connection default; ERROR HY000: Can't open shared library SET DEBUG_SYNC='RESET'; ================================================================================ 4.2 - DEADLOCK SCENARIO 2: default - has LOCK_system_variables_hash, waits on LOCK_global_system_variables con1 - has LOCK_plugin, waits on LOCK_system_variables_hash AND con2 - has LOCK_global_system_variables, waits on LOCK_plugin ================================================================================ SET DEBUG_SYNC='acquired_LOCK_system_variables_hash SIGNAL install_plugin WAIT_FOR nothing TIMEOUT 10'; call show_vars();; connection con1; SET DEBUG_SYNC='now WAIT_FOR install_plugin'; SET DEBUG_SYNC='acquired_LOCK_plugin SIGNAL create_connection WAIT_FOR nothing TIMEOUT 10'; call install_no_such_plugin();; connect con2, localhost, root,,; SET DEBUG_SYNC='now WAIT_FOR create_connection'; # Without fix, deadlock situation will occur on timeout of debug_syncs in # default and con1. Because of this, change_user operation hangs. change_user connection con1; ERROR HY000: Can't open shared library connection default; COUNT(*) # disconnect con2; ================================================================================ 4.3 - DEADLOCK SCENARIO 3: CONCURRENT SHOW VARIABLES AND UNINSTALL PLUGIN ================================================================================ # # INSTALL PLUGIN # INSTALL PLUGIN example SONAME 'ha_example.so'; connection con1; # Acquiring LOCK_system_variables_hash and LOCK_plugin_delete SET DEBUG_SYNC='acquired_LOCK_system_variables_hash SIGNAL uninstall_plugin WAIT_FOR go'; call show_vars();; connect con2, localhost, root,,; # # UNINSTALL PLUGIN # SET DEBUG_SYNC='now WAIT_FOR uninstall_plugin'; UNINSTALL PLUGIN example;; connection default; # Uninstall will wait until SHOW VARIABLES releases LOCK_plugin_delete. SET DEBUG_SYNC='now SIGNAL go'; # Connect con1 - reap connection con1; COUNT(*) # # Connect con2 - reap connection con2; ================================================================================ TEST 5 - BUG#22225549 MYSQL_CHANGE_USER/MYSQL_RESET_CONNECTION + SET INNODB... Update to plugin-defined session variable triggers resync with global variables and deadlocks on THD::LOCK_thd_sysvar. ================================================================================ SELECT @@global.show_compatibility_56; @@global.show_compatibility_56 0 select @@session.innodb_strict_mode; @@session.innodb_strict_mode 1 select user(), current_user(); user() current_user() root@localhost root@localhost change_user root # # Trigger a resync of session variables with global variables. # set @@session.innodb_strict_mode=off; # Restore set @@session.innodb_strict_mode=1; select @@session.innodb_strict_mode; @@session.innodb_strict_mode 1 ================================================================================ CLEAN UP ================================================================================ connection default; DROP PROCEDURE show_vars; DROP PROCEDURE install_no_such_plugin; SET DEBUG_SYNC='RESET'; disconnect con1; disconnect con2; # Restore SHOW_COMPATIBILITY_56 setting SET @@global.show_compatibility_56 = @show_compatibility_56_save; # Wait till we reached the initial number of concurrent sessions
Close