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.8.11
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
perfschema /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
all_tests.result
1.38
KB
-rw-r--r--
alter_table_progress.result
2.96
KB
-rw-r--r--
bad_option.result
342
B
-rw-r--r--
batch_table_io_func.result
6.2
KB
-rw-r--r--
binlog_edge_mix.result
8.28
KB
-rw-r--r--
binlog_edge_row.result
8.58
KB
-rw-r--r--
binlog_edge_stmt.result
15.31
KB
-rw-r--r--
binlog_ok_mix.result
4.6
KB
-rw-r--r--
binlog_ok_row.result
4.6
KB
-rw-r--r--
binlog_ok_stmt.result
4.6
KB
-rw-r--r--
checksum.result
7.33
KB
-rw-r--r--
cnf_option.result
263
B
-rw-r--r--
column_privilege.result
2.06
KB
-rw-r--r--
connect_attrs.result
1.47
KB
-rw-r--r--
connection.result
26.22
KB
-rw-r--r--
connection_3a.result
25.15
KB
-rw-r--r--
connection_3a_3u.result
24.58
KB
-rw-r--r--
connection_3u.result
25.66
KB
-rw-r--r--
connection_type_notwin.result
3.24
KB
-rw-r--r--
connection_type_win.result
3.33
KB
-rw-r--r--
csv_table_io.result
5.69
KB
-rw-r--r--
ddl_accounts.result
539
B
-rw-r--r--
ddl_cond_instances.result
580
B
-rw-r--r--
ddl_esgs_by_account_by_event_n...
669
B
-rw-r--r--
ddl_esgs_by_host_by_event_name...
657
B
-rw-r--r--
ddl_esgs_by_thread_by_event_na...
667
B
-rw-r--r--
ddl_esgs_by_user_by_event_name...
657
B
-rw-r--r--
ddl_esgs_global_by_event_name....
657
B
-rw-r--r--
ddl_esms_by_account_by_event_n...
685
B
-rw-r--r--
ddl_esms_by_digest.result
621
B
-rw-r--r--
ddl_esms_by_host_by_event_name...
673
B
-rw-r--r--
ddl_esms_by_program.result
635
B
-rw-r--r--
ddl_esms_by_thread_by_event_na...
683
B
-rw-r--r--
ddl_esms_by_user_by_event_name...
673
B
-rw-r--r--
ddl_esms_global_by_event_name....
673
B
-rw-r--r--
ddl_ets_by_account_by_event_na...
693
B
-rw-r--r--
ddl_ets_by_host_by_event_name....
681
B
-rw-r--r--
ddl_ets_by_thread_by_event_nam...
691
B
-rw-r--r--
ddl_ets_by_user_by_event_name....
681
B
-rw-r--r--
ddl_ets_global_by_event_name.r...
681
B
-rw-r--r--
ddl_events_stages_current.resu...
1.18
KB
-rw-r--r--
ddl_events_stages_history.resu...
1.18
KB
-rw-r--r--
ddl_events_stages_history_long...
1.21
KB
-rw-r--r--
ddl_events_statements_current....
585
B
-rw-r--r--
ddl_events_statements_history....
585
B
-rw-r--r--
ddl_events_statements_history_...
605
B
-rw-r--r--
ddl_events_transactions_curren...
593
B
-rw-r--r--
ddl_events_transactions_histor...
593
B
-rw-r--r--
ddl_events_transactions_histor...
613
B
-rw-r--r--
ddl_events_waits_current.resul...
565
B
-rw-r--r--
ddl_events_waits_history.resul...
565
B
-rw-r--r--
ddl_events_waits_history_long....
585
B
-rw-r--r--
ddl_ews_by_account_by_event_na...
665
B
-rw-r--r--
ddl_ews_by_host_by_event_name....
653
B
-rw-r--r--
ddl_ews_by_instance.result
617
B
-rw-r--r--
ddl_ews_by_thread_by_event_nam...
663
B
-rw-r--r--
ddl_ews_by_user_by_event_name....
653
B
-rw-r--r--
ddl_ews_global_by_event_name.r...
653
B
-rw-r--r--
ddl_file_instances.result
590
B
-rw-r--r--
ddl_fs_by_event_name.result
581
B
-rw-r--r--
ddl_fs_by_instance.result
573
B
-rw-r--r--
ddl_global_status.result
547
B
-rw-r--r--
ddl_global_variables.result
606
B
-rw-r--r--
ddl_host_cache.result
513
B
-rw-r--r--
ddl_hosts.result
527
B
-rw-r--r--
ddl_mems_by_account_by_event_n...
641
B
-rw-r--r--
ddl_mems_by_host_by_event_name...
629
B
-rw-r--r--
ddl_mems_by_thread_by_event_na...
637
B
-rw-r--r--
ddl_mems_by_user_by_event_name...
629
B
-rw-r--r--
ddl_mems_global_by_event_name....
625
B
-rw-r--r--
ddl_metadata_locks.result
592
B
-rw-r--r--
ddl_mutex_instances.result
584
B
-rw-r--r--
ddl_os_global_by_type.result
611
B
-rw-r--r--
ddl_performance_timers.result
608
B
-rw-r--r--
ddl_prepared_statements_instan...
619
B
-rw-r--r--
ddl_processlist.result
1
KB
-rw-r--r--
ddl_replication_applier_config...
674
B
-rw-r--r--
ddl_replication_applier_status...
650
B
-rw-r--r--
ddl_replication_applier_status...
698
B
-rw-r--r--
ddl_replication_applier_status...
678
B
-rw-r--r--
ddl_replication_connection_con...
668
B
-rw-r--r--
ddl_replication_connection_sta...
650
B
-rw-r--r--
ddl_replication_group_member_s...
654
B
-rw-r--r--
ddl_replication_group_members....
634
B
-rw-r--r--
ddl_rwlock_instances.result
588
B
-rw-r--r--
ddl_session_account_connect_at...
650
B
-rw-r--r--
ddl_session_connect_attrs.resu...
618
B
-rw-r--r--
ddl_session_status.result
598
B
-rw-r--r--
ddl_session_variables.result
610
B
-rw-r--r--
ddl_setup_actors.result
972
B
-rw-r--r--
ddl_setup_consumers.result
584
B
-rw-r--r--
ddl_setup_instruments.result
592
B
-rw-r--r--
ddl_setup_objects.result
843
B
-rw-r--r--
ddl_setup_timers.result
572
B
-rw-r--r--
ddl_socket_instances.result
598
B
-rw-r--r--
ddl_socket_summary_by_event_na...
591
B
-rw-r--r--
ddl_socket_summary_by_instance...
591
B
-rw-r--r--
ddl_status_by_account.result
563
B
-rw-r--r--
ddl_status_by_host.result
551
B
-rw-r--r--
ddl_status_by_thread.result
559
B
-rw-r--r--
ddl_status_by_user.result
551
B
-rw-r--r--
ddl_table_handles.result
588
B
-rw-r--r--
ddl_threads.result
572
B
-rw-r--r--
ddl_tiws_by_index_usage.result
637
B
-rw-r--r--
ddl_tiws_by_table.result
613
B
-rw-r--r--
ddl_tlws_by_table.result
621
B
-rw-r--r--
ddl_users.result
527
B
-rw-r--r--
ddl_uvar_by_thread.result
638
B
-rw-r--r--
ddl_variables_by_thread.result
618
B
-rw-r--r--
digest_null_literal.result
804
B
-rw-r--r--
digest_table_full.result
3.63
KB
-rw-r--r--
digest_view.result
6.42
KB
-rw-r--r--
dml_accounts.result
1.19
KB
-rw-r--r--
dml_cond_instances.result
1.06
KB
-rw-r--r--
dml_esgs_by_account_by_event_n...
1.85
KB
-rw-r--r--
dml_esgs_by_host_by_event_name...
1.79
KB
-rw-r--r--
dml_esgs_by_thread_by_event_na...
1.83
KB
-rw-r--r--
dml_esgs_by_user_by_event_name...
1.79
KB
-rw-r--r--
dml_esgs_global_by_event_name....
1.77
KB
-rw-r--r--
dml_esms_by_account_by_event_n...
1.92
KB
-rw-r--r--
dml_esms_by_digest.result
2.57
KB
-rw-r--r--
dml_esms_by_host_by_event_name...
1.86
KB
-rw-r--r--
dml_esms_by_program.result
2.77
KB
-rw-r--r--
dml_esms_by_thread_by_event_na...
1.89
KB
-rw-r--r--
dml_esms_by_user_by_event_name...
1.86
KB
-rw-r--r--
dml_esms_global_by_event_name....
1.83
KB
-rw-r--r--
dml_ets_by_account_by_event_na...
1.95
KB
-rw-r--r--
dml_ets_by_host_by_event_name....
1.89
KB
-rw-r--r--
dml_ets_by_thread_by_event_nam...
1.92
KB
-rw-r--r--
dml_ets_by_user_by_event_name....
1.89
KB
-rw-r--r--
dml_ets_global_by_event_name.r...
1.86
KB
-rw-r--r--
dml_events_stages_current.resu...
1.41
KB
-rw-r--r--
dml_events_stages_history.resu...
1.64
KB
-rw-r--r--
dml_events_stages_history_long...
1.73
KB
-rw-r--r--
dml_events_statements_current....
1.48
KB
-rw-r--r--
dml_events_statements_history....
1.73
KB
-rw-r--r--
dml_events_statements_history_...
1.81
KB
-rw-r--r--
dml_events_transactions_curren...
1.51
KB
-rw-r--r--
dml_events_transactions_histor...
1.76
KB
-rw-r--r--
dml_events_transactions_histor...
1.85
KB
-rw-r--r--
dml_events_waits_current.resul...
1.4
KB
-rw-r--r--
dml_events_waits_history.resul...
1.64
KB
-rw-r--r--
dml_events_waits_history_long....
1.73
KB
-rw-r--r--
dml_ews_by_account_by_event_na...
2.04
KB
-rw-r--r--
dml_ews_by_host_by_event_name....
1.97
KB
-rw-r--r--
dml_ews_by_instance.result
2.07
KB
-rw-r--r--
dml_ews_by_thread_by_event_nam...
1.81
KB
-rw-r--r--
dml_ews_by_user_by_event_name....
1.97
KB
-rw-r--r--
dml_ews_global_by_event_name.r...
1.75
KB
-rw-r--r--
dml_file_instances.result
3.21
KB
-rw-r--r--
dml_fs_by_event_name.result
1.52
KB
-rw-r--r--
dml_fs_by_instance.result
1.49
KB
-rw-r--r--
dml_global_status.result
1.13
KB
-rw-r--r--
dml_global_variables.result
1.17
KB
-rw-r--r--
dml_handler.result
19.35
KB
-rw-r--r--
dml_host_cache.result
1.28
KB
-rw-r--r--
dml_hosts.result
1.12
KB
-rw-r--r--
dml_mems_by_account_by_event_n...
1.76
KB
-rw-r--r--
dml_mems_by_host_by_event_name...
1.71
KB
-rw-r--r--
dml_mems_by_thread_by_event_na...
1.74
KB
-rw-r--r--
dml_mems_by_user_by_event_name...
1.71
KB
-rw-r--r--
dml_mems_global_by_event_name....
1.68
KB
-rw-r--r--
dml_metadata_locks.result
1.22
KB
-rw-r--r--
dml_mutex_instances.result
1.07
KB
-rw-r--r--
dml_os_global_by_type.result
2.81
KB
-rw-r--r--
dml_performance_timers.result
1.56
KB
-rw-r--r--
dml_prepared_statements_instan...
2.82
KB
-rw-r--r--
dml_processlist.result
1.26
KB
-rw-r--r--
dml_replication_applier_config...
1.33
KB
-rw-r--r--
dml_replication_applier_status...
1.46
KB
-rw-r--r--
dml_replication_applier_status...
1.75
KB
-rw-r--r--
dml_replication_applier_status...
1.67
KB
-rw-r--r--
dml_replication_connection_con...
1.64
KB
-rw-r--r--
dml_replication_connection_sta...
1.59
KB
-rw-r--r--
dml_replication_group_member_s...
1.89
KB
-rw-r--r--
dml_replication_group_members....
1.4
KB
-rw-r--r--
dml_rwlock_instances.result
1.08
KB
-rw-r--r--
dml_session_account_connect_at...
1.52
KB
-rw-r--r--
dml_session_connect_attrs.resu...
1.4
KB
-rw-r--r--
dml_session_status.result
1.14
KB
-rw-r--r--
dml_session_variables.result
1.18
KB
-rw-r--r--
dml_setup_actors.result
3.61
KB
-rw-r--r--
dml_setup_consumers.result
1.95
KB
-rw-r--r--
dml_setup_instruments.result
3.72
KB
-rw-r--r--
dml_setup_objects.result
3.04
KB
-rw-r--r--
dml_setup_timers.result
4.16
KB
-rw-r--r--
dml_socket_instances.result
1.08
KB
-rw-r--r--
dml_socket_summary_by_event_na...
1.52
KB
-rw-r--r--
dml_socket_summary_by_instance...
1.51
KB
-rw-r--r--
dml_status_by_account.result
1.38
KB
-rw-r--r--
dml_status_by_host.result
1.32
KB
-rw-r--r--
dml_status_by_thread.result
1.34
KB
-rw-r--r--
dml_status_by_user.result
1.32
KB
-rw-r--r--
dml_table_handles.result
1.19
KB
-rw-r--r--
dml_threads.result
1.29
KB
-rw-r--r--
dml_tiws_by_index_usage.result
1.7
KB
-rw-r--r--
dml_tiws_by_table.result
1.61
KB
-rw-r--r--
dml_tlws_by_table.result
1.64
KB
-rw-r--r--
dml_users.result
1.12
KB
-rw-r--r--
dml_uvar_by_thread.result
1.65
KB
-rw-r--r--
dml_variables_by_thread.result
1.39
KB
-rw-r--r--
event_aggregate.result
245.64
KB
-rw-r--r--
event_aggregate_no_a.result
169.86
KB
-rw-r--r--
event_aggregate_no_a_no_h.resu...
149.82
KB
-rw-r--r--
event_aggregate_no_a_no_u.resu...
110.6
KB
-rw-r--r--
event_aggregate_no_a_no_u_no_h...
90.56
KB
-rw-r--r--
event_aggregate_no_h.result
225.59
KB
-rw-r--r--
event_aggregate_no_u.result
186.38
KB
-rw-r--r--
event_aggregate_no_u_no_h.resu...
166.33
KB
-rw-r--r--
file_misc.result
62
B
-rw-r--r--
func_file_io.result
6.55
KB
-rw-r--r--
func_mutex.result
5.51
KB
-rw-r--r--
global_objects.result
1.02
KB
-rw-r--r--
global_read_lock.result
1.93
KB
-rw-r--r--
hostcache_ipv4_addrinfo_again_...
3.18
KB
-rw-r--r--
hostcache_ipv4_addrinfo_again_...
2.5
KB
-rw-r--r--
hostcache_ipv4_addrinfo_bad_al...
3.18
KB
-rw-r--r--
hostcache_ipv4_addrinfo_bad_de...
2.5
KB
-rw-r--r--
hostcache_ipv4_addrinfo_good_a...
3.31
KB
-rw-r--r--
hostcache_ipv4_addrinfo_good_d...
2.57
KB
-rw-r--r--
hostcache_ipv4_addrinfo_noname...
3.51
KB
-rw-r--r--
hostcache_ipv4_addrinfo_noname...
2.5
KB
-rw-r--r--
hostcache_ipv4_auth_plugin.res...
5.81
KB
-rw-r--r--
hostcache_ipv4_blocked.result
12.56
KB
-rw-r--r--
hostcache_ipv4_format.result
2.46
KB
-rw-r--r--
hostcache_ipv4_max_con.result
18.74
KB
-rw-r--r--
hostcache_ipv4_nameinfo_again_...
5.28
KB
-rw-r--r--
hostcache_ipv4_nameinfo_again_...
4.25
KB
-rw-r--r--
hostcache_ipv4_nameinfo_noname...
3.14
KB
-rw-r--r--
hostcache_ipv4_nameinfo_noname...
2.46
KB
-rw-r--r--
hostcache_ipv4_passwd.result
6.34
KB
-rw-r--r--
hostcache_ipv4_ssl.result
5.16
KB
-rw-r--r--
hostcache_ipv6_addrinfo_again_...
3.21
KB
-rw-r--r--
hostcache_ipv6_addrinfo_again_...
2.51
KB
-rw-r--r--
hostcache_ipv6_addrinfo_bad_al...
3.21
KB
-rw-r--r--
hostcache_ipv6_addrinfo_bad_de...
2.51
KB
-rw-r--r--
hostcache_ipv6_addrinfo_good_a...
3.32
KB
-rw-r--r--
hostcache_ipv6_addrinfo_good_d...
2.54
KB
-rw-r--r--
hostcache_ipv6_addrinfo_noname...
3.54
KB
-rw-r--r--
hostcache_ipv6_addrinfo_noname...
2.51
KB
-rw-r--r--
hostcache_ipv6_auth_plugin.res...
5.83
KB
-rw-r--r--
hostcache_ipv6_blocked.result
12.63
KB
-rw-r--r--
hostcache_ipv6_max_con.result
18.81
KB
-rw-r--r--
hostcache_ipv6_nameinfo_again_...
5.32
KB
-rw-r--r--
hostcache_ipv6_nameinfo_again_...
4.27
KB
-rw-r--r--
hostcache_ipv6_nameinfo_noname...
3.17
KB
-rw-r--r--
hostcache_ipv6_nameinfo_noname...
2.48
KB
-rw-r--r--
hostcache_ipv6_passwd.result
6.37
KB
-rw-r--r--
hostcache_ipv6_ssl.result
5.17
KB
-rw-r--r--
hostcache_peer_addr.result
1.93
KB
-rw-r--r--
indexed_table_io.result
5.89
KB
-rw-r--r--
information_schema.result
37.19
KB
-rw-r--r--
innodb_table_io.result
5.74
KB
-rw-r--r--
io_cache.result
8.78
KB
-rw-r--r--
max_program_zero.result
11.01
KB
-rw-r--r--
mdl_func.result
22.87
KB
-rw-r--r--
memory_aggregate.result
130.6
KB
-rw-r--r--
memory_aggregate_32bit.result
130.5
KB
-rw-r--r--
memory_aggregate_no_a.result
95.47
KB
-rw-r--r--
memory_aggregate_no_a_no_h.res...
82.7
KB
-rw-r--r--
memory_aggregate_no_a_no_u.res...
60.58
KB
-rw-r--r--
memory_aggregate_no_a_no_u_no_...
47.81
KB
-rw-r--r--
memory_aggregate_no_h.result
117.82
KB
-rw-r--r--
memory_aggregate_no_u.result
95.71
KB
-rw-r--r--
memory_aggregate_no_u_no_h.res...
82.93
KB
-rw-r--r--
memory_table_io.result
5.7
KB
-rw-r--r--
merge_table_io.result
7
KB
-rw-r--r--
misc.result
9.73
KB
-rw-r--r--
misc_global_status.result
2.52
KB
-rw-r--r--
multi_table_io.result
4.56
KB
-rw-r--r--
myisam_file_io.result
3.47
KB
-rw-r--r--
myisam_table_io.result
5.65
KB
-rw-r--r--
nesting.result
11.54
KB
-rw-r--r--
no_threads.result
1.82
KB
-rw-r--r--
one_thread_per_con.result
1.35
KB
-rw-r--r--
ortho_iter.result
51.59
KB
-rw-r--r--
part_table_io.result
6.54
KB
-rw-r--r--
pfs_upgrade_event.result
7.48
KB
-rw-r--r--
pfs_upgrade_func.result
7.45
KB
-rw-r--r--
pfs_upgrade_proc.result
7.46
KB
-rw-r--r--
pfs_upgrade_table.result
7.42
KB
-rw-r--r--
pfs_upgrade_view.result
7.44
KB
-rw-r--r--
prepared_statements.result
20.55
KB
-rw-r--r--
prepared_stmts_by_stored_progr...
6.38
KB
-rw-r--r--
privilege.result
36.39
KB
-rw-r--r--
privilege_table_io.result
7.44
KB
-rw-r--r--
processlist.result
8.57
KB
-rw-r--r--
processlist_57.result
13.07
KB
-rw-r--r--
processlist_acl.result
10.36
KB
-rw-r--r--
processlist_anonymous.result
2.4
KB
-rw-r--r--
processlist_no_pfs.result
8.54
KB
-rw-r--r--
processlist_port.result
5.15
KB
-rw-r--r--
processlist_reg_user.result
3.3
KB
-rw-r--r--
query_cache.result
2.28
KB
-rw-r--r--
read_only.result
5.95
KB
-rw-r--r--
relaylog.result
12.62
KB
-rw-r--r--
rollback_table_io.result
3.74
KB
-rw-r--r--
rpl_group_member_stats.result
597
B
-rw-r--r--
rpl_group_members.result
310
B
-rw-r--r--
rpl_gtid_func.result
4.42
KB
-rw-r--r--
rpl_statements.result
13.92
KB
-rw-r--r--
rpl_threads.result
2.45
KB
-rw-r--r--
schema.result
65.31
KB
-rw-r--r--
selects.result
3.68
KB
-rw-r--r--
server_init.result
4.09
KB
-rw-r--r--
setup_actors.result
6.46
KB
-rw-r--r--
setup_actors_enabled.result
5.31
KB
-rw-r--r--
setup_actors_history.result
5.26
KB
-rw-r--r--
setup_consumers_defaults.resul...
882
B
-rw-r--r--
setup_instruments_defaults.res...
2.22
KB
-rw-r--r--
setup_object_table_lock_io.res...
3.9
KB
-rw-r--r--
setup_objects.result
6.44
KB
-rw-r--r--
short_option_1.result
755
B
-rw-r--r--
short_option_2.result
356
B
-rw-r--r--
show_aggregate.result
20.89
KB
-rw-r--r--
show_coverage.result
4.1
KB
-rw-r--r--
show_misc.result
3.49
KB
-rw-r--r--
show_plugin.result
30.45
KB
-rw-r--r--
show_plugin_56.result
29.67
KB
-rw-r--r--
show_sanity.result
31.28
KB
-rw-r--r--
socket_connect.result
5.85
KB
-rw-r--r--
socket_instances_func.result
7.03
KB
-rw-r--r--
socket_instances_func_win.resu...
4.97
KB
-rw-r--r--
socket_summary_by_event_name_f...
3.9
KB
-rw-r--r--
socket_summary_by_instance_fun...
12.19
KB
-rw-r--r--
socket_summary_by_instance_fun...
12.26
KB
-rw-r--r--
stage_mdl_function.result
1.57
KB
-rw-r--r--
stage_mdl_global.result
1.75
KB
-rw-r--r--
stage_mdl_procedure.result
1.6
KB
-rw-r--r--
stage_mdl_table.result
2.1
KB
-rw-r--r--
start_server_1_digest.result
272
B
-rw-r--r--
start_server_disable_idle.resu...
9.02
KB
-rw-r--r--
start_server_disable_stages.re...
8.89
KB
-rw-r--r--
start_server_disable_statement...
10.62
KB
-rw-r--r--
start_server_disable_transacti...
9.89
KB
-rw-r--r--
start_server_disable_waits.res...
9.03
KB
-rw-r--r--
start_server_innodb.result
9.1
KB
-rw-r--r--
start_server_low_digest.result
951
B
-rw-r--r--
start_server_low_digest_sql_le...
772
B
-rw-r--r--
start_server_low_index.result
12.86
KB
-rw-r--r--
start_server_low_table_lock.re...
10.91
KB
-rw-r--r--
start_server_no_account.result
8.18
KB
-rw-r--r--
start_server_no_cond_class.res...
8.42
KB
-rw-r--r--
start_server_no_cond_inst.resu...
8.56
KB
-rw-r--r--
start_server_no_digests.result
3.47
KB
-rw-r--r--
start_server_no_file_class.res...
8.42
KB
-rw-r--r--
start_server_no_file_inst.resu...
8.55
KB
-rw-r--r--
start_server_no_host.result
8.17
KB
-rw-r--r--
start_server_no_index.result
8.96
KB
-rw-r--r--
start_server_no_mdl.result
8.23
KB
-rw-r--r--
start_server_no_memory_class.r...
12.18
KB
-rw-r--r--
start_server_no_mutex_class.re...
8.43
KB
-rw-r--r--
start_server_no_mutex_inst.res...
8.57
KB
-rw-r--r--
start_server_no_prepared_stmts...
9.41
KB
-rw-r--r--
start_server_no_rwlock_class.r...
8.44
KB
-rw-r--r--
start_server_no_rwlock_inst.re...
8.57
KB
-rw-r--r--
start_server_no_setup_actors.r...
8.05
KB
-rw-r--r--
start_server_no_setup_objects....
8.05
KB
-rw-r--r--
start_server_no_socket_class.r...
8.44
KB
-rw-r--r--
start_server_no_socket_inst.re...
8.57
KB
-rw-r--r--
start_server_no_stage_class.re...
8.64
KB
-rw-r--r--
start_server_no_stages_history...
8.13
KB
-rw-r--r--
start_server_no_stages_history...
8.15
KB
-rw-r--r--
start_server_no_statement_clas...
8.67
KB
-rw-r--r--
start_server_no_statements_his...
8.15
KB
-rw-r--r--
start_server_no_statements_his...
8.17
KB
-rw-r--r--
start_server_no_table_hdl.resu...
8.59
KB
-rw-r--r--
start_server_no_table_inst.res...
8.59
KB
-rw-r--r--
start_server_no_table_lock.res...
8.72
KB
-rw-r--r--
start_server_no_thread_class.r...
8.42
KB
-rw-r--r--
start_server_no_thread_inst.re...
8.45
KB
-rw-r--r--
start_server_no_transactions_h...
8.16
KB
-rw-r--r--
start_server_no_transactions_h...
8.17
KB
-rw-r--r--
start_server_no_user.result
8.17
KB
-rw-r--r--
start_server_no_waits_history....
8.13
KB
-rw-r--r--
start_server_no_waits_history_...
8.15
KB
-rw-r--r--
start_server_nothing.result
26.2
KB
-rw-r--r--
start_server_off.result
13.44
KB
-rw-r--r--
start_server_on.result
9.1
KB
-rw-r--r--
start_server_zero_digest_sql_l...
682
B
-rw-r--r--
statement_digest.result
6.59
KB
-rw-r--r--
statement_digest_charset.resul...
991
B
-rw-r--r--
statement_digest_consumers.res...
6.7
KB
-rw-r--r--
statement_digest_consumers2.re...
3.78
KB
-rw-r--r--
statement_digest_long_query.re...
2.9
KB
-rw-r--r--
statement_program_concurrency....
3.96
KB
-rw-r--r--
statement_program_lost_inst.re...
11.83
KB
-rw-r--r--
statement_program_nested.resul...
110.37
KB
-rw-r--r--
statement_program_nesting_even...
55.05
KB
-rw-r--r--
statement_program_non_nested.r...
25.42
KB
-rw-r--r--
status_reprepare.result
1.65
KB
-rw-r--r--
sxlock_func.result
2.5
KB
-rw-r--r--
table_aggregate_global_2u_2t.r...
63.78
KB
-rw-r--r--
table_aggregate_global_2u_3t.r...
68.29
KB
-rw-r--r--
table_aggregate_global_4u_2t.r...
63.75
KB
-rw-r--r--
table_aggregate_global_4u_3t.r...
68.27
KB
-rw-r--r--
table_aggregate_hist_2u_2t.res...
67.07
KB
-rw-r--r--
table_aggregate_hist_2u_3t.res...
73.23
KB
-rw-r--r--
table_aggregate_hist_4u_2t.res...
67.42
KB
-rw-r--r--
table_aggregate_hist_4u_3t.res...
73.65
KB
-rw-r--r--
table_aggregate_off.result
65.5
KB
-rw-r--r--
table_aggregate_thread_2u_2t.r...
63.72
KB
-rw-r--r--
table_aggregate_thread_2u_3t.r...
68.16
KB
-rw-r--r--
table_aggregate_thread_4u_2t.r...
64.05
KB
-rw-r--r--
table_aggregate_thread_4u_3t.r...
68.56
KB
-rw-r--r--
table_io_aggregate_global_2u_2...
63.77
KB
-rw-r--r--
table_io_aggregate_global_2u_3...
68.23
KB
-rw-r--r--
table_io_aggregate_global_4u_2...
63.75
KB
-rw-r--r--
table_io_aggregate_global_4u_3...
68.21
KB
-rw-r--r--
table_io_aggregate_hist_2u_2t....
65.25
KB
-rw-r--r--
table_io_aggregate_hist_2u_3t....
70.53
KB
-rw-r--r--
table_io_aggregate_hist_4u_2t....
65.51
KB
-rw-r--r--
table_io_aggregate_hist_4u_3t....
70.81
KB
-rw-r--r--
table_io_aggregate_thread_2u_2...
63.65
KB
-rw-r--r--
table_io_aggregate_thread_2u_3...
68.08
KB
-rw-r--r--
table_io_aggregate_thread_4u_2...
63.89
KB
-rw-r--r--
table_io_aggregate_thread_4u_3...
68.35
KB
-rw-r--r--
table_lock_aggregate_global_2u...
62.19
KB
-rw-r--r--
table_lock_aggregate_global_2u...
65.9
KB
-rw-r--r--
table_lock_aggregate_global_4u...
62.17
KB
-rw-r--r--
table_lock_aggregate_global_4u...
65.88
KB
-rw-r--r--
table_lock_aggregate_hist_2u_2...
63.91
KB
-rw-r--r--
table_lock_aggregate_hist_2u_3...
68.48
KB
-rw-r--r--
table_lock_aggregate_hist_4u_2...
63.99
KB
-rw-r--r--
table_lock_aggregate_hist_4u_3...
68.58
KB
-rw-r--r--
table_lock_aggregate_thread_2u...
62.23
KB
-rw-r--r--
table_lock_aggregate_thread_2u...
65.92
KB
-rw-r--r--
table_lock_aggregate_thread_4u...
62.3
KB
-rw-r--r--
table_lock_aggregate_thread_4u...
66.02
KB
-rw-r--r--
table_name.result
4.73
KB
-rw-r--r--
table_schema.result
208.92
KB
-rw-r--r--
tampered_perfschema_table1.res...
358
B
-rw-r--r--
temp_table_io.result
4.59
KB
-rw-r--r--
thread_cache.result
896
B
-rw-r--r--
thread_misc.result
62
B
-rw-r--r--
threads_history.result
15.41
KB
-rw-r--r--
threads_innodb.result
1.59
KB
-rw-r--r--
threads_mysql.result
4
KB
-rw-r--r--
threads_mysql_freebsd.result
125
B
-rw-r--r--
threads_mysql_linux.result
125
B
-rw-r--r--
threads_mysql_windows.result
125
B
-rw-r--r--
transaction.result
23.04
KB
-rw-r--r--
transaction_gtid.result
4.81
KB
-rw-r--r--
transaction_nested_events.resu...
40.69
KB
-rw-r--r--
trigger_table_io.result
7.63
KB
-rw-r--r--
unary_digest.result
2.63
KB
-rw-r--r--
user_var_func.result
2.22
KB
-rw-r--r--
view_table_io.result
5.9
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : prepared_statements.result
CREATE DATABASE db; USE db; TRUNCATE TABLE performance_schema.prepared_statements_instances ; TRUNCATE TABLE performance_schema.events_statements_history_long ; CREATE TABLE t1 (a INT NOT NULL); INSERT INTO t1 VALUES (4), (8), (11), (32), (80); PREPARE st1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse'; SET @table = 't1'; SET @s = CONCAT('SELECT * FROM ', @table); PREPARE st2 FROM @s; PREPARE st3 FROM 'INSERT INTO t1 SELECT * FROM t1 WHERE a<=?'; PREPARE st4 FROM '(SELECT a FROM t1) UNION (SELECT a+10 FROM t1) ORDER BY RAND()*0+a'; SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; STATEMENT_NAME st1 SQL_TEXT SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse COUNT_REPREPARE 0 COUNT_EXECUTE 0 SUM_ROWS_SENT 0 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 STATEMENT_NAME st2 SQL_TEXT SELECT * FROM t1 COUNT_REPREPARE 0 COUNT_EXECUTE 0 SUM_ROWS_SENT 0 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 STATEMENT_NAME st3 SQL_TEXT INSERT INTO t1 SELECT * FROM t1 WHERE a<=? COUNT_REPREPARE 0 COUNT_EXECUTE 0 SUM_ROWS_SENT 0 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 STATEMENT_NAME st4 SQL_TEXT (SELECT a FROM t1) UNION (SELECT a+10 FROM t1) ORDER BY RAND()*0+a COUNT_REPREPARE 0 COUNT_EXECUTE 0 SUM_ROWS_SENT 0 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 SELECT EVENT_NAME, SQL_TEXT, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_history_long WHERE CURRENT_SCHEMA='db' ; EVENT_NAME statement/sql/truncate SQL_TEXT TRUNCATE TABLE performance_schema.events_statements_history_long OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/create_table SQL_TEXT CREATE TABLE t1 (a INT NOT NULL) OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/insert SQL_TEXT INSERT INTO t1 VALUES (4), (8), (11), (32), (80) OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql SQL_TEXT PREPARE st1 FROM ... OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/set_option SQL_TEXT SET @table = 't1' OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/set_option SQL_TEXT SET @s = CONCAT('SELECT * FROM ', @table) OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql SQL_TEXT PREPARE st2 FROM @s OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql SQL_TEXT PREPARE st3 FROM ... OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql SQL_TEXT PREPARE st4 FROM ... OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/select SQL_TEXT SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL SET @a = 3; SET @b = 4; EXECUTE st1 USING @a, @b; hypotenuse 5 EXECUTE st2; a 4 8 11 32 80 SET @c=3; EXECUTE st3 using @c; EXECUTE st4; a 4 8 11 14 18 21 32 42 80 90 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; STATEMENT_NAME st1 SQL_TEXT SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse COUNT_REPREPARE 0 COUNT_EXECUTE 1 SUM_ROWS_SENT 1 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 STATEMENT_NAME st2 SQL_TEXT SELECT * FROM t1 COUNT_REPREPARE 0 COUNT_EXECUTE 1 SUM_ROWS_SENT 5 SUM_SELECT_SCAN 1 SUM_NO_INDEX_USED 1 STATEMENT_NAME st3 SQL_TEXT INSERT INTO t1 SELECT * FROM t1 WHERE a<=? COUNT_REPREPARE 0 COUNT_EXECUTE 1 SUM_ROWS_SENT 0 SUM_SELECT_SCAN 1 SUM_NO_INDEX_USED 1 STATEMENT_NAME st4 SQL_TEXT (SELECT a FROM t1) UNION (SELECT a+10 FROM t1) ORDER BY RAND()*0+a COUNT_REPREPARE 0 COUNT_EXECUTE 1 SUM_ROWS_SENT 10 SUM_SELECT_SCAN 3 SUM_NO_INDEX_USED 1 SELECT EVENT_NAME, SQL_TEXT, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_history_long WHERE CURRENT_SCHEMA='db' ; EVENT_NAME statement/sql/truncate SQL_TEXT TRUNCATE TABLE performance_schema.events_statements_history_long OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/create_table SQL_TEXT CREATE TABLE t1 (a INT NOT NULL) OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/insert SQL_TEXT INSERT INTO t1 VALUES (4), (8), (11), (32), (80) OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql SQL_TEXT PREPARE st1 FROM ... OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/set_option SQL_TEXT SET @table = 't1' OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/set_option SQL_TEXT SET @s = CONCAT('SELECT * FROM ', @table) OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql SQL_TEXT PREPARE st2 FROM @s OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql SQL_TEXT PREPARE st3 FROM ... OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql SQL_TEXT PREPARE st4 FROM ... OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/select SQL_TEXT SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/select SQL_TEXT SELECT EVENT_NAME, SQL_TEXT, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_history_long WHERE CURRENT_SCHEMA='db' OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/set_option SQL_TEXT SET @a = 3 OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/set_option SQL_TEXT SET @b = 4 OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/execute_sql SQL_TEXT EXECUTE st1 USING @a, @b OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/execute_sql SQL_TEXT EXECUTE st2 OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/set_option SQL_TEXT SET @c=3 OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/execute_sql SQL_TEXT EXECUTE st3 using @c OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/execute_sql SQL_TEXT EXECUTE st4 OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/select SQL_TEXT SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL TRUNCATE TABLE performance_schema.prepared_statements_instances ; SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; STATEMENT_NAME st1 SQL_TEXT SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse COUNT_REPREPARE 0 COUNT_EXECUTE 0 SUM_ROWS_SENT 0 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 STATEMENT_NAME st2 SQL_TEXT SELECT * FROM t1 COUNT_REPREPARE 0 COUNT_EXECUTE 0 SUM_ROWS_SENT 0 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 STATEMENT_NAME st3 SQL_TEXT INSERT INTO t1 SELECT * FROM t1 WHERE a<=? COUNT_REPREPARE 0 COUNT_EXECUTE 0 SUM_ROWS_SENT 0 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 STATEMENT_NAME st4 SQL_TEXT (SELECT a FROM t1) UNION (SELECT a+10 FROM t1) ORDER BY RAND()*0+a COUNT_REPREPARE 0 COUNT_EXECUTE 0 SUM_ROWS_SENT 0 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 DEALLOCATE PREPARE st1; DEALLOCATE PREPARE st2; DEALLOCATE PREPARE st3; DEALLOCATE PREPARE st4; DROP TABLE t1; SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; SELECT EVENT_NAME, SQL_TEXT, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_history_long WHERE CURRENT_SCHEMA='db' ; EVENT_NAME statement/sql/truncate SQL_TEXT TRUNCATE TABLE performance_schema.events_statements_history_long OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/create_table SQL_TEXT CREATE TABLE t1 (a INT NOT NULL) OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/insert SQL_TEXT INSERT INTO t1 VALUES (4), (8), (11), (32), (80) OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql SQL_TEXT PREPARE st1 FROM ... OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/set_option SQL_TEXT SET @table = 't1' OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/set_option SQL_TEXT SET @s = CONCAT('SELECT * FROM ', @table) OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql SQL_TEXT PREPARE st2 FROM @s OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql SQL_TEXT PREPARE st3 FROM ... OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql SQL_TEXT PREPARE st4 FROM ... OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/select SQL_TEXT SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/select SQL_TEXT SELECT EVENT_NAME, SQL_TEXT, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_history_long WHERE CURRENT_SCHEMA='db' OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/set_option SQL_TEXT SET @a = 3 OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/set_option SQL_TEXT SET @b = 4 OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/execute_sql SQL_TEXT EXECUTE st1 USING @a, @b OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/execute_sql SQL_TEXT EXECUTE st2 OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/set_option SQL_TEXT SET @c=3 OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/execute_sql SQL_TEXT EXECUTE st3 using @c OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/execute_sql SQL_TEXT EXECUTE st4 OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/select SQL_TEXT SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/select SQL_TEXT SELECT EVENT_NAME, SQL_TEXT, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_history_long WHERE CURRENT_SCHEMA='db' OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/truncate SQL_TEXT TRUNCATE TABLE performance_schema.prepared_statements_instances OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/select SQL_TEXT SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/dealloc_sql SQL_TEXT DEALLOCATE PREPARE st1 OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/dealloc_sql SQL_TEXT DEALLOCATE PREPARE st2 OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/dealloc_sql SQL_TEXT DEALLOCATE PREPARE st3 OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/dealloc_sql SQL_TEXT DEALLOCATE PREPARE st4 OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/drop_table SQL_TEXT DROP TABLE t1 OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/select SQL_TEXT SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL TRUNCATE TABLE performance_schema.events_statements_history_long ; UPDATE performance_schema.setup_consumers SET ENABLED = 'NO'; CREATE TABLE t1 (a INT NOT NULL); INSERT INTO t1 VALUES (4), (8), (11), (32), (80); PREPARE st1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse'; SET @table = 't1'; SET @s = CONCAT('SELECT * FROM ', @table); PREPARE st2 FROM @s; PREPARE st3 FROM 'INSERT INTO t1 SELECT * FROM t1 WHERE a<=?'; PREPARE st4 FROM '(SELECT a FROM t1) UNION (SELECT a+10 FROM t1) ORDER BY RAND()*0+a'; SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; SELECT EVENT_NAME, SQL_TEXT, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_history_long WHERE CURRENT_SCHEMA='db' ; EVENT_NAME statement/sql/truncate SQL_TEXT TRUNCATE TABLE performance_schema.events_statements_history_long OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL SET @a = 3; SET @b = 4; EXECUTE st1 USING @a, @b; hypotenuse 5 EXECUTE st2; a 4 8 11 32 80 SET @c=3; EXECUTE st3 using @c; EXECUTE st4; a 4 8 11 14 18 21 32 42 80 90 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; SELECT EVENT_NAME, SQL_TEXT, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_history_long WHERE CURRENT_SCHEMA='db' ; EVENT_NAME statement/sql/truncate SQL_TEXT TRUNCATE TABLE performance_schema.events_statements_history_long OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL DEALLOCATE PREPARE st1; DEALLOCATE PREPARE st2; DEALLOCATE PREPARE st3; DEALLOCATE PREPARE st4; DROP TABLE t1; SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; SELECT EVENT_NAME, SQL_TEXT, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_history_long WHERE CURRENT_SCHEMA='db' ; EVENT_NAME statement/sql/truncate SQL_TEXT TRUNCATE TABLE performance_schema.events_statements_history_long OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL TRUNCATE TABLE performance_schema.events_statements_history_long ; UPDATE performance_schema.setup_consumers SET ENABLED = 'YES'; PREPARE st FROM 'SELECT SUM(1000 + ?) AS total'; SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; STATEMENT_NAME st SQL_TEXT SELECT SUM(1000 + ?) AS total COUNT_REPREPARE 0 COUNT_EXECUTE 0 SUM_ROWS_SENT 0 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 SET @d=100; EXECUTE st USING @d; total 1100 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; STATEMENT_NAME st SQL_TEXT SELECT SUM(1000 + ?) AS total COUNT_REPREPARE 0 COUNT_EXECUTE 1 SUM_ROWS_SENT 1 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 SET @d = @d + 100; EXECUTE st USING @d; total 1200 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; STATEMENT_NAME st SQL_TEXT SELECT SUM(1000 + ?) AS total COUNT_REPREPARE 0 COUNT_EXECUTE 2 SUM_ROWS_SENT 2 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 SET @d = @d + 100; EXECUTE st USING @d; total 1300 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; STATEMENT_NAME st SQL_TEXT SELECT SUM(1000 + ?) AS total COUNT_REPREPARE 0 COUNT_EXECUTE 3 SUM_ROWS_SENT 3 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 SET @d = @d + 100; EXECUTE st USING @d; total 1400 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; STATEMENT_NAME st SQL_TEXT SELECT SUM(1000 + ?) AS total COUNT_REPREPARE 0 COUNT_EXECUTE 4 SUM_ROWS_SENT 4 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 SET @d = @d + 100; EXECUTE st USING @d; total 1500 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; STATEMENT_NAME st SQL_TEXT SELECT SUM(1000 + ?) AS total COUNT_REPREPARE 0 COUNT_EXECUTE 5 SUM_ROWS_SENT 5 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 SET @d = @d + 100; EXECUTE st USING @d; total 1600 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; STATEMENT_NAME st SQL_TEXT SELECT SUM(1000 + ?) AS total COUNT_REPREPARE 0 COUNT_EXECUTE 6 SUM_ROWS_SENT 6 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 TRUNCATE TABLE performance_schema.prepared_statements_instances ; SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; STATEMENT_NAME st SQL_TEXT SELECT SUM(1000 + ?) AS total COUNT_REPREPARE 0 COUNT_EXECUTE 0 SUM_ROWS_SENT 0 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 UPDATE performance_schema.setup_instruments SET ENABLED = 'NO' WHERE NAME like "statement/sql/execute%"; SET @d=3274; EXECUTE st USING @d; total 4274 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; STATEMENT_NAME st SQL_TEXT SELECT SUM(1000 + ?) AS total COUNT_REPREPARE 0 COUNT_EXECUTE 0 SUM_ROWS_SENT 0 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 UPDATE performance_schema.setup_instruments SET ENABLED = 'NO' WHERE NAME like "statement/sql/prepare%"; DEALLOCATE PREPARE st; SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; UPDATE performance_schema.setup_instruments SET ENABLED = 'YES' WHERE NAME like "statement/sql/prepare%"; UPDATE performance_schema.setup_instruments SET ENABLED = 'YES' WHERE NAME like "statement/sql/execute%"; CREATE TABLE tab( Id INT, name CHAR(10), age INT ); INSERT INTO tab VALUES(1,"Nakshatr",25),(2,"chanda",24),(3,"tejas",78); PREPARE st FROM 'SELECT * FROM tab'; SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; STATEMENT_NAME st SQL_TEXT SELECT * FROM tab COUNT_REPREPARE 0 COUNT_EXECUTE 0 SUM_ROWS_SENT 0 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 EXECUTE st; Id name age 1 Nakshatr 25 2 chanda 24 3 tejas 78 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; STATEMENT_NAME st SQL_TEXT SELECT * FROM tab COUNT_REPREPARE 0 COUNT_EXECUTE 1 SUM_ROWS_SENT 3 SUM_SELECT_SCAN 1 SUM_NO_INDEX_USED 1 ALTER TABLE tab DROP COLUMN age; EXECUTE st; Id name 1 Nakshatr 2 chanda 3 tejas SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; STATEMENT_NAME st SQL_TEXT SELECT * FROM tab COUNT_REPREPARE 1 COUNT_EXECUTE 2 SUM_ROWS_SENT 6 SUM_SELECT_SCAN 2 SUM_NO_INDEX_USED 2 ALTER TABLE tab ADD COLUMN age INT NULL; EXECUTE st; Id name age 1 Nakshatr NULL 2 chanda NULL 3 tejas NULL SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; STATEMENT_NAME st SQL_TEXT SELECT * FROM tab COUNT_REPREPARE 2 COUNT_EXECUTE 3 SUM_ROWS_SENT 9 SUM_SELECT_SCAN 3 SUM_NO_INDEX_USED 3 TRUNCATE TABLE performance_schema.prepared_statements_instances ; SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; STATEMENT_NAME st SQL_TEXT SELECT * FROM tab COUNT_REPREPARE 0 COUNT_EXECUTE 0 SUM_ROWS_SENT 0 SUM_SELECT_SCAN 0 SUM_NO_INDEX_USED 0 DEALLOCATE PREPARE st; SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ; TRUNCATE TABLE performance_schema.prepared_statements_instances ; TRUNCATE TABLE performance_schema.events_statements_history_long ; DROP TABLE tab; DROP DATABASE db;
Close