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.117.121.71
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 : threads_history.test
# Check the impact of changes done in HISTORY column in # performance_schema.setup_actors. --source include/not_embedded.inc --source include/have_perfschema.inc --source include/no_protocol.inc # Presence of the query cache changes query stages, # causing noise in the test output --source include/have_query_cache_disabled.inc create user user1@localhost; create user user2@localhost; create user user3@localhost; create user user4@localhost; grant ALL on *.* to user1@localhost; grant ALL on *.* to user2@localhost; grant ALL on *.* to user3@localhost; grant ALL on *.* to user4@localhost; flush privileges; select * from performance_schema.setup_consumers; --echo # Switch to (con1, localhost, user1, , ) connect (con1, localhost, user1, , ); update performance_schema.threads set INSTRUMENTED='YES', HISTORY='YES' where PROCESSLIST_ID = connection_id(); let $con1_thread_id= `select THREAD_ID from performance_schema.threads where PROCESSLIST_ID = connection_id()`; --echo # Switch to (con2, localhost, user2, , ) connect (con2, localhost, user2, , ); update performance_schema.threads set INSTRUMENTED='YES', HISTORY='NO' where PROCESSLIST_ID = connection_id(); let $con2_thread_id= `select THREAD_ID from performance_schema.threads where PROCESSLIST_ID = connection_id()`; --echo # Switch to (con3, localhost, user3, , ) connect (con3, localhost, user3, , ); update performance_schema.threads set INSTRUMENTED='NO', HISTORY='YES' where PROCESSLIST_ID = connection_id(); let $con3_thread_id= `select THREAD_ID from performance_schema.threads where PROCESSLIST_ID = connection_id()`; --echo # Switch to (con4, localhost, user4, , ) connect (con4, localhost, user4, , ); update performance_schema.threads set INSTRUMENTED='NO', HISTORY='NO' where PROCESSLIST_ID = connection_id(); let $con4_thread_id= `select THREAD_ID from performance_schema.threads where PROCESSLIST_ID = connection_id()`; --echo # Switch to connection default --connection default truncate table performance_schema.events_transactions_current; truncate table performance_schema.events_transactions_history; truncate table performance_schema.events_transactions_history_long; truncate table performance_schema.events_statements_current; truncate table performance_schema.events_statements_history; truncate table performance_schema.events_statements_history_long; truncate table performance_schema.events_stages_current; truncate table performance_schema.events_stages_history; truncate table performance_schema.events_stages_history_long; truncate table performance_schema.events_waits_current; truncate table performance_schema.events_waits_history; truncate table performance_schema.events_waits_history_long; --echo # Switch to connection con1 --connection con1 XA START 'XA_CON1', 'XA_BQUAL', 12; select "Hi from con1"; XA END 'XA_CON1', 'XA_BQUAL', 12; XA PREPARE 'XA_CON1', 'XA_BQUAL', 12; XA COMMIT 'XA_CON1', 'XA_BQUAL', 12; --echo # Switch to connection con2 --connection con2 XA START 'XA_CON2', 'XA_BQUAL', 12; select "Hi from con2"; XA END 'XA_CON2', 'XA_BQUAL', 12; XA PREPARE 'XA_CON2', 'XA_BQUAL', 12; XA COMMIT 'XA_CON2', 'XA_BQUAL', 12; --echo # Switch to connection con3 --connection con3 XA START 'XA_CON3', 'XA_BQUAL', 12; select "Hi from con3"; XA END 'XA_CON3', 'XA_BQUAL', 12; XA PREPARE 'XA_CON3', 'XA_BQUAL', 12; XA COMMIT 'XA_CON3', 'XA_BQUAL', 12; --echo # Switch to connection con4 --connection con4 XA START 'XA_CON4', 'XA_BQUAL', 12; select "Hi from con4"; XA END 'XA_CON4', 'XA_BQUAL', 12; XA PREPARE 'XA_CON4', 'XA_BQUAL', 12; XA COMMIT 'XA_CON4', 'XA_BQUAL', 12; --connection default --disable_query_log echo "=========================== Transactions user 1"; eval select XID_FORMAT_ID, XID_GTRID, XID_BQUAL from performance_schema.events_transactions_current where THREAD_ID = $con1_thread_id; eval select XID_FORMAT_ID, XID_GTRID, XID_BQUAL from performance_schema.events_transactions_history where THREAD_ID = $con1_thread_id; eval select XID_FORMAT_ID, XID_GTRID, XID_BQUAL from performance_schema.events_transactions_history_long where THREAD_ID = $con1_thread_id; echo "=========================== Transactions user 2"; eval select XID_FORMAT_ID, XID_GTRID, XID_BQUAL from performance_schema.events_transactions_current where THREAD_ID = $con2_thread_id; eval select count(*) from performance_schema.events_transactions_history where THREAD_ID = $con2_thread_id; eval select count(*) from performance_schema.events_transactions_history_long where THREAD_ID = $con2_thread_id; echo "=========================== Transactions user 3"; eval select count(*) from performance_schema.events_transactions_current where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_transactions_history where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_transactions_history_long where THREAD_ID = $con3_thread_id; echo "=========================== Transactions user 4"; eval select count(*) from performance_schema.events_transactions_current where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_transactions_history where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_transactions_history_long where THREAD_ID = $con4_thread_id; echo "=========================== Statements user 1"; eval select EVENT_NAME, SQL_TEXT from performance_schema.events_statements_current where THREAD_ID = $con1_thread_id order by THREAD_ID, EVENT_ID; eval select EVENT_NAME, SQL_TEXT from performance_schema.events_statements_history where THREAD_ID = $con1_thread_id order by THREAD_ID, EVENT_ID; eval select EVENT_NAME, SQL_TEXT from performance_schema.events_statements_history_long where THREAD_ID = $con1_thread_id order by THREAD_ID, EVENT_ID; echo "=========================== Statements user 2"; eval select EVENT_NAME, SQL_TEXT from performance_schema.events_statements_current where THREAD_ID = $con2_thread_id order by THREAD_ID, EVENT_ID; eval select count(*) from performance_schema.events_statements_history where THREAD_ID = $con2_thread_id; eval select count(*) from performance_schema.events_statements_history_long where THREAD_ID = $con2_thread_id; echo "=========================== Statements user 3"; eval select count(*) from performance_schema.events_statements_current where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_statements_history where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_statements_history_long where THREAD_ID = $con3_thread_id; echo "=========================== Statements user 4"; eval select count(*) from performance_schema.events_statements_current where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_statements_history where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_statements_history_long where THREAD_ID = $con4_thread_id; echo "=========================== Stages user 1"; eval select EVENT_NAME from performance_schema.events_stages_current where THREAD_ID = $con1_thread_id order by THREAD_ID, EVENT_ID; eval select EVENT_NAME from performance_schema.events_stages_history where THREAD_ID = $con1_thread_id order by THREAD_ID, EVENT_ID; eval select EVENT_NAME from performance_schema.events_stages_history_long where THREAD_ID = $con1_thread_id order by THREAD_ID, EVENT_ID; echo "=========================== Stages user 2"; eval select EVENT_NAME from performance_schema.events_stages_current where THREAD_ID = $con2_thread_id order by THREAD_ID, EVENT_ID; eval select count(*) from performance_schema.events_stages_history where THREAD_ID = $con2_thread_id; eval select count(*) from performance_schema.events_stages_history_long where THREAD_ID = $con2_thread_id; echo "=========================== Stages user 3"; eval select count(*) from performance_schema.events_stages_current where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_stages_history where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_stages_history_long where THREAD_ID = $con3_thread_id; echo "=========================== Stages user 4"; eval select count(*) from performance_schema.events_stages_current where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_stages_history where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_stages_history_long where THREAD_ID = $con4_thread_id; echo "=========================== Waits user 1"; eval select EVENT_NAME from performance_schema.events_waits_current where THREAD_ID = $con1_thread_id order by THREAD_ID, EVENT_ID; eval select (count(*) > 5) as has_waits from performance_schema.events_waits_history where THREAD_ID = $con1_thread_id; eval select (count(*) > 15) as has_waits from performance_schema.events_waits_history_long where THREAD_ID = $con1_thread_id; echo "=========================== Waits user 2"; eval select EVENT_NAME from performance_schema.events_waits_current where THREAD_ID = $con2_thread_id order by THREAD_ID, EVENT_ID; eval select count(*) from performance_schema.events_waits_history where THREAD_ID = $con2_thread_id; eval select count(*) from performance_schema.events_waits_history_long where THREAD_ID = $con2_thread_id; echo "=========================== Waits user 3"; eval select count(*) from performance_schema.events_waits_current where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_waits_history where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_waits_history_long where THREAD_ID = $con3_thread_id; echo "=========================== Waits user 4"; eval select count(*) from performance_schema.events_waits_current where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_waits_history where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_waits_history_long where THREAD_ID = $con4_thread_id; --enable_query_log --echo # Switch to connection default, disable consumers --connection default update performance_schema.setup_consumers set enabled='NO' where name like "%history%"; select * from performance_schema.setup_consumers; truncate table performance_schema.events_transactions_current; truncate table performance_schema.events_transactions_history; truncate table performance_schema.events_transactions_history_long; truncate table performance_schema.events_statements_current; truncate table performance_schema.events_statements_history; truncate table performance_schema.events_statements_history_long; truncate table performance_schema.events_stages_current; truncate table performance_schema.events_stages_history; truncate table performance_schema.events_stages_history_long; truncate table performance_schema.events_waits_current; truncate table performance_schema.events_waits_history; truncate table performance_schema.events_waits_history_long; --echo # Switch to connection con1 --connection con1 XA START 'XA_CON1', 'XA_BQUAL', 12; select "Hi from con1"; XA END 'XA_CON1', 'XA_BQUAL', 12; XA PREPARE 'XA_CON1', 'XA_BQUAL', 12; XA COMMIT 'XA_CON1', 'XA_BQUAL', 12; --echo # Switch to connection con2 --connection con2 XA START 'XA_CON2', 'XA_BQUAL', 12; select "Hi from con2"; XA END 'XA_CON2', 'XA_BQUAL', 12; XA PREPARE 'XA_CON2', 'XA_BQUAL', 12; XA COMMIT 'XA_CON2', 'XA_BQUAL', 12; --echo # Switch to connection con3 --connection con3 XA START 'XA_CON3', 'XA_BQUAL', 12; select "Hi from con3"; XA END 'XA_CON3', 'XA_BQUAL', 12; XA PREPARE 'XA_CON3', 'XA_BQUAL', 12; XA COMMIT 'XA_CON3', 'XA_BQUAL', 12; --echo # Switch to connection con4 --connection con4 XA START 'XA_CON4', 'XA_BQUAL', 12; select "Hi from con4"; XA END 'XA_CON4', 'XA_BQUAL', 12; XA PREPARE 'XA_CON4', 'XA_BQUAL', 12; XA COMMIT 'XA_CON4', 'XA_BQUAL', 12; --connection default --disable_query_log echo "=========================== Transactions user 1"; eval select XID_FORMAT_ID, XID_GTRID, XID_BQUAL from performance_schema.events_transactions_current where THREAD_ID = $con1_thread_id; eval select count(*) from performance_schema.events_transactions_history where THREAD_ID = $con1_thread_id; eval select count(*) from performance_schema.events_transactions_history_long where THREAD_ID = $con1_thread_id; echo "=========================== Transactions user 2"; eval select XID_FORMAT_ID, XID_GTRID, XID_BQUAL from performance_schema.events_transactions_current where THREAD_ID = $con2_thread_id; eval select count(*) from performance_schema.events_transactions_history where THREAD_ID = $con2_thread_id; eval select count(*) from performance_schema.events_transactions_history_long where THREAD_ID = $con2_thread_id; echo "=========================== Transactions user 3"; eval select count(*) from performance_schema.events_transactions_current where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_transactions_history where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_transactions_history_long where THREAD_ID = $con3_thread_id; echo "=========================== Transactions user 4"; eval select count(*) from performance_schema.events_transactions_current where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_transactions_history where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_transactions_history_long where THREAD_ID = $con4_thread_id; echo "=========================== Statements user 1"; eval select EVENT_NAME, SQL_TEXT from performance_schema.events_statements_current where THREAD_ID = $con1_thread_id order by THREAD_ID, EVENT_ID; eval select count(*) from performance_schema.events_statements_history where THREAD_ID = $con1_thread_id; eval select count(*) from performance_schema.events_statements_history_long where THREAD_ID = $con1_thread_id; echo "=========================== Statements user 2"; eval select EVENT_NAME, SQL_TEXT from performance_schema.events_statements_current where THREAD_ID = $con2_thread_id order by THREAD_ID, EVENT_ID; eval select count(*) from performance_schema.events_statements_history where THREAD_ID = $con2_thread_id; eval select count(*) from performance_schema.events_statements_history_long where THREAD_ID = $con2_thread_id; echo "=========================== Statements user 3"; eval select count(*) from performance_schema.events_statements_current where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_statements_history where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_statements_history_long where THREAD_ID = $con3_thread_id; echo "=========================== Statements user 4"; eval select count(*) from performance_schema.events_statements_current where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_statements_history where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_statements_history_long where THREAD_ID = $con4_thread_id; echo "=========================== Stages user 1"; eval select EVENT_NAME from performance_schema.events_stages_current where THREAD_ID = $con1_thread_id order by THREAD_ID, EVENT_ID; eval select count(*) from performance_schema.events_stages_history where THREAD_ID = $con1_thread_id; eval select count(*) from performance_schema.events_stages_history_long where THREAD_ID = $con1_thread_id; echo "=========================== Stages user 2"; eval select EVENT_NAME from performance_schema.events_stages_current where THREAD_ID = $con2_thread_id order by THREAD_ID, EVENT_ID; eval select count(*) from performance_schema.events_stages_history where THREAD_ID = $con2_thread_id; eval select count(*) from performance_schema.events_stages_history_long where THREAD_ID = $con2_thread_id; echo "=========================== Stages user 3"; eval select count(*) from performance_schema.events_stages_current where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_stages_history where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_stages_history_long where THREAD_ID = $con3_thread_id; echo "=========================== Stages user 4"; eval select count(*) from performance_schema.events_stages_current where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_stages_history where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_stages_history_long where THREAD_ID = $con4_thread_id; echo "=========================== Waits user 1"; eval select EVENT_NAME from performance_schema.events_waits_current where THREAD_ID = $con1_thread_id order by THREAD_ID, EVENT_ID; eval select count(*) as has_waits from performance_schema.events_waits_history where THREAD_ID = $con1_thread_id; eval select count(*) as has_waits from performance_schema.events_waits_history_long where THREAD_ID = $con1_thread_id; echo "=========================== Waits user 2"; eval select EVENT_NAME from performance_schema.events_waits_current where THREAD_ID = $con2_thread_id order by THREAD_ID, EVENT_ID; eval select count(*) from performance_schema.events_waits_history where THREAD_ID = $con2_thread_id; eval select count(*) from performance_schema.events_waits_history_long where THREAD_ID = $con2_thread_id; echo "=========================== Waits user 3"; eval select count(*) from performance_schema.events_waits_current where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_waits_history where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_waits_history_long where THREAD_ID = $con3_thread_id; echo "=========================== Waits user 4"; eval select count(*) from performance_schema.events_waits_current where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_waits_history where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_waits_history_long where THREAD_ID = $con4_thread_id; --enable_query_log --echo # Switch to connection default, enable consumers --connection default update performance_schema.setup_consumers set enabled='YES' where name like "%history%"; select * from performance_schema.setup_consumers; truncate table performance_schema.events_transactions_current; truncate table performance_schema.events_transactions_history; truncate table performance_schema.events_transactions_history_long; truncate table performance_schema.events_statements_current; truncate table performance_schema.events_statements_history; truncate table performance_schema.events_statements_history_long; truncate table performance_schema.events_stages_current; truncate table performance_schema.events_stages_history; truncate table performance_schema.events_stages_history_long; truncate table performance_schema.events_waits_current; truncate table performance_schema.events_waits_history; truncate table performance_schema.events_waits_history_long; --echo # Switch to connection con1 --connection con1 XA START 'XA_CON1', 'XA_BQUAL', 12; select "Hi from con1"; XA END 'XA_CON1', 'XA_BQUAL', 12; XA PREPARE 'XA_CON1', 'XA_BQUAL', 12; XA COMMIT 'XA_CON1', 'XA_BQUAL', 12; --echo # Switch to connection con2 --connection con2 XA START 'XA_CON2', 'XA_BQUAL', 12; select "Hi from con2"; XA END 'XA_CON2', 'XA_BQUAL', 12; XA PREPARE 'XA_CON2', 'XA_BQUAL', 12; XA COMMIT 'XA_CON2', 'XA_BQUAL', 12; --echo # Switch to connection con3 --connection con3 XA START 'XA_CON3', 'XA_BQUAL', 12; select "Hi from con3"; XA END 'XA_CON3', 'XA_BQUAL', 12; XA PREPARE 'XA_CON3', 'XA_BQUAL', 12; XA COMMIT 'XA_CON3', 'XA_BQUAL', 12; --echo # Switch to connection con4 --connection con4 XA START 'XA_CON4', 'XA_BQUAL', 12; select "Hi from con4"; XA END 'XA_CON4', 'XA_BQUAL', 12; XA PREPARE 'XA_CON4', 'XA_BQUAL', 12; XA COMMIT 'XA_CON4', 'XA_BQUAL', 12; --connection default --disable_query_log echo "=========================== Transactions user 1"; eval select XID_FORMAT_ID, XID_GTRID, XID_BQUAL from performance_schema.events_transactions_current where THREAD_ID = $con1_thread_id; eval select XID_FORMAT_ID, XID_GTRID, XID_BQUAL from performance_schema.events_transactions_history where THREAD_ID = $con1_thread_id; eval select XID_FORMAT_ID, XID_GTRID, XID_BQUAL from performance_schema.events_transactions_history_long where THREAD_ID = $con1_thread_id; echo "=========================== Transactions user 2"; eval select XID_FORMAT_ID, XID_GTRID, XID_BQUAL from performance_schema.events_transactions_current where THREAD_ID = $con2_thread_id; eval select count(*) from performance_schema.events_transactions_history where THREAD_ID = $con2_thread_id; eval select count(*) from performance_schema.events_transactions_history_long where THREAD_ID = $con2_thread_id; echo "=========================== Transactions user 3"; eval select count(*) from performance_schema.events_transactions_current where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_transactions_history where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_transactions_history_long where THREAD_ID = $con3_thread_id; echo "=========================== Transactions user 4"; eval select count(*) from performance_schema.events_transactions_current where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_transactions_history where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_transactions_history_long where THREAD_ID = $con4_thread_id; echo "=========================== Statements user 1"; eval select EVENT_NAME, SQL_TEXT from performance_schema.events_statements_current where THREAD_ID = $con1_thread_id order by THREAD_ID, EVENT_ID; eval select EVENT_NAME, SQL_TEXT from performance_schema.events_statements_history where THREAD_ID = $con1_thread_id order by THREAD_ID, EVENT_ID; eval select EVENT_NAME, SQL_TEXT from performance_schema.events_statements_history_long where THREAD_ID = $con1_thread_id order by THREAD_ID, EVENT_ID; echo "=========================== Statements user 2"; eval select EVENT_NAME, SQL_TEXT from performance_schema.events_statements_current where THREAD_ID = $con2_thread_id order by THREAD_ID, EVENT_ID; eval select count(*) from performance_schema.events_statements_history where THREAD_ID = $con2_thread_id; eval select count(*) from performance_schema.events_statements_history_long where THREAD_ID = $con2_thread_id; echo "=========================== Statements user 3"; eval select count(*) from performance_schema.events_statements_current where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_statements_history where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_statements_history_long where THREAD_ID = $con3_thread_id; echo "=========================== Statements user 4"; eval select count(*) from performance_schema.events_statements_current where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_statements_history where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_statements_history_long where THREAD_ID = $con4_thread_id; echo "=========================== Stages user 1"; eval select EVENT_NAME from performance_schema.events_stages_current where THREAD_ID = $con1_thread_id order by THREAD_ID, EVENT_ID; eval select EVENT_NAME from performance_schema.events_stages_history where THREAD_ID = $con1_thread_id order by THREAD_ID, EVENT_ID; eval select EVENT_NAME from performance_schema.events_stages_history_long where THREAD_ID = $con1_thread_id order by THREAD_ID, EVENT_ID; echo "=========================== Stages user 2"; eval select EVENT_NAME from performance_schema.events_stages_current where THREAD_ID = $con2_thread_id order by THREAD_ID, EVENT_ID; eval select count(*) from performance_schema.events_stages_history where THREAD_ID = $con2_thread_id; eval select count(*) from performance_schema.events_stages_history_long where THREAD_ID = $con2_thread_id; echo "=========================== Stages user 3"; eval select count(*) from performance_schema.events_stages_current where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_stages_history where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_stages_history_long where THREAD_ID = $con3_thread_id; echo "=========================== Stages user 4"; eval select count(*) from performance_schema.events_stages_current where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_stages_history where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_stages_history_long where THREAD_ID = $con4_thread_id; echo "=========================== Waits user 1"; eval select EVENT_NAME from performance_schema.events_waits_current where THREAD_ID = $con1_thread_id order by THREAD_ID, EVENT_ID; eval select (count(*) > 5) as has_waits from performance_schema.events_waits_history where THREAD_ID = $con1_thread_id; eval select (count(*) > 15) as has_waits from performance_schema.events_waits_history_long where THREAD_ID = $con1_thread_id; echo "=========================== Waits user 2"; eval select EVENT_NAME from performance_schema.events_waits_current where THREAD_ID = $con2_thread_id order by THREAD_ID, EVENT_ID; eval select count(*) from performance_schema.events_waits_history where THREAD_ID = $con2_thread_id; eval select count(*) from performance_schema.events_waits_history_long where THREAD_ID = $con2_thread_id; echo "=========================== Waits user 3"; eval select count(*) from performance_schema.events_waits_current where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_waits_history where THREAD_ID = $con3_thread_id; eval select count(*) from performance_schema.events_waits_history_long where THREAD_ID = $con3_thread_id; echo "=========================== Waits user 4"; eval select count(*) from performance_schema.events_waits_current where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_waits_history where THREAD_ID = $con4_thread_id; eval select count(*) from performance_schema.events_waits_history_long where THREAD_ID = $con4_thread_id; --enable_query_log --echo # Switch to connection default --connection default revoke all privileges, grant option from user1@localhost; revoke all privileges, grant option from user2@localhost; revoke all privileges, grant option from user3@localhost; revoke all privileges, grant option from user4@localhost; drop user user1@localhost; drop user user2@localhost; drop user user3@localhost; drop user user4@localhost; flush privileges; truncate table performance_schema.setup_actors; insert into performance_schema.setup_actors values ('%', '%', '%', 'YES', 'YES'); select * from performance_schema.setup_actors;
Close