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.225.175.56
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 : transaction_nested_events.test
########## suite/perfschema/t/transaction_nested_events.test ######### # # # This test checks the following # # 1) nested events # # 2) various scenarios of stored program & transaction combinations # # # # # ###################################################################### --source include/have_perfschema.inc --source include/not_embedded.inc --source include/have_innodb.inc --source include/no_protocol.inc --disable_query_log --source ../include/transaction_setup.inc --enable_query_log --echo --echo #======================================================================== --echo # STEP 1 - SETUP --echo #======================================================================== --echo --echo ## Setup control thread --echo --connection default SET SESSION AUTOCOMMIT= 1; --disable_warnings USE test; DROP DATABASE IF EXISTS db; --enable_warnings --echo --echo ## Create test database, test tables, one transactional and one non-transactional CREATE DATABASE db; CREATE TABLE db.t1 (s1 int, s2 varchar(64)) ENGINE=INNODB; CREATE TABLE db.nt1 (s1 int, s2 varchar(64)) ENGINE=MYISAM; --echo --echo ## Setup connection 1 connect(con1, localhost, root,,); USE db; SET SESSION AUTOCOMMIT = 1; eval $get_thread_id; let $con1_thread_id= `SELECT @my_thread_id`; --connection default --disable_query_log eval SET @con1_thread_id= $con1_thread_id; --enable_query_log --echo --echo ## Disable events from the control (default) connection UPDATE performance_schema.threads SET instrumented = 'NO' WHERE processlist_id = CONNECTION_ID(); # Use this to select events from all threads eval SET @all_threads= 0; --echo --echo ## Enable only transaction and statement instruments UPDATE performance_schema.setup_instruments SET enabled='NO', timed='NO'; UPDATE performance_schema.setup_instruments SET enabled='YES' WHERE name LIKE ('statement/%') OR name = 'transaction'; --echo --echo ## Clear statement and transaction history CALL test.clear_history(); --echo --echo #======================================================================== --echo # STEP 2 - BASIC TRANSACTION --echo #======================================================================== --echo # --echo # STEP 2.1 - IMPLICIT --echo # --connection con1 INSERT INTO t1 VALUES (210, "INSERT 210"); INSERT INTO t1 VALUES (211, "INSERT 211"); INSERT INTO t1 VALUES (212, "INSERT 212"); UPDATE t1 SET s1 = s1 + 1 WHERE s1 = 212; ## Verify and reset --source ../include/transaction_nested_events_verifier.inc --echo # --echo # STEP 2.2 - EXPLICIT --echo # --connection con1 START TRANSACTION; INSERT INTO t1 VALUES (220, "INSERT 220"), (221, "INSERT 221"); UPDATE t1 SET s2 = "UPDATE 221" WHERE s1 = 221; COMMIT; ## Verify and reset --source ../include/transaction_nested_events_verifier.inc --echo #======================================================================== --echo # STEP 3 - TRANSACTIONS AND STORED PROCEDURES --echo #======================================================================== --echo # --echo # STEP 3.1 - STORED PROCEDURE STARTED WITHIN TRANSACTION --echo # --connection con1 CREATE PROCEDURE tp_update() UPDATE t1 SET s1 = s1 + 1; --echo START TRANSACTION; INSERT INTO t1 VALUES (310, "INSERT 310"); INSERT INTO t1 VALUES (311, "INSERT 311"); INSERT INTO t1 VALUES (312, "INSERT 312"); INSERT INTO t1 VALUES (313, "INSERT 313"); CALL tp_update(); COMMIT; ## Verify and reset --source ../include/transaction_nested_events_verifier.inc --echo # --echo # STEP 3.2 - TRANSACTION STARTED WITHIN STORED PROCEDURE --echo # --connection con1 CREATE PROCEDURE tp_start() START TRANSACTION; --echo CALL tp_start(); INSERT INTO t1 VALUES (320, "INSERT 320"),(321, "INSERT 321"); INSERT INTO t1 VALUES (322, "INSERT 322"),(323, "INSERT 323"); UPDATE t1 SET s1 = s1 + 1 WHERE s1 > 320; --echo SELECT * FROM t1 ORDER BY s1; COMMIT; ## Verify and reset --source ../include/transaction_nested_events_verifier.inc --echo # --echo # STEP 3.3 - TRANSACTION ENDED WITHIN STORED PROCEDURE --echo # --connection con1 CREATE PROCEDURE tp_rollback() ROLLBACK; CREATE PROCEDURE tp_commit() COMMIT; --echo --echo ## COMMIT within stored procedure START TRANSACTION; INSERT INTO t1 VALUES (330, "INSERT 330"),(331, "INSERT 331"); INSERT INTO t1 VALUES (332, "INSERT 332"),(333, "INSERT 333"); DELETE FROM t1 WHERE s1 > 331; CALL tp_commit(); --echo SELECT * FROM t1 ORDER BY s1; --echo --echo ## ROLLBACK within stored procedure START TRANSACTION; UPDATE t1 SET s1 = s1*2 WHERE s1 > 331; CALL tp_rollback(); --echo SELECT * FROM t1 ORDER BY s1; ## Verify and reset --source ../include/transaction_nested_events_verifier.inc --echo #======================================================================== --echo # STEP 4 - TRANSACTIONS AND STORED FUNCTIONS --echo #======================================================================== --echo --echo # --echo # STEP 4.1 - FUNCTION WITHIN A TRANSACTION --echo # --connection con1 DELIMITER |; CREATE FUNCTION fn_add(x INT, y INT) RETURNS INT BEGIN INSERT INTO t1 VALUES (x, "INSERT x"),(y, "INSERT y"); RETURN x+y; END | DELIMITER ;| --echo --echo ## Clear history --connection default CALL test.clear_history(); --connection con1 --echo START TRANSACTION; INSERT INTO t1 VALUES (410, "INSERT 410"); INSERT INTO t1 VALUES (411, "INSERT 411"); INSERT INTO t1 VALUES (412, "INSERT 412"); DELETE FROM t1 WHERE s1 > 410; --echo SELECT * FROM t1 ORDER BY s1; --echo SELECT fn_add(413, 414); COMMIT; --echo SELECT * FROM t1 ORDER BY s1; ## Verify and reset --source ../include/transaction_nested_events_verifier.inc --connection con1 --echo --echo ## Again, but this time with a rollback --echo START TRANSACTION; SELECT fn_add(415, 416); --echo ROLLBACK; --echo SELECT * FROM t1 ORDER BY s1; ## Verify and reset --source ../include/transaction_nested_events_verifier.inc --echo # --echo # STEP 4.2 - TRANSACTION CANNOT BE STARTED OR ENDED WITHIN FUNCTION --echo # --connection con1 DELIMITER |; --error ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG CREATE FUNCTION fn_err1() RETURNS VARCHAR(10) BEGIN START TRANSACTION ; RETURN invalid ; END| DELIMITER ;| --echo --echo ## Expect 0 transactions --connection default SELECT COUNT(*) FROM performance_schema.events_transactions_history; --connection con1 --echo --echo ## Expect stored function does not exist --echo --error ER_SP_DOES_NOT_EXIST SELECT fn_err1(); --echo --echo ## Expect 0 transactions --connection default SELECT COUNT(*) FROM performance_schema.events_transactions_history; --connection con1 --echo DELIMITER |; --error ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG CREATE FUNCTION fn_err2() RETURNS VARCHAR(10) BEGIN COMMIT; RETURN invalid ; END| DELIMITER ;| --echo --echo ## Expect stored function does not exist --echo START TRANSACTION; DELETE FROM t1 WHERE s1 > 320; --error ER_SP_DOES_NOT_EXIST SELECT fn_err2(); --echo --echo ## Expect 0 transactions --connection default SELECT COUNT(*) FROM performance_schema.events_transactions_history; --echo --echo ## Clear transaction and statement tables CALL test.clear_history(); --echo #======================================================================== --echo # STEP 5 - TRANSACTIONS AND TRIGGERS --echo #======================================================================== --echo --echo # --echo # STEP 5.1 - FORCE STATEMENT ROLLBACK FROM TRIGGER --echo # --connection con1 --echo ## Create a trigger to force statement rollback --echo DELIMITER |; CREATE TRIGGER trigger_before_update BEFORE UPDATE ON t1 FOR EACH ROW BEGIN IF OLD.s1 >= 505 THEN SIGNAL sqlstate '45001' SET message_text = "FORCE ERROR"; END IF; END;| DELIMITER ;| --echo --echo ## Clear history --connection default CALL test.clear_history(); --connection con1 --echo --echo ## Insert multiple rows, then update. Trigger will force rollback the --echo ## UPDATE statement, but the transaction should not roll back. --echo START TRANSACTION; INSERT INTO t1 VALUES (500, "INSERT 500"); INSERT INTO t1 VALUES (501, "INSERT 501"); INSERT INTO t1 VALUES (502, "INSERT 502"); INSERT INTO t1 VALUES (503, "INSERT 503"); INSERT INTO t1 VALUES (504, "INSERT 504"); INSERT INTO t1 VALUES (505, "INSERT 505"); --echo SELECT * FROM t1 ORDER BY s1; --echo --echo ## Expect error when UPDATE hits record 505 --echo --error ER_SIGNAL_EXCEPTION UPDATE t1 SET s1 = s1 * 2 WHERE s1 >= 500; --echo --echo ## Verify that INSERT succeeded, UPDATE failed and transaction did not rollback --echo SELECT * FROM t1 ORDER BY s1; COMMIT; --echo DROP TRIGGER trigger_before_update; ## Verify and reset --source ../include/transaction_nested_events_verifier.inc --echo # TODO: Detect statement events from scheduled event --disable_parsing --echo #======================================================================== --echo # STEP 6 - SCHEDULED EVENTS --echo #======================================================================== --connection con1 # Check that the event_scheduler is really running #--source include/running_event_scheduler.inc --echo --echo ## Create a one-time event that will insert, update, commit and rollback. --echo DELIMITER |; CREATE EVENT trx_event ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 5 SECOND DO BEGIN START TRANSACTION; INSERT INTO t1 VALUES (600, "INSERT 600"); INSERT INTO t1 VALUES (601, "INSERT 601"); INSERT INTO t1 VALUES (602, "INSERT 602"); COMMIT; START TRANSACTION; UPDATE t1 SET s1 = s1 + 1, s2 = 'THIS SHOULD NOT BE HERE'; ROLLBACK; START TRANSACTION; INSERT INTO t1 VALUES (699, "INSERT 699"); COMMIT; END;| DELIMITER ;| --echo --echo ## Clear history --connection default CALL test.clear_history(); --connection con1 --echo --echo ## Wait a few seconds for scheduled event to execute and finish. # Check based on the expected content in t1. let $wait_condition= SELECT COUNT(*) = 4 FROM t1; --source include/wait_condition.inc --echo --echo ## Confirm that the scheduled event completed and the content of t1 is right. --echo SELECT * FROM t1 ORDER BY s1; --echo --echo ## Verify and reset --echo eval SET @all_threads= 1; --source ../include/transaction_nested_events_verifier.inc eval SET @all_threads= 0; --enable_parsing --echo #======================================================================= --echo # Cleanup --echo #======================================================================= --connection con1 --disconnect con1 --source include/wait_until_disconnected.inc --connection default DROP DATABASE db; UPDATE performance_schema.setup_instruments SET enabled='YES', timed='YES'; --source ../include/transaction_cleanup.inc
Close