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.224.5.46
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_sanity.result
create table test.sanity( `SHOW_MODE` varchar(48) NOT NULL, `SOURCE` varchar(64) NOT NULL, `VARIABLE_NAME` varchar(64) NOT NULL); select thread_id from performance_schema.threads where processlist_id = connection_id() into @my_tid; select @@global.show_compatibility_56 into @show_compatibility_56_save; set @my_user='root'; set @my_host='localhost'; ================================================================================ SHOW_COMPATIBILITY_56 = ON ================================================================================ set global show_compatibility_56 = on; # STEP 1-1 insert into test.sanity select "5.6", "I_S.GLOBAL_VARIABLES", variable_name from information_schema.global_variables; Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead # STEP 1-2 insert into test.sanity select "5.6", "I_S.SESSION_VARIABLES", variable_name from information_schema.session_variables; Warnings: Warning 1287 'INFORMATION_SCHEMA.SESSION_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.session_variables instead # STEP 1-3 insert into test.sanity select "5.6", "P_S.GLOBAL_VARIABLES", variable_name from performance_schema.global_variables; # STEP 1-4 insert into test.sanity select "5.6", "P_S.VARIABLES_BY_THREAD", variable_name from performance_schema.variables_by_thread where thread_id = @my_tid; # STEP 1-5 insert into test.sanity select "5.6", "P_S.SESSION_VARIABLES", variable_name from performance_schema.session_variables; # STEP 1-6 insert into test.sanity select "5.6", "I_S.GLOBAL_STATUS", variable_name from information_schema.global_status; Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead # STEP 1-7 insert into test.sanity select "5.6", "I_S.SESSION_STATUS", variable_name from information_schema.session_status; Warnings: Warning 1287 'INFORMATION_SCHEMA.SESSION_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.session_status instead # STEP 1-8 insert into test.sanity select "5.6", "P_S.GLOBAL_STATUS", variable_name from performance_schema.global_status; # STEP 1-9 # EMPTY, NO WARNINGS (not available in 5.6 mode) select * from performance_schema.status_by_thread; THREAD_ID VARIABLE_NAME VARIABLE_VALUE # STEP 1-10 insert into test.sanity select "5.6", "P_S.SESSION_STATUS", variable_name from performance_schema.session_status; # STEP 1-11 # EMPTY, NO WARNINGS (not available in 5.6 mode) select * from performance_schema.status_by_account; USER HOST VARIABLE_NAME VARIABLE_VALUE # STEP 1-12 # EMPTY, NO WARNINGS (not available in 5.6 mode) select * from performance_schema.status_by_user; USER VARIABLE_NAME VARIABLE_VALUE # STEP 1-13 # EMPTY, NO WARNINGS (not available in 5.6 mode) select * from performance_schema.status_by_host; HOST VARIABLE_NAME VARIABLE_VALUE ================================================================================ SHOW_COMPATIBILITY_56 = OFF ================================================================================ set global show_compatibility_56 = off; # STEP 2-1 # FAILS WITH ERROR select * from information_schema.global_variables; ERROR HY000: The 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' feature is disabled; see the documentation for 'show_compatibility_56' # STEP 2-2 # FAILS WITH ERROR select * from information_schema.session_variables; ERROR HY000: The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled; see the documentation for 'show_compatibility_56' # STEP 2-3 insert into test.sanity select "5.7", "P_S.GLOBAL_VARIABLES", variable_name from performance_schema.global_variables; # STEP 2-4 insert into test.sanity select "5.7", "P_S.VARIABLES_BY_THREAD", variable_name from performance_schema.variables_by_thread where thread_id = @my_tid; # STEP 2-5 insert into test.sanity select "5.7", "P_S.SESSION_VARIABLES", variable_name from performance_schema.session_variables; # STEP 2-6 # FAILS WITH ERROR select * from information_schema.global_status; ERROR HY000: The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the documentation for 'show_compatibility_56' # STEP 2-7 # FAILS WITH ERROR select * from information_schema.session_status; ERROR HY000: The 'INFORMATION_SCHEMA.SESSION_STATUS' feature is disabled; see the documentation for 'show_compatibility_56' # STEP 2-8 insert into test.sanity select "5.7", "P_S.GLOBAL_STATUS", variable_name from performance_schema.global_status; # STEP 2-9 insert into test.sanity select "5.7", "P_S.STATUS_BY_THREAD", variable_name from performance_schema.status_by_thread where thread_id = @my_tid; # STEP 2-10 insert into test.sanity select "5.7", "P_S.SESSION_STATUS", variable_name from performance_schema.session_status; # STEP 2-11 insert into test.sanity select "5.7", "P_S.STATUS_BY_ACCOUNT", variable_name from performance_schema.status_by_account where `user` = @my_user and `host` = @my_host; # STEP 2-12 insert into test.sanity select "5.7", "P_S.STATUS_BY_USER", variable_name from performance_schema.status_by_user where `user` = @my_user; # STEP 2-13 insert into test.sanity select "5.7", "P_S.STATUS_BY_HOST", variable_name from performance_schema.status_by_host where `host` = @my_host; # STEP 2-14 # Known global variables in 5.6 that should not display in session queries. # These should be global-only system variables. # STEP 2-15 # Known global status in 5.6 that should not exist in session queries. # These should be global-only status variables. # STEP 2-15A # COM counters appear in I_S.SESSION_STATUS, but not in P_S.SESSION_STATUS # STEP 2-15B # These slave status counters appear in I_S.SESSION_STATUS, but not in P_S.SESSION_STATUS insert into test.sanity values ("JUNK: SLAVE-ONLY", "I_S.SESSION_STATUS", "SLAVE_HEARTBEAT_PERIOD"), ("JUNK: SLAVE-ONLY", "I_S.SESSION_STATUS", "SLAVE_LAST_HEARTBEAT"), ("JUNK: SLAVE-ONLY", "I_S.SESSION_STATUS", "SLAVE_RECEIVED_HEARTBEATS"), ("JUNK: SLAVE-ONLY", "I_S.SESSION_STATUS", "SLAVE_RETRIED_TRANSACTIONS"), ("JUNK: SLAVE-ONLY", "I_S.SESSION_STATUS", "SLAVE_RUNNING") ; # STEP 2-16 # Known session-only status in 5.6 that should not exist in global queries. insert into test.sanity values ("JUNK: SESSION-ONLY", "I_S.GLOBAL_STATUS", "COMPRESSION"), ("JUNK: SESSION-ONLY", "I_S.GLOBAL_STATUS", "LAST_QUERY_COST"), ("JUNK: SESSION-ONLY", "I_S.GLOBAL_STATUS", "LAST_QUERY_PARTIAL_PLANS") ; # STEP 2-16A # COM counters appear in I_S.GLOBAL_STATUS but not in P_S.GLOBAL_STATUS # STEP 2-16B # These slave status counters appear in I_S.GLOBAL_STATUS, but not in P_S.GLOBAL_STATUS insert into test.sanity values ("JUNK: SLAVE-ONLY", "I_S.GLOBAL_STATUS", "SLAVE_HEARTBEAT_PERIOD"), ("JUNK: SLAVE-ONLY", "I_S.GLOBAL_STATUS", "SLAVE_LAST_HEARTBEAT"), ("JUNK: SLAVE-ONLY", "I_S.GLOBAL_STATUS", "SLAVE_RECEIVED_HEARTBEATS"), ("JUNK: SLAVE-ONLY", "I_S.GLOBAL_STATUS", "SLAVE_RETRIED_TRANSACTIONS"), ("JUNK: SLAVE-ONLY", "I_S.GLOBAL_STATUS", "SLAVE_RUNNING") ; # STEP 2-17 # Status variables that should not exist in queries that aggregate across threads. # Criteria: Session-only OR non-aggregatable. insert into test.sanity values ("JUNK", "NO AGGREGATE", "COMPRESSION"), ("JUNK", "NO AGGREGATE", "LAST_QUERY_COST"), ("JUNK", "NO AGGREGATE", "LAST_QUERY_PARTIAL_PLANS"), ("JUNK", "NO AGGREGATE", "OPEN_TABLES"), ("JUNK", "NO AGGREGATE", "QUERIES"), ("JUNK", "NO AGGREGATE", "SLOW_LAUNCH_THREADS"), ("JUNK", "NO AGGREGATE", "SSL_CIPHER"), ("JUNK", "NO AGGREGATE", "SSL_CIPHER_LIST"), ("JUNK", "NO AGGREGATE", "SSL_DEFAULT_TIMEOUT"), ("JUNK", "NO AGGREGATE", "SSL_SERVER_NOT_AFTER"), ("JUNK", "NO AGGREGATE", "SSL_SERVER_NOT_BEFORE"), ("JUNK", "NO AGGREGATE", "SSL_SESSIONS_REUSED"), ("JUNK", "NO AGGREGATE", "SSL_VERIFY_DEPTH"), ("JUNK", "NO AGGREGATE", "SSL_VERIFY_MODE"), ("JUNK", "NO AGGREGATE", "SSL_VERSION") ; ================================================================================ TEST 1A Present in 5.6 P_S.GLOBAL_VARIABLES (1-3) Missing in 5.6 I_S.GLOBAL_VARIABLES (1-1) ================================================================================ select * from test.sanity where show_mode = "5.6" and source = "P_S.GLOBAL_VARIABLES" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.6" and source = "I_S.GLOBAL_VARIABLES") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 1B Present in 5.7 P_S.GLOBAL_VARIABLES (2-3) Missing in 5.6 I_S.GLOBAL_VARIABLES (1-1) ================================================================================ select * from test.sanity where show_mode = "5.7" and source = "P_S.GLOBAL_VARIABLES" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.6" and source = "I_S.GLOBAL_VARIABLES") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 2A Present in 5.6 I_S.GLOBAL_VARIABLES (1-1) Missing in 5.6 P_S.GLOBAL_VARIABLES (1-3) ================================================================================ select * from test.sanity where show_mode = "5.6" and source = "I_S.GLOBAL_VARIABLES" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.6" and source = "P_S.GLOBAL_VARIABLES") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME 5.6 I_S.GLOBAL_VARIABLES SQL_LOG_BIN ================================================================================ TEST 2B Present in 5.6 I_S.GLOBAL_VARIABLES (1-1) Missing in 5.7 P_S.GLOBAL_VARIABLES (2-3) ================================================================================ select * from test.sanity where show_mode = "5.6" and source = "I_S.GLOBAL_VARIABLES" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.7" and source = "P_S.GLOBAL_VARIABLES") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME 5.6 I_S.GLOBAL_VARIABLES SQL_LOG_BIN ================================================================================ TEST 3A Present in 5.6 P_S.SESSION_VARIABLES (1-5) Missing in 5.6 I_S.SESSION_VARIABLES (1-2) ================================================================================ select * from test.sanity where show_mode = "5.6" and source = "P_S.SESSION_VARIABLES" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.6" and source = "I_S.SESSION_VARIABLES") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 3B Present in 5.7 P_S.SESSION_VARIABLES (2-5) Missing in 5.6 I_S.SESSION_VARIABLES (1-2) ================================================================================ select * from test.sanity where show_mode = "5.7" and source = "P_S.SESSION_VARIABLES" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.6" and source = "I_S.SESSION_VARIABLES") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 4A Present in 5.6 I_S.SESSION_VARIABLES (1-2) Missing in 5.6 P_S.SESSION_VARIABLES (1-5) ================================================================================ select * from test.sanity where show_mode = "5.6" and source = "I_S.SESSION_VARIABLES" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.6" and source = "P_S.SESSION_VARIABLES") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME 5.6 I_S.SESSION_VARIABLES GTID_EXECUTED ================================================================================ TEST 4B Present in 5.6 I_S.SESSION_VARIABLES (1-2) Missing in 5.7 P_S.SESSION_VARIABLES (2-5) ================================================================================ select * from test.sanity where show_mode = "5.6" and source = "I_S.SESSION_VARIABLES" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.7" and source = "P_S.SESSION_VARIABLES") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME 5.6 I_S.SESSION_VARIABLES GTID_EXECUTED ================================================================================ TEST 5A Present in 5.6 P_S.VARIABLES_BY_THREAD (1-4) Missing in 5.6 I_S.SESSION_VARIABLES (1-2) ================================================================================ select * from test.sanity where show_mode = "5.6" and source = "P_S.VARIABLES_BY_THREAD" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.6" and source = "I_S.SESSION_VARIABLES") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 5B Present in 5.7 P_S.VARIABLES_BY_THREAD (2-4) Missing in 5.6 I_S.SESSION_VARIABLES (1-2) ================================================================================ select * from test.sanity where show_mode = "5.7" and source = "P_S.VARIABLES_BY_THREAD" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.6" and source = "I_S.SESSION_VARIABLES") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 5C Present in 5.6 I_S.SESSION_VARIABLES (1-2) Missing in 5.6 P_S.VARIABLES_BY_THREAD (1-4) EXPECT NOTHING BESIDE KNOWN GLOBAL VARIABLES (2-14) ================================================================================ select * from test.sanity where show_mode = "5.6" and source = "I_S.SESSION_VARIABLES" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.6" and source = "P_S.VARIABLES_BY_THREAD") and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "JUNK: GLOBAL-ONLY" and source = "I_S.SESSION_VARIABLES") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME 5.6 I_S.SESSION_VARIABLES BINLOG_TRANSACTION_DEPENDENCY_HISTORY_SIZE 5.6 I_S.SESSION_VARIABLES BINLOG_TRANSACTION_DEPENDENCY_TRACKING 5.6 I_S.SESSION_VARIABLES GTID_EXECUTED 5.6 I_S.SESSION_VARIABLES INNODB_DEADLOCK_DETECT 5.6 I_S.SESSION_VARIABLES INNODB_STATS_INCLUDE_DELETE_MARKED 5.6 I_S.SESSION_VARIABLES KEYRING_OPERATIONS 5.6 I_S.SESSION_VARIABLES LOG_STATEMENTS_UNSAFE_FOR_BINLOG 5.6 I_S.SESSION_VARIABLES PERFORMANCE_SCHEMA_SHOW_PROCESSLIST 5.6 I_S.SESSION_VARIABLES REPLICATION_OPTIMIZE_FOR_STATIC_PLUGIN_CONFIG 5.6 I_S.SESSION_VARIABLES REPLICATION_SENDER_OBSERVE_COMMIT_ONLY 5.6 I_S.SESSION_VARIABLES TLS_VERSION ================================================================================ TEST 5D Present in 5.6 I_S.SESSION_VARIABLES (1-2) Missing in 5.7 P_S.VARIABLES_BY_THREAD (2-5) EXPECT NOTHING BESIDE KNOWN GLOBAL VARIABLES (2-14) ================================================================================ select * from test.sanity where show_mode = "5.6" and source = "I_S.SESSION_VARIABLES" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.7" and source = "P_S.VARIABLES_BY_THREAD") and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "JUNK: GLOBAL-ONLY" and source = "I_S.SESSION_VARIABLES") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME 5.6 I_S.SESSION_VARIABLES BINLOG_TRANSACTION_DEPENDENCY_HISTORY_SIZE 5.6 I_S.SESSION_VARIABLES BINLOG_TRANSACTION_DEPENDENCY_TRACKING 5.6 I_S.SESSION_VARIABLES GTID_EXECUTED 5.6 I_S.SESSION_VARIABLES INNODB_DEADLOCK_DETECT 5.6 I_S.SESSION_VARIABLES INNODB_STATS_INCLUDE_DELETE_MARKED 5.6 I_S.SESSION_VARIABLES KEYRING_OPERATIONS 5.6 I_S.SESSION_VARIABLES LOG_STATEMENTS_UNSAFE_FOR_BINLOG 5.6 I_S.SESSION_VARIABLES PERFORMANCE_SCHEMA_SHOW_PROCESSLIST 5.6 I_S.SESSION_VARIABLES REPLICATION_OPTIMIZE_FOR_STATIC_PLUGIN_CONFIG 5.6 I_S.SESSION_VARIABLES REPLICATION_SENDER_OBSERVE_COMMIT_ONLY 5.6 I_S.SESSION_VARIABLES TLS_VERSION ================================================================================ TEST 5E KNOWN GLOBAL VARIABLES (2-14) Expect missing in 5.6 P_S.VARIABLES_BY_THREAD (1-4) ================================================================================ select * from test.sanity where show_mode = "JUNK: GLOBAL-ONLY" and source = "I_S.SESSION_VARIABLES" and upper(variable_name) in ( select upper(variable_name) from test.sanity where show_mode = "5.6" and source = "P_S.VARIABLES_BY_THREAD") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 5F KNOWN GLOBAL VARIABLES (2-14) Expect missing in 5.7 P_S.VARIABLES_BY_THREAD (2-5) ================================================================================ select * from test.sanity where show_mode = "JUNK: GLOBAL-ONLY" and source = "I_S.SESSION_VARIABLES" and upper(variable_name) in ( select upper(variable_name) from test.sanity where show_mode = "5.7" and source = "P_S.VARIABLES_BY_THREAD") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 6A Present in 5.7 P_S.GLOBAL_STATUS (2-8) Missing in 5.6 I_S.GLOBAL_STATUS (1-6) EXPECT NOTHING ================================================================================ select * from test.sanity where show_mode = "5.7" and source = "P_S.GLOBAL_STATUS" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.6" and source = "I_S.GLOBAL_STATUS") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 6B Present in 5.7 P_S.GLOBAL_STATUS (2-8) Missing in 5.6 P_S.GLOBAL_STATUS (1-8) EXPECT NOTHING ================================================================================ select * from test.sanity where show_mode = "5.7" and source = "P_S.GLOBAL_STATUS" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.6" and source = "P_S.GLOBAL_STATUS") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 6C Present in 5.6 P_S.GLOBAL_STATUS (1-8) Missing in 5.7 P_S.GLOBAL_STATUS (2-8) EXPECT NOTHING ================================================================================ select * from test.sanity where show_mode = "5.6" and source = "P_S.GLOBAL_STATUS" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.7" and source = "P_S.GLOBAL_STATUS") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 7 Present in 5.6 I_S.GLOBAL_STATUS (1-6) Missing in 5.7 P_S.GLOBAL_STATUS (2-8) EXPECT NOTHING AFTER REMOVING KNOWN SESSION-ONLY, COM COUNTERS AND SLAVE-ONLY (2-16 & 2-16A & 2-16B) ================================================================================ select * from test.sanity where show_mode = "5.6" and source = "I_S.GLOBAL_STATUS" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where (show_mode = "JUNK: SESSION-ONLY" or show_mode = "JUNK: COM COUNTER" or show_mode = "JUNK: SLAVE-ONLY") and source = "I_S.GLOBAL_STATUS") and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.7" and source = "P_S.GLOBAL_STATUS") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME 5.6 I_S.GLOBAL_STATUS COM_SHUTDOWN ================================================================================ TEST 8 KNOWN SESSION-ONLY (2-16) KNOWN COM COUNTERS (2-16A) KNOWN SLAVE-ONLY (2-16B) Status variables that should NOT be present in 5.7 P_S.GLOBAL_STATUS (2-8) EXPECT NOTHING ================================================================================ select * from test.sanity where show_mode = "5.7" and source = "P_S.GLOBAL_STATUS" and upper(variable_name) in ( select upper(variable_name) from test.sanity where (show_mode = "JUNK: SESSION-ONLY" or show_mode = "JUNK: COM COUNTER" or show_mode = "JUNK: SLAVE-ONLY") and source = "I_S.GLOBAL_STATUS") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 9A Present in 5.7 P_S.SESSION_STATUS (2-10) Missing in 5.6 I_S.SESSION_STATUS (1-7) EXPECT NOTHING ================================================================================ select * from test.sanity where show_mode = "5.7" and source = "P_S.SESSION_STATUS" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.6" and source = "I_S.SESSION_STATUS") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 9B Present in 5.7 P_S.SESSION_STATUS (2-10) Missing in 5.6 P_S.SESSION_STATUS (1-10) EXPECT NOTHING ================================================================================ select * from test.sanity where show_mode = "5.7" and source = "P_S.SESSION_STATUS" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.6" and source = "P_S.SESSION_STATUS") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 9C Present in 5.6 P_S.SESSION_STATUS (1-10) Missing in 5.7 P_S.SESSION_STATUS (2-10) EXPECT NOTHING ================================================================================ select * from test.sanity where show_mode = "5.6" and source = "P_S.SESSION_STATUS" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.7" and source = "P_S.SESSION_STATUS") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 10 Present in 5.6 I_S.SESSION_STATUS (1-7) Missing in 5.7 P_S.SESSION_STATUS (2-10) EXPECT NOTHING AFTER REMOVING KNOWN COM COUNTERS AND SLAVE-ONLY (2-15A & 2-15B) ================================================================================ select * from test.sanity where show_mode = "5.6" and source = "I_S.SESSION_STATUS" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where (show_mode = "JUNK: COM COUNTER" or show_mode = "JUNK: SLAVE-ONLY") and source = "I_S.SESSION_STATUS") and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.7" and source = "P_S.SESSION_STATUS") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME 5.6 I_S.SESSION_STATUS COM_SHUTDOWN ================================================================================ TEST 11 KNOWN COM COUNTERS (2-15A) KNOWN SLAVE-ONLY (2-15B) Status variables that should NOT be present in 5.7 P_S.SESSION_STATUS (2-10) EXPECT NOTHING ================================================================================ select * from test.sanity where show_mode = "5.7" and source = "P_S.SESSION_STATUS" and upper(variable_name) in ( select upper(variable_name) from test.sanity where (show_mode = "JUNK: COM COUNTER" or show_mode = "JUNK: SLAVE-ONLY") and source = "I_S.SESSION_STATUS") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 12 Present in 5.7 P_S.SESSION_STATUS (2-10) Missing in 5.7 P_S.STATUS_BY_THREAD EXPECT NOTHING AFTER REMOVING KNOWN GLOBAL-ONLY (2-15) ================================================================================ select * from test.sanity where show_mode = "5.7" and source = "P_S.SESSION_STATUS" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.7" and source = "P_S.STATUS_BY_THREAD") and upper(variable_name) not in ( select upper(variable_name) from test.sanity where (show_mode = "JUNK: GLOBAL-ONLY") and source = "I_S.SESSION_STATUS") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 13 Present in 5.7 P_S.STATUS_BY_THREAD Missing in 5.7 P_S.SESSION_STATUS (2-10) EXPECT NOTHING ================================================================================ select * from test.sanity where show_mode = "5.7" and source = "P_S.STATUS_BY_THREAD" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.7" and source = "P_S.SESSION_STATUS") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 14 Present in 5.7 P_S.SESSION_STATUS (2-10) Missing in 5.7 P_S.STATUS_BY_ACCOUNT EXPECT NOTHING AFTER REMOVING - KNOWN GLOBAL-ONLY (2-15) - STATUS VARS THAT CAN'T BE AGGREGATED (2-17) ================================================================================ select * from test.sanity where show_mode = "5.7" and source = "P_S.SESSION_STATUS" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "JUNK" and source = "NO AGGREGATE") and upper(variable_name) not in ( select upper(variable_name) from test.sanity where (show_mode = "JUNK: GLOBAL-ONLY") and source = "I_S.SESSION_STATUS") and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.7" and source = "P_S.STATUS_BY_ACCOUNT") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 15 Present in 5.7 P_S.STATUS_BY_ACCOUNT Missing in 5.7 P_S.SESSION_STATUS (2-10) EXPECT NOTHING ================================================================================ select * from test.sanity where show_mode = "5.7" and source = "P_S.STATUS_BY_ACCOUNT" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.7" and source = "P_S.SESSION_STATUS") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 16 KNOWN STATUS VARS THAT CAN'T BE AGGREGATED (2-17) Status variables that should NOT be present in 5.7 P_S.STATUS_BY_ACCOUNT ================================================================================ select * from performance_schema.status_by_account where upper(variable_name) in ( select upper(variable_name) from test.sanity where show_mode = "JUNK" and source = "NO AGGREGATE") order by variable_name; USER HOST VARIABLE_NAME VARIABLE_VALUE ================================================================================ TEST 17 Present in 5.7 P_S.SESSION_STATUS (2-10) Missing in 5.7 P_S.STATUS_BY_USER EXPECT NOTHING AFTER REMOVING - KNOWN GLOBAL-ONLY (2-15) - STATUS VARS THAT CAN'T BE AGGREGATED (2-17) ================================================================================ select * from test.sanity where show_mode = "5.7" and source = "P_S.SESSION_STATUS" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "JUNK" and source = "NO AGGREGATE") and upper(variable_name) not in ( select upper(variable_name) from test.sanity where (show_mode = "JUNK: GLOBAL-ONLY") and source = "I_S.SESSION_STATUS") and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.7" and source = "P_S.STATUS_BY_USER") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 18 Present in 5.7 P_S.STATUS_BY_USER Missing in 5.7 P_S.SESSION_STATUS (2-10) ================================================================================ select * from test.sanity where show_mode = "5.7" and source = "P_S.STATUS_BY_USER" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.7" and source = "P_S.SESSION_STATUS") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 19 KNOWN STATUS VARS THAT CAN'T BE AGGREGATED (2-17) Status variables that should NOT be present in 5.7 P_S.STATUS_BY_USER ================================================================================ select * from performance_schema.status_by_user where upper(variable_name) in ( select upper(variable_name) from test.sanity where show_mode = "JUNK" and source = "NO AGGREGATE") order by variable_name; USER VARIABLE_NAME VARIABLE_VALUE ================================================================================ TEST 20 Present in 5.7 P_S.SESSION_STATUS (2-10) Missing in 5.7 P_S.STATUS_BY_HOST EXPECT NOTHING AFTER REMOVING - KNOWN GLOBAL-ONLY (2-15) - STATUS VARS THAT CAN'T BE AGGREGATED (2-17) ================================================================================ select * from test.sanity where show_mode = "5.7" and source = "P_S.SESSION_STATUS" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "JUNK" and source = "NO AGGREGATE") and upper(variable_name) not in ( select upper(variable_name) from test.sanity where (show_mode = "JUNK: GLOBAL-ONLY") and source = "I_S.SESSION_STATUS") and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.7" and source = "P_S.STATUS_BY_HOST") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 21 Present in 5.7 P_S.STATUS_BY_HOST Missing in 5.7 P_S.SESSION_STATUS (2-10) ================================================================================ select * from test.sanity where show_mode = "5.7" and source = "P_S.STATUS_BY_HOST" and upper(variable_name) not in ( select upper(variable_name) from test.sanity where show_mode = "5.7" and source = "P_S.SESSION_STATUS") order by show_mode, source, variable_name; SHOW_MODE SOURCE VARIABLE_NAME ================================================================================ TEST 22 KNOWN STATUS VARS THAT CAN'T BE AGGREGATED (2-17) Status variables that should NOT be present in 5.7 P_S.STATUS_BY_HOST ================================================================================ select * from performance_schema.status_by_host where upper(variable_name) in ( select upper(variable_name) from test.sanity where show_mode = "JUNK" and source = "NO AGGREGATE") order by variable_name; HOST VARIABLE_NAME VARIABLE_VALUE ================================================================================ CLEAN UP ================================================================================ set @@global.show_compatibility_56 = @show_compatibility_56_save; drop table test.sanity;
Close