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.218.106.172
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
perfschema /
t /
[ HOME SHELL ]
Name
Size
Permission
Action
all_tests.test
2.51
KB
-rw-r--r--
alter_table_progress.test
3.31
KB
-rw-r--r--
bad_option.test
2.95
KB
-rw-r--r--
batch_table_io_func.test
3.53
KB
-rw-r--r--
binlog_edge_mix-master.opt
41
B
-rw-r--r--
binlog_edge_mix.test
208
B
-rw-r--r--
binlog_edge_row-master.opt
41
B
-rw-r--r--
binlog_edge_row.test
206
B
-rw-r--r--
binlog_edge_stmt-master.opt
41
B
-rw-r--r--
binlog_edge_stmt.test
212
B
-rw-r--r--
binlog_ok_mix-master.opt
41
B
-rw-r--r--
binlog_ok_mix.test
206
B
-rw-r--r--
binlog_ok_row-master.opt
41
B
-rw-r--r--
binlog_ok_row.test
204
B
-rw-r--r--
binlog_ok_stmt-master.opt
41
B
-rw-r--r--
binlog_ok_stmt.test
210
B
-rw-r--r--
checksum.test
7.57
KB
-rw-r--r--
cnf_option.cnf
273
B
-rw-r--r--
cnf_option.test
295
B
-rw-r--r--
column_privilege.test
1.82
KB
-rw-r--r--
connect_attrs.test
2.22
KB
-rw-r--r--
connection.test
163
B
-rw-r--r--
connection_3a-master.opt
43
B
-rw-r--r--
connection_3a.test
163
B
-rw-r--r--
connection_3a_3u-master.opt
83
B
-rw-r--r--
connection_3a_3u.test
163
B
-rw-r--r--
connection_3u-master.opt
40
B
-rw-r--r--
connection_3u.test
163
B
-rw-r--r--
connection_type_notwin.test
2.87
KB
-rw-r--r--
connection_type_win.test
2.86
KB
-rw-r--r--
csv_table_io.test
791
B
-rw-r--r--
ddl_accounts.test
487
B
-rw-r--r--
ddl_cond_instances.test
514
B
-rw-r--r--
ddl_esgs_by_account_by_event_n...
621
B
-rw-r--r--
ddl_esgs_by_host_by_event_name...
609
B
-rw-r--r--
ddl_esgs_by_thread_by_event_na...
617
B
-rw-r--r--
ddl_esgs_by_user_by_event_name...
609
B
-rw-r--r--
ddl_esgs_global_by_event_name....
609
B
-rw-r--r--
ddl_esms_by_account_by_event_n...
637
B
-rw-r--r--
ddl_esms_by_digest.test
571
B
-rw-r--r--
ddl_esms_by_host_by_event_name...
625
B
-rw-r--r--
ddl_esms_by_program.test
760
B
-rw-r--r--
ddl_esms_by_thread_by_event_na...
633
B
-rw-r--r--
ddl_esms_by_user_by_event_name...
625
B
-rw-r--r--
ddl_esms_global_by_event_name....
625
B
-rw-r--r--
ddl_ets_by_account_by_event_na...
645
B
-rw-r--r--
ddl_ets_by_host_by_event_name....
633
B
-rw-r--r--
ddl_ets_by_thread_by_event_nam...
641
B
-rw-r--r--
ddl_ets_by_user_by_event_name....
633
B
-rw-r--r--
ddl_ets_global_by_event_name.t...
633
B
-rw-r--r--
ddl_events_stages_current.test
798
B
-rw-r--r--
ddl_events_stages_history.test
797
B
-rw-r--r--
ddl_events_stages_history_long...
822
B
-rw-r--r--
ddl_events_statements_current....
531
B
-rw-r--r--
ddl_events_statements_history....
531
B
-rw-r--r--
ddl_events_statements_history_...
551
B
-rw-r--r--
ddl_events_transactions_curren...
539
B
-rw-r--r--
ddl_events_transactions_histor...
539
B
-rw-r--r--
ddl_events_transactions_histor...
559
B
-rw-r--r--
ddl_events_waits_current.test
511
B
-rw-r--r--
ddl_events_waits_history.test
511
B
-rw-r--r--
ddl_events_waits_history_long....
531
B
-rw-r--r--
ddl_ews_by_account_by_event_na...
617
B
-rw-r--r--
ddl_ews_by_host_by_event_name....
605
B
-rw-r--r--
ddl_ews_by_instance.test
563
B
-rw-r--r--
ddl_ews_by_thread_by_event_nam...
613
B
-rw-r--r--
ddl_ews_by_user_by_event_name....
605
B
-rw-r--r--
ddl_ews_global_by_event_name.t...
605
B
-rw-r--r--
ddl_file_instances.test
524
B
-rw-r--r--
ddl_fs_by_event_name.test
527
B
-rw-r--r--
ddl_fs_by_instance.test
519
B
-rw-r--r--
ddl_global_status.test
499
B
-rw-r--r--
ddl_global_variables.test
546
B
-rw-r--r--
ddl_host_cache.test
459
B
-rw-r--r--
ddl_hosts.test
475
B
-rw-r--r--
ddl_mems_by_account_by_event_n...
593
B
-rw-r--r--
ddl_mems_by_host_by_event_name...
581
B
-rw-r--r--
ddl_mems_by_thread_by_event_na...
589
B
-rw-r--r--
ddl_mems_by_user_by_event_name...
581
B
-rw-r--r--
ddl_mems_global_by_event_name....
577
B
-rw-r--r--
ddl_metadata_locks.test
526
B
-rw-r--r--
ddl_mutex_instances.test
518
B
-rw-r--r--
ddl_os_global_by_type.test
563
B
-rw-r--r--
ddl_performance_timers.test
542
B
-rw-r--r--
ddl_prepared_statements_instan...
744
B
-rw-r--r--
ddl_processlist.test
880
B
-rw-r--r--
ddl_replication_applier_config...
740
B
-rw-r--r--
ddl_replication_applier_status...
708
B
-rw-r--r--
ddl_replication_applier_status...
771
B
-rw-r--r--
ddl_replication_applier_status...
747
B
-rw-r--r--
ddl_replication_connection_con...
737
B
-rw-r--r--
ddl_replication_connection_sta...
712
B
-rw-r--r--
ddl_replication_group_member_s...
712
B
-rw-r--r--
ddl_replication_group_members....
688
B
-rw-r--r--
ddl_rwlock_instances.test
522
B
-rw-r--r--
ddl_session_account_connect_at...
553
B
-rw-r--r--
ddl_session_connect_attrs.test
521
B
-rw-r--r--
ddl_session_status.test
538
B
-rw-r--r--
ddl_session_variables.test
550
B
-rw-r--r--
ddl_setup_actors.test
898
B
-rw-r--r--
ddl_setup_consumers.test
518
B
-rw-r--r--
ddl_setup_instruments.test
526
B
-rw-r--r--
ddl_setup_objects.test
823
B
-rw-r--r--
ddl_setup_timers.test
506
B
-rw-r--r--
ddl_socket_instances.test
532
B
-rw-r--r--
ddl_socket_summary_by_event_na...
537
B
-rw-r--r--
ddl_socket_summary_by_instance...
537
B
-rw-r--r--
ddl_status_by_account.test
515
B
-rw-r--r--
ddl_status_by_host.test
503
B
-rw-r--r--
ddl_status_by_thread.test
511
B
-rw-r--r--
ddl_status_by_user.test
503
B
-rw-r--r--
ddl_table_handles.test
522
B
-rw-r--r--
ddl_threads.test
506
B
-rw-r--r--
ddl_tiws_by_index_usage.test
585
B
-rw-r--r--
ddl_tiws_by_table.test
561
B
-rw-r--r--
ddl_tlws_by_table.test
569
B
-rw-r--r--
ddl_users.test
475
B
-rw-r--r--
ddl_uvar_by_thread.test
578
B
-rw-r--r--
ddl_variables_by_thread.test
558
B
-rw-r--r--
digest_null_literal.test
872
B
-rw-r--r--
digest_table_full-master.opt
42
B
-rw-r--r--
digest_table_full.test
1.01
KB
-rw-r--r--
digest_view.test
1.88
KB
-rw-r--r--
disabled.def
505
B
-rw-r--r--
dml_accounts.test
1.01
KB
-rw-r--r--
dml_cond_instances.test
901
B
-rw-r--r--
dml_esgs_by_account_by_event_n...
1.41
KB
-rw-r--r--
dml_esgs_by_host_by_event_name...
1.38
KB
-rw-r--r--
dml_esgs_by_thread_by_event_na...
1.39
KB
-rw-r--r--
dml_esgs_by_user_by_event_name...
1.38
KB
-rw-r--r--
dml_esgs_global_by_event_name....
1.35
KB
-rw-r--r--
dml_esms_by_account_by_event_n...
1.45
KB
-rw-r--r--
dml_esms_by_digest.test
1.29
KB
-rw-r--r--
dml_esms_by_host_by_event_name...
1.42
KB
-rw-r--r--
dml_esms_by_program.test
1.49
KB
-rw-r--r--
dml_esms_by_thread_by_event_na...
1.43
KB
-rw-r--r--
dml_esms_by_user_by_event_name...
1.42
KB
-rw-r--r--
dml_esms_global_by_event_name....
1.39
KB
-rw-r--r--
dml_ets_by_account_by_event_na...
1.47
KB
-rw-r--r--
dml_ets_by_host_by_event_name....
1.43
KB
-rw-r--r--
dml_ets_by_thread_by_event_nam...
1.45
KB
-rw-r--r--
dml_ets_by_user_by_event_name....
1.43
KB
-rw-r--r--
dml_ets_global_by_event_name.t...
1.41
KB
-rw-r--r--
dml_events_stages_current.test
1.14
KB
-rw-r--r--
dml_events_stages_history.test
1.38
KB
-rw-r--r--
dml_events_stages_history_long...
1.43
KB
-rw-r--r--
dml_events_statements_current....
1.18
KB
-rw-r--r--
dml_events_statements_history....
1.43
KB
-rw-r--r--
dml_events_statements_history_...
1.49
KB
-rw-r--r--
dml_events_transactions_curren...
1.2
KB
-rw-r--r--
dml_events_transactions_histor...
1.46
KB
-rw-r--r--
dml_events_transactions_histor...
1.51
KB
-rw-r--r--
dml_events_waits_current.test
1.14
KB
-rw-r--r--
dml_events_waits_history.test
1.38
KB
-rw-r--r--
dml_events_waits_history_long....
1.44
KB
-rw-r--r--
dml_ews_by_account_by_event_na...
1.42
KB
-rw-r--r--
dml_ews_by_host_by_event_name....
1.38
KB
-rw-r--r--
dml_ews_by_instance.test
1.74
KB
-rw-r--r--
dml_ews_by_thread_by_event_nam...
1.39
KB
-rw-r--r--
dml_ews_by_user_by_event_name....
1.38
KB
-rw-r--r--
dml_ews_global_by_event_name.t...
1.35
KB
-rw-r--r--
dml_file_instances.test
3
KB
-rw-r--r--
dml_fs_by_event_name.test
1.21
KB
-rw-r--r--
dml_fs_by_instance.test
1.2
KB
-rw-r--r--
dml_global_status.test
979
B
-rw-r--r--
dml_global_variables.test
1007
B
-rw-r--r--
dml_handler.test
1.29
KB
-rw-r--r--
dml_host_cache.test
1.08
KB
-rw-r--r--
dml_hosts.test
985
B
-rw-r--r--
dml_mems_by_account_by_event_n...
1.37
KB
-rw-r--r--
dml_mems_by_host_by_event_name...
1.34
KB
-rw-r--r--
dml_mems_by_thread_by_event_na...
1.36
KB
-rw-r--r--
dml_mems_by_user_by_event_name...
1.34
KB
-rw-r--r--
dml_mems_global_by_event_name....
1.32
KB
-rw-r--r--
dml_metadata_locks.test
932
B
-rw-r--r--
dml_mutex_instances.test
909
B
-rw-r--r--
dml_os_global_by_type.test
1.98
KB
-rw-r--r--
dml_performance_timers.test
1.06
KB
-rw-r--r--
dml_prepared_statements_instan...
1.47
KB
-rw-r--r--
dml_processlist.test
1.07
KB
-rw-r--r--
dml_replication_applier_config...
1.16
KB
-rw-r--r--
dml_replication_applier_status...
1.27
KB
-rw-r--r--
dml_replication_applier_status...
1.48
KB
-rw-r--r--
dml_replication_applier_status...
1.42
KB
-rw-r--r--
dml_replication_connection_con...
1.39
KB
-rw-r--r--
dml_replication_connection_sta...
1.38
KB
-rw-r--r--
dml_replication_group_member_s...
1.19
KB
-rw-r--r--
dml_replication_group_members....
1.18
KB
-rw-r--r--
dml_rwlock_instances.test
917
B
-rw-r--r--
dml_session_account_connect_at...
1.17
KB
-rw-r--r--
dml_session_connect_attrs.test
1.1
KB
-rw-r--r--
dml_session_status.test
987
B
-rw-r--r--
dml_session_variables.test
1011
B
-rw-r--r--
dml_setup_actors.test
3.33
KB
-rw-r--r--
dml_setup_consumers.test
1008
B
-rw-r--r--
dml_setup_instruments.test
2.93
KB
-rw-r--r--
dml_setup_objects.test
2.65
KB
-rw-r--r--
dml_setup_timers.test
1.97
KB
-rw-r--r--
dml_socket_instances.test
918
B
-rw-r--r--
dml_socket_summary_by_event_na...
1.2
KB
-rw-r--r--
dml_socket_summary_by_instance...
1.21
KB
-rw-r--r--
dml_status_by_account.test
1.13
KB
-rw-r--r--
dml_status_by_host.test
1.09
KB
-rw-r--r--
dml_status_by_thread.test
1.1
KB
-rw-r--r--
dml_status_by_user.test
1.09
KB
-rw-r--r--
dml_table_handles.test
922
B
-rw-r--r--
dml_threads.test
1.27
KB
-rw-r--r--
dml_tiws_by_index_usage.test
1.32
KB
-rw-r--r--
dml_tiws_by_table.test
1.27
KB
-rw-r--r--
dml_tlws_by_table.test
1.29
KB
-rw-r--r--
dml_users.test
985
B
-rw-r--r--
dml_uvar_by_thread.test
1.35
KB
-rw-r--r--
dml_variables_by_thread.test
1.13
KB
-rw-r--r--
event_aggregate-master.opt
32
B
-rw-r--r--
event_aggregate.test
280
B
-rw-r--r--
event_aggregate_no_a-master.op...
75
B
-rw-r--r--
event_aggregate_no_a.test
281
B
-rw-r--r--
event_aggregate_no_a_no_h-mast...
115
B
-rw-r--r--
event_aggregate_no_a_no_h.test
281
B
-rw-r--r--
event_aggregate_no_a_no_u-mast...
115
B
-rw-r--r--
event_aggregate_no_a_no_u.test
281
B
-rw-r--r--
event_aggregate_no_a_no_u_no_h...
155
B
-rw-r--r--
event_aggregate_no_a_no_u_no_h...
281
B
-rw-r--r--
event_aggregate_no_h-master.op...
72
B
-rw-r--r--
event_aggregate_no_h.test
281
B
-rw-r--r--
event_aggregate_no_u-master.op...
72
B
-rw-r--r--
event_aggregate_no_u.test
281
B
-rw-r--r--
event_aggregate_no_u_no_h-mast...
112
B
-rw-r--r--
event_aggregate_no_u_no_h.test
281
B
-rw-r--r--
file_misc-master.opt
48
B
-rw-r--r--
file_misc.test
258
B
-rw-r--r--
func_file_io.test
5.69
KB
-rw-r--r--
func_mutex.test
4.47
KB
-rw-r--r--
global_objects-master.opt
46
B
-rw-r--r--
global_objects.test
1.13
KB
-rw-r--r--
global_read_lock.test
2.33
KB
-rw-r--r--
hostcache_ipv4_addrinfo_again_...
1.41
KB
-rw-r--r--
hostcache_ipv4_addrinfo_again_...
1.17
KB
-rw-r--r--
hostcache_ipv4_addrinfo_bad_al...
1.53
KB
-rw-r--r--
hostcache_ipv4_addrinfo_bad_de...
1.29
KB
-rw-r--r--
hostcache_ipv4_addrinfo_good_a...
1.46
KB
-rw-r--r--
hostcache_ipv4_addrinfo_good_d...
1.16
KB
-rw-r--r--
hostcache_ipv4_addrinfo_noname...
1.58
KB
-rw-r--r--
hostcache_ipv4_addrinfo_noname...
1.16
KB
-rw-r--r--
hostcache_ipv4_auth_plugin-mas...
35
B
-rw-r--r--
hostcache_ipv4_auth_plugin.tes...
2.57
KB
-rw-r--r--
hostcache_ipv4_blocked.test
4.08
KB
-rw-r--r--
hostcache_ipv4_format.test
1.07
KB
-rw-r--r--
hostcache_ipv4_max_con.test
6.37
KB
-rw-r--r--
hostcache_ipv4_nameinfo_again_...
1.98
KB
-rw-r--r--
hostcache_ipv4_nameinfo_again_...
1.58
KB
-rw-r--r--
hostcache_ipv4_nameinfo_noname...
1.35
KB
-rw-r--r--
hostcache_ipv4_nameinfo_noname...
1.11
KB
-rw-r--r--
hostcache_ipv4_passwd.test
2.28
KB
-rw-r--r--
hostcache_ipv4_ssl.test
1.9
KB
-rw-r--r--
hostcache_ipv6_addrinfo_again_...
18
B
-rw-r--r--
hostcache_ipv6_addrinfo_again_...
1.44
KB
-rw-r--r--
hostcache_ipv6_addrinfo_again_...
18
B
-rw-r--r--
hostcache_ipv6_addrinfo_again_...
1.19
KB
-rw-r--r--
hostcache_ipv6_addrinfo_bad_al...
18
B
-rw-r--r--
hostcache_ipv6_addrinfo_bad_al...
1.56
KB
-rw-r--r--
hostcache_ipv6_addrinfo_bad_de...
18
B
-rw-r--r--
hostcache_ipv6_addrinfo_bad_de...
1.31
KB
-rw-r--r--
hostcache_ipv6_addrinfo_good_a...
18
B
-rw-r--r--
hostcache_ipv6_addrinfo_good_a...
1.47
KB
-rw-r--r--
hostcache_ipv6_addrinfo_good_d...
18
B
-rw-r--r--
hostcache_ipv6_addrinfo_good_d...
1.05
KB
-rw-r--r--
hostcache_ipv6_addrinfo_noname...
18
B
-rw-r--r--
hostcache_ipv6_addrinfo_noname...
1.61
KB
-rw-r--r--
hostcache_ipv6_addrinfo_noname...
18
B
-rw-r--r--
hostcache_ipv6_addrinfo_noname...
1.18
KB
-rw-r--r--
hostcache_ipv6_auth_plugin-mas...
53
B
-rw-r--r--
hostcache_ipv6_auth_plugin.tes...
2.57
KB
-rw-r--r--
hostcache_ipv6_blocked-master....
18
B
-rw-r--r--
hostcache_ipv6_blocked.test
4.03
KB
-rw-r--r--
hostcache_ipv6_max_con-master....
18
B
-rw-r--r--
hostcache_ipv6_max_con.test
5.42
KB
-rw-r--r--
hostcache_ipv6_nameinfo_again_...
18
B
-rw-r--r--
hostcache_ipv6_nameinfo_again_...
2
KB
-rw-r--r--
hostcache_ipv6_nameinfo_again_...
18
B
-rw-r--r--
hostcache_ipv6_nameinfo_again_...
1.58
KB
-rw-r--r--
hostcache_ipv6_nameinfo_noname...
18
B
-rw-r--r--
hostcache_ipv6_nameinfo_noname...
1.38
KB
-rw-r--r--
hostcache_ipv6_nameinfo_noname...
18
B
-rw-r--r--
hostcache_ipv6_nameinfo_noname...
1.13
KB
-rw-r--r--
hostcache_ipv6_passwd-master.o...
18
B
-rw-r--r--
hostcache_ipv6_passwd.test
2.19
KB
-rw-r--r--
hostcache_ipv6_ssl-master.opt
18
B
-rw-r--r--
hostcache_ipv6_ssl.test
1.91
KB
-rw-r--r--
hostcache_peer_addr-master.opt
16
B
-rw-r--r--
hostcache_peer_addr.test
1.12
KB
-rw-r--r--
indexed_table_io.test
4.15
KB
-rw-r--r--
information_schema.test
2.12
KB
-rw-r--r--
innodb_table_io.test
794
B
-rw-r--r--
io_cache-master.opt
76
B
-rw-r--r--
io_cache.test
9.63
KB
-rw-r--r--
max_program_zero-master.opt
122
B
-rw-r--r--
max_program_zero.test
1.57
KB
-rw-r--r--
mdl_func.test
10.41
KB
-rw-r--r--
memory_aggregate-master.opt
37
B
-rw-r--r--
memory_aggregate.test
212
B
-rw-r--r--
memory_aggregate_32bit-master....
37
B
-rw-r--r--
memory_aggregate_32bit.test
212
B
-rw-r--r--
memory_aggregate_no_a-master.o...
80
B
-rw-r--r--
memory_aggregate_no_a.test
212
B
-rw-r--r--
memory_aggregate_no_a_no_h-mas...
120
B
-rw-r--r--
memory_aggregate_no_a_no_h.tes...
212
B
-rw-r--r--
memory_aggregate_no_a_no_u-mas...
120
B
-rw-r--r--
memory_aggregate_no_a_no_u.tes...
212
B
-rw-r--r--
memory_aggregate_no_a_no_u_no_...
160
B
-rw-r--r--
memory_aggregate_no_a_no_u_no_...
212
B
-rw-r--r--
memory_aggregate_no_h-master.o...
77
B
-rw-r--r--
memory_aggregate_no_h.test
212
B
-rw-r--r--
memory_aggregate_no_u-master.o...
77
B
-rw-r--r--
memory_aggregate_no_u.test
212
B
-rw-r--r--
memory_aggregate_no_u_no_h-mas...
117
B
-rw-r--r--
memory_aggregate_no_u_no_h.tes...
212
B
-rw-r--r--
memory_table_io.test
794
B
-rw-r--r--
merge_table_io.test
1.44
KB
-rw-r--r--
misc.test
7.99
KB
-rw-r--r--
misc_global_status-master.opt
40
B
-rw-r--r--
misc_global_status.test
4.32
KB
-rw-r--r--
multi_table_io.test
1.52
KB
-rw-r--r--
myisam_file_io.opt
57
B
-rw-r--r--
myisam_file_io.test
1.88
KB
-rw-r--r--
myisam_table_io.test
794
B
-rw-r--r--
nesting.test
6.29
KB
-rw-r--r--
no_threads-master.opt
148
B
-rw-r--r--
no_threads.test
1.89
KB
-rw-r--r--
one_thread_per_con-master.opt
44
B
-rw-r--r--
one_thread_per_con.test
1.71
KB
-rw-r--r--
ortho_iter.test
9.96
KB
-rw-r--r--
part_table_io.test
864
B
-rw-r--r--
pfs_upgrade_event-master.opt
37
B
-rw-r--r--
pfs_upgrade_event.test
987
B
-rw-r--r--
pfs_upgrade_func-master.opt
37
B
-rw-r--r--
pfs_upgrade_func.test
955
B
-rw-r--r--
pfs_upgrade_proc-master.opt
37
B
-rw-r--r--
pfs_upgrade_proc.test
967
B
-rw-r--r--
pfs_upgrade_table-master.opt
37
B
-rw-r--r--
pfs_upgrade_table.test
1.12
KB
-rw-r--r--
pfs_upgrade_view-master.opt
37
B
-rw-r--r--
pfs_upgrade_view.test
1.13
KB
-rw-r--r--
prepared_statements.test
4.48
KB
-rw-r--r--
prepared_stmts_by_stored_progr...
3.25
KB
-rw-r--r--
privilege.test
11.88
KB
-rw-r--r--
privilege_table_io.test
1.65
KB
-rw-r--r--
processlist-master.opt
18
B
-rw-r--r--
processlist.test
5.06
KB
-rw-r--r--
processlist_57.test
8.49
KB
-rw-r--r--
processlist_acl-master.opt
18
B
-rw-r--r--
processlist_acl.test
5.14
KB
-rw-r--r--
processlist_anonymous.test
2.38
KB
-rw-r--r--
processlist_no_pfs-master.opt
82
B
-rw-r--r--
processlist_no_pfs.test
732
B
-rw-r--r--
processlist_port-master.opt
18
B
-rw-r--r--
processlist_port.test
4.47
KB
-rw-r--r--
processlist_reg_user.test
3.13
KB
-rw-r--r--
query_cache-master.opt
21
B
-rw-r--r--
query_cache.test
1.57
KB
-rw-r--r--
read_only.test
5.88
KB
-rw-r--r--
relaylog-slave.opt
16
B
-rw-r--r--
relaylog.test
6.47
KB
-rw-r--r--
rollback_table_io.test
1.13
KB
-rw-r--r--
rpl_group_member_stats.test
2.76
KB
-rw-r--r--
rpl_group_members.test
1.62
KB
-rw-r--r--
rpl_gtid_func.test
2.39
KB
-rw-r--r--
rpl_statements-master.opt
22
B
-rw-r--r--
rpl_statements-slave.opt
22
B
-rw-r--r--
rpl_statements.test
8.79
KB
-rw-r--r--
rpl_threads-slave.opt
16
B
-rw-r--r--
rpl_threads.test
2.25
KB
-rw-r--r--
schema.test
200
B
-rw-r--r--
selects-master.opt
18
B
-rw-r--r--
selects.test
4.53
KB
-rw-r--r--
server_init.test
5.1
KB
-rw-r--r--
setup_actors.test
9.05
KB
-rw-r--r--
setup_actors_enabled.test
6.71
KB
-rw-r--r--
setup_actors_history.test
5.41
KB
-rw-r--r--
setup_consumers_defaults-maste...
913
B
-rw-r--r--
setup_consumers_defaults.test
493
B
-rw-r--r--
setup_instruments_defaults-mas...
1.79
KB
-rw-r--r--
setup_instruments_defaults.tes...
2.9
KB
-rw-r--r--
setup_object_table_lock_io.tes...
4.05
KB
-rw-r--r--
setup_objects.test
5.52
KB
-rw-r--r--
short_option_1-master.opt
50
B
-rw-r--r--
short_option_1.test
466
B
-rw-r--r--
short_option_2-master.opt
5
B
-rw-r--r--
short_option_2.test
458
B
-rw-r--r--
show_aggregate-master.opt
16
B
-rw-r--r--
show_aggregate.test
12.92
KB
-rw-r--r--
show_coverage.test
7.05
KB
-rw-r--r--
show_misc.test
3.38
KB
-rw-r--r--
show_plugin-master.opt
22
B
-rw-r--r--
show_plugin.test
17.86
KB
-rw-r--r--
show_plugin_56-master.opt
22
B
-rw-r--r--
show_plugin_56.test
16.74
KB
-rw-r--r--
show_sanity.test
101.52
KB
-rw-r--r--
socket_connect.test
8.91
KB
-rw-r--r--
socket_instances_func-master.o...
20
B
-rw-r--r--
socket_instances_func.test
12.2
KB
-rw-r--r--
socket_instances_func_win-mast...
20
B
-rw-r--r--
socket_instances_func_win.test
8.92
KB
-rw-r--r--
socket_summary_by_event_name_f...
11.98
KB
-rw-r--r--
socket_summary_by_instance_fun...
62.74
KB
-rw-r--r--
socket_summary_by_instance_fun...
62.89
KB
-rw-r--r--
stage_mdl_function.test
1.37
KB
-rw-r--r--
stage_mdl_global-master.opt
21
B
-rw-r--r--
stage_mdl_global.test
1.24
KB
-rw-r--r--
stage_mdl_procedure.test
1.63
KB
-rw-r--r--
stage_mdl_table.test
1.3
KB
-rw-r--r--
start_server_1_digest-master.o...
36
B
-rw-r--r--
start_server_1_digest.test
484
B
-rw-r--r--
start_server_disable_idle-mast...
49
B
-rw-r--r--
start_server_disable_idle.test
965
B
-rw-r--r--
start_server_disable_stages-ma...
52
B
-rw-r--r--
start_server_disable_stages.te...
841
B
-rw-r--r--
start_server_disable_statement...
56
B
-rw-r--r--
start_server_disable_statement...
873
B
-rw-r--r--
start_server_disable_transacti...
56
B
-rw-r--r--
start_server_disable_transacti...
883
B
-rw-r--r--
start_server_disable_waits-mas...
51
B
-rw-r--r--
start_server_disable_waits.tes...
978
B
-rw-r--r--
start_server_innodb-master.opt
34
B
-rw-r--r--
start_server_innodb.test
279
B
-rw-r--r--
start_server_low_digest-master...
23
B
-rw-r--r--
start_server_low_digest.test
996
B
-rw-r--r--
start_server_low_digest_sql_le...
95
B
-rw-r--r--
start_server_low_digest_sql_le...
1.02
KB
-rw-r--r--
start_server_low_index-master....
79
B
-rw-r--r--
start_server_low_index.test
6.03
KB
-rw-r--r--
start_server_low_table_lock-ma...
83
B
-rw-r--r--
start_server_low_table_lock.te...
4.02
KB
-rw-r--r--
start_server_no_account-master...
77
B
-rw-r--r--
start_server_no_account.test
472
B
-rw-r--r--
start_server_no_cond_class-mas...
80
B
-rw-r--r--
start_server_no_cond_class.tes...
702
B
-rw-r--r--
start_server_no_cond_inst-mast...
82
B
-rw-r--r--
start_server_no_cond_inst.test
767
B
-rw-r--r--
start_server_no_digests-master...
42
B
-rw-r--r--
start_server_no_digests.test
1.01
KB
-rw-r--r--
start_server_no_file_class-mas...
80
B
-rw-r--r--
start_server_no_file_class.tes...
699
B
-rw-r--r--
start_server_no_file_inst-mast...
82
B
-rw-r--r--
start_server_no_file_inst.test
764
B
-rw-r--r--
start_server_no_host-master.op...
74
B
-rw-r--r--
start_server_no_host.test
463
B
-rw-r--r--
start_server_no_index-master.o...
78
B
-rw-r--r--
start_server_no_index.test
2.07
KB
-rw-r--r--
start_server_no_mdl-master.opt
82
B
-rw-r--r--
start_server_no_mdl.test
649
B
-rw-r--r--
start_server_no_memory_class-m...
82
B
-rw-r--r--
start_server_no_memory_class.t...
755
B
-rw-r--r--
start_server_no_mutex_class-ma...
81
B
-rw-r--r--
start_server_no_mutex_class.te...
707
B
-rw-r--r--
start_server_no_mutex_inst-mas...
83
B
-rw-r--r--
start_server_no_mutex_inst.tes...
773
B
-rw-r--r--
start_server_no_prepared_stmts...
97
B
-rw-r--r--
start_server_no_prepared_stmts...
1.15
KB
-rw-r--r--
start_server_no_rwlock_class-m...
82
B
-rw-r--r--
start_server_no_rwlock_class.t...
712
B
-rw-r--r--
start_server_no_rwlock_inst-ma...
84
B
-rw-r--r--
start_server_no_rwlock_inst.te...
779
B
-rw-r--r--
start_server_no_setup_actors-m...
81
B
-rw-r--r--
start_server_no_setup_actors.t...
322
B
-rw-r--r--
start_server_no_setup_objects-...
82
B
-rw-r--r--
start_server_no_setup_objects....
326
B
-rw-r--r--
start_server_no_socket_class-m...
82
B
-rw-r--r--
start_server_no_socket_class.t...
709
B
-rw-r--r--
start_server_no_socket_inst-ma...
84
B
-rw-r--r--
start_server_no_socket_inst.te...
776
B
-rw-r--r--
start_server_no_stage_class-ma...
81
B
-rw-r--r--
start_server_no_stage_class.te...
934
B
-rw-r--r--
start_server_no_stages_history...
90
B
-rw-r--r--
start_server_no_stages_history...
396
B
-rw-r--r--
start_server_no_stages_history...
95
B
-rw-r--r--
start_server_no_stages_history...
416
B
-rw-r--r--
start_server_no_statement_clas...
85
B
-rw-r--r--
start_server_no_statement_clas...
974
B
-rw-r--r--
start_server_no_statements_his...
94
B
-rw-r--r--
start_server_no_statements_his...
408
B
-rw-r--r--
start_server_no_statements_his...
99
B
-rw-r--r--
start_server_no_statements_his...
428
B
-rw-r--r--
start_server_no_table_hdl-mast...
81
B
-rw-r--r--
start_server_no_table_hdl.test
888
B
-rw-r--r--
start_server_no_table_inst-mas...
176
B
-rw-r--r--
start_server_no_table_inst.tes...
885
B
-rw-r--r--
start_server_no_table_lock-mas...
83
B
-rw-r--r--
start_server_no_table_lock.tes...
1.65
KB
-rw-r--r--
start_server_no_thread_class-m...
82
B
-rw-r--r--
start_server_no_thread_class.t...
692
B
-rw-r--r--
start_server_no_thread_inst-ma...
84
B
-rw-r--r--
start_server_no_thread_inst.te...
784
B
-rw-r--r--
start_server_no_transactions_h...
96
B
-rw-r--r--
start_server_no_transactions_h...
414
B
-rw-r--r--
start_server_no_transactions_h...
101
B
-rw-r--r--
start_server_no_transactions_h...
434
B
-rw-r--r--
start_server_no_user-master.op...
74
B
-rw-r--r--
start_server_no_user.test
463
B
-rw-r--r--
start_server_no_waits_history-...
89
B
-rw-r--r--
start_server_no_waits_history....
393
B
-rw-r--r--
start_server_no_waits_history_...
94
B
-rw-r--r--
start_server_no_waits_history_...
413
B
-rw-r--r--
start_server_nothing-master.op...
1.78
KB
-rw-r--r--
start_server_nothing.test
3.21
KB
-rw-r--r--
start_server_off-master.opt
35
B
-rw-r--r--
start_server_off.test
2.18
KB
-rw-r--r--
start_server_on-master.opt
34
B
-rw-r--r--
start_server_on.test
246
B
-rw-r--r--
start_server_zero_digest_sql_l...
93
B
-rw-r--r--
start_server_zero_digest_sql_l...
971
B
-rw-r--r--
statement_digest.test
887
B
-rw-r--r--
statement_digest_charset.test
995
B
-rw-r--r--
statement_digest_consumers-mas...
120
B
-rw-r--r--
statement_digest_consumers.tes...
1.21
KB
-rw-r--r--
statement_digest_consumers2-ma...
120
B
-rw-r--r--
statement_digest_consumers2.te...
1.3
KB
-rw-r--r--
statement_digest_long_query-ma...
22
B
-rw-r--r--
statement_digest_long_query.te...
2.46
KB
-rw-r--r--
statement_program_concurrency-...
51
B
-rw-r--r--
statement_program_concurrency....
2.83
KB
-rw-r--r--
statement_program_lost_inst-ma...
122
B
-rw-r--r--
statement_program_lost_inst.te...
2.76
KB
-rw-r--r--
statement_program_nested-maste...
22
B
-rw-r--r--
statement_program_nested.test
2.99
KB
-rw-r--r--
statement_program_nesting_even...
22
B
-rw-r--r--
statement_program_nesting_even...
1.71
KB
-rw-r--r--
statement_program_non_nested-m...
22
B
-rw-r--r--
statement_program_non_nested.t...
4.73
KB
-rw-r--r--
status_reprepare.test
1.99
KB
-rw-r--r--
sxlock_func.test
2.48
KB
-rw-r--r--
table_aggregate_global_2u_2t.t...
495
B
-rw-r--r--
table_aggregate_global_2u_3t.t...
435
B
-rw-r--r--
table_aggregate_global_4u_2t.t...
426
B
-rw-r--r--
table_aggregate_global_4u_3t.t...
366
B
-rw-r--r--
table_aggregate_hist_2u_2t.tes...
406
B
-rw-r--r--
table_aggregate_hist_2u_3t.tes...
346
B
-rw-r--r--
table_aggregate_hist_4u_2t.tes...
337
B
-rw-r--r--
table_aggregate_hist_4u_3t.tes...
277
B
-rw-r--r--
table_aggregate_off.test
320
B
-rw-r--r--
table_aggregate_thread_2u_2t.t...
484
B
-rw-r--r--
table_aggregate_thread_2u_3t.t...
424
B
-rw-r--r--
table_aggregate_thread_4u_2t.t...
415
B
-rw-r--r--
table_aggregate_thread_4u_3t.t...
355
B
-rw-r--r--
table_io_aggregate_global_2u_2...
574
B
-rw-r--r--
table_io_aggregate_global_2u_3...
514
B
-rw-r--r--
table_io_aggregate_global_4u_2...
505
B
-rw-r--r--
table_io_aggregate_global_4u_3...
445
B
-rw-r--r--
table_io_aggregate_hist_2u_2t....
485
B
-rw-r--r--
table_io_aggregate_hist_2u_3t....
425
B
-rw-r--r--
table_io_aggregate_hist_4u_2t....
416
B
-rw-r--r--
table_io_aggregate_hist_4u_3t....
356
B
-rw-r--r--
table_io_aggregate_thread_2u_2...
563
B
-rw-r--r--
table_io_aggregate_thread_2u_3...
503
B
-rw-r--r--
table_io_aggregate_thread_4u_2...
494
B
-rw-r--r--
table_io_aggregate_thread_4u_3...
434
B
-rw-r--r--
table_lock_aggregate_global_2u...
674
B
-rw-r--r--
table_lock_aggregate_global_2u...
614
B
-rw-r--r--
table_lock_aggregate_global_4u...
605
B
-rw-r--r--
table_lock_aggregate_global_4u...
545
B
-rw-r--r--
table_lock_aggregate_hist_2u_2...
585
B
-rw-r--r--
table_lock_aggregate_hist_2u_3...
525
B
-rw-r--r--
table_lock_aggregate_hist_4u_2...
516
B
-rw-r--r--
table_lock_aggregate_hist_4u_3...
456
B
-rw-r--r--
table_lock_aggregate_thread_2u...
663
B
-rw-r--r--
table_lock_aggregate_thread_2u...
603
B
-rw-r--r--
table_lock_aggregate_thread_4u...
594
B
-rw-r--r--
table_lock_aggregate_thread_4u...
534
B
-rw-r--r--
table_name.test
5.45
KB
-rw-r--r--
table_schema.test
2.05
KB
-rw-r--r--
tampered_perfschema_table1-mas...
44
B
-rw-r--r--
tampered_perfschema_table1.tes...
776
B
-rw-r--r--
temp_table_io.test
826
B
-rw-r--r--
thread_cache-master.opt
48
B
-rw-r--r--
thread_cache.test
4.43
KB
-rw-r--r--
thread_misc-master.opt
61
B
-rw-r--r--
thread_misc.test
263
B
-rw-r--r--
threads_history.test
26.93
KB
-rw-r--r--
threads_innodb.test
898
B
-rw-r--r--
threads_mysql-master.opt
40
B
-rw-r--r--
threads_mysql.test
4.56
KB
-rw-r--r--
threads_mysql_freebsd.test
723
B
-rw-r--r--
threads_mysql_linux.test
719
B
-rw-r--r--
threads_mysql_windows.test
723
B
-rw-r--r--
transaction-master.opt
84
B
-rw-r--r--
transaction.test
25.95
KB
-rw-r--r--
transaction_gtid.test
6.1
KB
-rw-r--r--
transaction_nested_events-mast...
1.05
KB
-rw-r--r--
transaction_nested_events.test
10.58
KB
-rw-r--r--
trigger_table_io.test
1.92
KB
-rw-r--r--
unary_digest.test
3.32
KB
-rw-r--r--
user_var_func.test
2.47
KB
-rw-r--r--
view_table_io.test
1.25
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : show_aggregate.test
################# suite/perfschema/t/show_aggregate.test ####################### # # # This test verifies: # # 1. Status variable values are consistent with corresponding server events. # # 2. Status variable values are consistent across session, thread, account, # # host, user and global tables. # # 3. Status totals for user, host and account are retained after related # # threads disconnect. # ################################################################################ --source include/have_perfschema.inc --source include/not_embedded.inc --source include/no_protocol.inc --enable_connect_log --echo --echo ================================================================================ --echo SETUP --echo ================================================================================ --echo # Save current SHOW_COMPATIBILITY_56 setting SELECT @@global.show_compatibility_56 INTO @show_compatibility_56_save; SET @@global.show_compatibility_56=OFF; SET @@session.sql_log_bin=OFF; --echo --echo # CREATE 3 CLIENTS, 3 CONNECTIONS, RESULTS TABLE connection default; USE test; # Clear user, host and account status accumulated from preliminary checks by mtr. --disable_query_log flush status; --enable_query_log --echo --echo # Create results table CREATE TABLE test.status_results (variable_name VARCHAR(64), start INT DEFAULT 0, stop INT DEFAULT 0, delta INT DEFAULT 0, t1 INT DEFAULT 0, t2 INT DEFAULT 0, t3 INT DEFAULT 0, thread INT DEFAULT 0, u1 INT DEFAULT 0, u2 INT DEFAULT 0, u3 INT DEFAULT 0, user INT DEFAULT 0, h1 INT DEFAULT 0, h2 INT DEFAULT 0, h3 INT DEFAULT 0, host INT DEFAULT 0, a1 INT DEFAULT 0, a2 INT DEFAULT 0, a3 INT DEFAULT 0, acct INT DEFAULT 0); INSERT INTO test.status_results (variable_name, start) SELECT sg.variable_name, sg.variable_value+0 FROM performance_schema.global_status sg WHERE variable_name IN ('handler_delete', 'handler_rollback'); --echo --echo # Create test tables CREATE TABLE t1 (s1 int) ENGINE=InnoDB; INSERT INTO t1 VALUES (1), (2), (2), (3), (3), (3); CREATE TABLE t2 (s1 int) ENGINE=InnoDB; CREATE TABLE t3 (s1 int) ENGINE=InnoDB; --echo set @orig_sql_mode= @@sql_mode; set sql_mode= (select replace(@@sql_mode,'NO_AUTO_CREATE_USER','')); GRANT ALL ON *.* to 'user1'@localhost; GRANT ALL ON *.* to 'user2'@localhost; GRANT ALL ON *.* to 'user3'@localhost; set sql_mode= @orig_sql_mode; --echo --echo ================================================================================ --echo CONNECTION 1: DELETE 1, ROLLBACK x 1 --echo ================================================================================ connect(con1, localhost, user1,,); SET @@session.sql_log_bin=OFF; DELETE FROM t1 WHERE s1 = 1; START TRANSACTION; INSERT INTO t1 VALUES (1); ROLLBACK; --echo --echo ================================================================================ --echo CONNECTION 2: DELETE 2, ROLLBACK x 2 --echo ================================================================================ connect(con2, localhost, user2,,); SET @@session.sql_log_bin=OFF; DELETE FROM t1 WHERE s1 = 2; --echo START TRANSACTION; INSERT INTO t1 VALUES (2); ROLLBACK; --echo START TRANSACTION; INSERT INTO t1 VALUES (2); ROLLBACK; --echo --echo ================================================================================ --echo CONNECTION 3: DELETE 3, ROLLBACK x 3 --echo ================================================================================ connect(con3, localhost, user3,,); SET @@session.sql_log_bin=OFF; DELETE FROM t1 WHERE s1 = 3; --echo START TRANSACTION; INSERT INTO t1 VALUES (3); ROLLBACK; --echo START TRANSACTION; INSERT INTO t1 VALUES (3); ROLLBACK; --echo START TRANSACTION; INSERT INTO t1 VALUES (3); ROLLBACK; --echo --echo ================================================================================ --echo CONNECTION DEFAULT: Gather results, compare session and global status counts --echo ================================================================================ connection default; --echo # Get thread ids for each connection. USE performance_schema; SELECT thread_id INTO @con1_id FROM threads WHERE processlist_user IN ('user1'); SELECT thread_id INTO @con2_id FROM threads WHERE processlist_user IN ('user2'); SELECT thread_id INTO @con3_id FROM threads WHERE processlist_user IN ('user3'); --source ../include/show_aggregate.inc #--echo DEBUG #USE test; #SELECT * FROM test.status_results; --echo --echo ================================================================================ --echo TEST 1: STATUS_BY_THREAD: Verify expected status counts per thread (1,2,3) --echo ================================================================================ --echo # --echo # Review per-thread status counts --echo # USE performance_schema; --replace_column 1 thread_id SELECT * FROM status_by_thread WHERE thread_id IN (@con1_id, @con2_id, @con3_id) AND variable_name IN ('handler_delete', 'handler_rollback') ORDER BY thread_id; --echo # --echo # Verify expected counts for 'handler_delete' per thread --echo # --replace_column 1 connect_1 SELECT *, IF (variable_value = 1,'OK','ERROR') AS Expected FROM status_by_thread WHERE thread_id = @con1_id AND variable_name IN ('handler_delete'); --echo --replace_column 1 connnect_2 SELECT *, IF (variable_value = 2,'OK','ERROR') AS Expected FROM status_by_thread WHERE thread_id = @con2_id AND variable_name IN ('handler_delete'); --echo --replace_column 1 connnect_3 SELECT *, IF (variable_value = 3,'OK','ERROR') AS Expected FROM status_by_thread WHERE thread_id = @con3_id AND variable_name IN ('handler_delete'); --echo # --echo # STATUS_BY_THREAD vs. GLOBAL_STATUS --echo # SELECT variable_name, t1, t2, t3, delta, thread, IF(thread=delta,'OK','ERROR') Expected FROM test.status_results ORDER BY variable_name; --echo --echo ================================================================================ --echo TEST 2: STATUS_BY_USER: Verify expected status counts per user (1,2,3) --echo ================================================================================ SELECT *, IF (variable_value = 1,'OK','ERROR') AS Expected FROM status_by_user WHERE user IN ('user1') AND variable_name IN ('handler_delete'); --echo SELECT *, IF (variable_value = 2,'OK','ERROR') AS Expected FROM status_by_user WHERE user IN ('user2') AND variable_name IN ('handler_delete'); --echo SELECT *, IF (variable_value = 3,'OK','ERROR') AS Expected FROM status_by_user WHERE user IN ('user3') AND variable_name IN ('handler_delete'); --echo # --echo # STATUS_BY_USER vs. GLOBAL_STATUS --echo # SELECT variable_name, u1, u2, u3, delta, user, IF(user=delta,'OK','ERROR') Expected FROM test.status_results ORDER BY variable_name; --echo --echo ================================================================================ --echo TEST 3: STATUS_BY_ACCOUNT: Verify expected status counts per user, host (1,2,3) --echo ================================================================================ SELECT *, IF (variable_value = 1,'OK','ERROR') AS Expected FROM status_by_account WHERE user IN ('user1') AND variable_name IN ('handler_delete'); --echo SELECT *, IF (variable_value = 2,'OK','ERROR') AS Expected FROM status_by_account WHERE user IN ('user2') AND variable_name IN ('handler_delete'); --echo SELECT *, IF (variable_value = 3,'OK','ERROR') AS Expected FROM status_by_account WHERE user IN ('user3') AND variable_name IN ('handler_delete'); --echo # --echo # STATUS_BY_ACCOUNT vs. GLOBAL_STATUS --echo # SELECT variable_name, a1, a2, a3, delta, acct, IF(acct=delta,'OK','ERROR') Expected FROM test.status_results ORDER BY variable_name; --echo ================================================================================ --echo TEST 4: STATUS_BY_HOST: Verify expected status counts per host (6) --echo ================================================================================ SELECT *, IF (variable_value = 6,'OK','ERROR') AS Expected FROM status_by_host WHERE host IN ('localhost') AND variable_name IN ('handler_delete'); --echo # --echo # STATUS_BY_HOST vs. GLOBAL_STATUS --echo # --echo # Special case: No way to isolate pre-existing 'localhost' activity, so --echo # just check global totals = sum(status_by_host). --echo # SELECT variable_name, h1, h2, h3, delta, host, IF(host=delta,'OK','ERROR') Expected FROM test.status_results ORDER BY variable_name; --echo --echo ================================================================================ --echo DISCONNECT ALL USERS AND RUN THE TESTS AGAIN. RESULTS SHOULD NOT CHANGE. --echo ================================================================================ connection default; disconnect con1; disconnect con2; disconnect con3; --echo USE test; --echo --echo # Clear results table, leave initial global_status counts UPDATE test.status_results SET stop=0, delta=0, t1=0, t2=0, t3=0, thread=0, u1=0, u2=0, u3=0, user=0, h1=0, h2=0, h3=0, host=0, a1=0, a2=0, a3=0, acct=0; #--echo DEBUG #SELECT * FROM test.status_results; --echo --source ../include/show_aggregate.inc USE performance_schema; --echo --echo ================================================================================ --echo TEST X: STATUS_BY_THREAD: Connections are gone--nothing to verify. --echo ================================================================================ --echo --echo ================================================================================ --echo TEST 5: STATUS_BY_USER: Verify expected status counts per user (1,2,3) --echo ================================================================================ SELECT *, IF (variable_value = 1,'OK','ERROR') AS Expected FROM status_by_user WHERE user IN ('user1') AND variable_name IN ('handler_delete'); --echo SELECT *, IF (variable_value = 2,'OK','ERROR') AS Expected FROM status_by_user WHERE user IN ('user2') AND variable_name IN ('handler_delete'); --echo SELECT *, IF (variable_value = 3,'OK','ERROR') AS Expected FROM status_by_user WHERE user IN ('user3') AND variable_name IN ('handler_delete'); --echo # --echo # STATUS_BY_USER vs. GLOBAL_STATUS --echo # SELECT variable_name, u1, u2, u3, delta, user, IF(user=delta,'OK','ERROR') Expected FROM test.status_results ORDER BY variable_name; --echo --echo ================================================================================ --echo TEST 6: STATUS_BY_ACCOUNT: Verify expected status counts per user:host (1,2,3) --echo ================================================================================ SELECT *, IF (variable_value = 1,'OK','ERROR') AS Expected FROM status_by_account WHERE user IN ('user1') AND variable_name IN ('handler_delete'); --echo SELECT *, IF (variable_value = 2,'OK','ERROR') AS Expected FROM status_by_account WHERE user IN ('user2') AND variable_name IN ('handler_delete'); --echo SELECT *, IF (variable_value = 3,'OK','ERROR') AS Expected FROM status_by_account WHERE user IN ('user3') AND variable_name IN ('handler_delete'); --echo # --echo # STATUS_BY_ACCOUNT vs. GLOBAL_STATUS --echo # SELECT variable_name, a1, a2, a3, delta, acct, IF(acct=delta,'OK','ERROR') Expected FROM test.status_results ORDER BY variable_name; --echo ================================================================================ --echo TEST 7: STATUS_BY_HOST: Verify expected status counts per host (6) --echo ================================================================================ SELECT *, IF (variable_value = 6,'OK','ERROR') AS Expected FROM status_by_host WHERE host IN ('localhost') AND variable_name IN ('handler_delete'); --echo # --echo # STATUS_BY_HOST vs. GLOBAL_STATUS --echo # --echo # Special case: No way to isolate pre-existing 'localhost' activity, so --echo # just check global totals = sum(status_by_host). --echo # SELECT variable_name, h1, h2, h3, delta, host, IF(host=delta,'OK','ERROR') Expected FROM test.status_results ORDER BY variable_name; --echo ================================================================================ --echo TEST 8: FLUSH STATUS should clear account, host and user status --echo ================================================================================ --echo FLUSH STATUS; --echo SELECT * FROM status_by_account WHERE user LIKE 'user%' AND variable_name IN ('handler_delete'); --echo SELECT * FROM status_by_host WHERE host IN ('localhost') AND variable_name IN ('handler_delete'); --echo SELECT * FROM status_by_user WHERE user LIKE 'user%' AND variable_name IN ('handler_delete'); --echo ================================================================================ --echo CLEANUP --echo ================================================================================ DROP TABLE test.t1; DROP TABLE test.t2; DROP TABLE test.t3; DROP TABLE test.status_results; DROP USER 'user1'@localhost; DROP USER 'user2'@localhost; DROP USER 'user3'@localhost; --echo --echo # Restore SHOW_COMPATIBILITY_56 setting SET @@global.show_compatibility_56 = @show_compatibility_56_save;
Close