From 06eaf7232e9a920468c0f8d74dcf2fe8b555501c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 14:24:36 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- mysql-test/suite/perfschema/disabled.def | 65 + .../suite/perfschema/include/binlog_common.inc | 41 + .../perfschema/include/binlog_edge_common.inc | 188 + .../suite/perfschema/include/binlog_ok_common.inc | 146 + .../suite/perfschema/include/cleanup_helper.inc | 17 + .../perfschema/include/connection_cleanup.inc | 27 + .../suite/perfschema/include/connection_load.inc | 245 + .../suite/perfschema/include/connection_setup.inc | 114 + .../perfschema/include/default_mysqld_autosize.cnf | 52 + .../suite/perfschema/include/digest_cleanup.inc | 14 + .../suite/perfschema/include/digest_execution.inc | 130 + .../suite/perfschema/include/digest_setup.inc | 24 + .../perfschema/include/disable_instruments.inc | 23 + .../perfschema/include/enable_instruments.inc | 23 + .../perfschema/include/event_aggregate_cleanup.inc | 64 + .../perfschema/include/event_aggregate_load.inc | 1197 ++++ .../perfschema/include/event_aggregate_setup.inc | 413 ++ .../perfschema/include/have_aligned_memory.inc | 10 + .../suite/perfschema/include/have_timer_cycle.inc | 4 + .../suite/perfschema/include/hostcache_dump.inc | 39 + .../perfschema/include/hostcache_set_state.inc | 22 + .../include/memory_aggregate_cleanup.inc | 45 + .../perfschema/include/memory_aggregate_load.inc | 506 ++ .../perfschema/include/memory_aggregate_setup.inc | 208 + .../include/pfs_no_running_event_scheduler.inc | 10 + .../include/pfs_running_event_scheduler.inc | 10 + .../suite/perfschema/include/pfs_upgrade.inc | 112 + .../include/prepared_stmts_deallocation.inc | 11 + .../include/prepared_stmts_execution.inc | 18 + .../perfschema/include/prepared_stmts_setup.inc | 20 + mysql-test/suite/perfschema/include/privilege.inc | 164 + .../suite/perfschema/include/processlist_load.inc | 39 + .../suite/perfschema/include/processlist_set.inc | 17 + .../suite/perfschema/include/program_cleanup.inc | 31 + .../suite/perfschema/include/program_execution.inc | 54 + .../perfschema/include/program_nested_cleanup.inc | 21 + .../include/program_nested_execution.inc | 22 + .../perfschema/include/program_nested_setup.inc | 87 + .../suite/perfschema/include/program_setup.inc | 136 + .../perfschema/include/reset_transaction_gtid.inc | 20 + .../perfschema/include/rpl_statements_truncate.inc | 15 + mysql-test/suite/perfschema/include/schema.inc | 76 + .../suite/perfschema/include/setup_helper.inc | 39 + .../suite/perfschema/include/show_aggregate.inc | 125 + .../perfschema/include/show_plugin_verifier.inc | 29 + .../perfschema/include/show_transaction_gtid.inc | 29 + .../suite/perfschema/include/socket_check1.inc | 129 + .../suite/perfschema/include/socket_event.inc | 236 + .../suite/perfschema/include/socket_event_dbg.inc | 130 + .../suite/perfschema/include/socket_ipv6.inc | 117 + .../perfschema/include/socket_summary_check.inc | 227 + .../include/socket_summary_check_dbg.inc | 236 + .../suite/perfschema/include/stage_cleanup.inc | 31 + .../suite/perfschema/include/stage_setup.inc | 140 + .../perfschema/include/start_server_common.inc | 120 + .../perfschema/include/table_aggregate_cleanup.inc | 53 + .../perfschema/include/table_aggregate_load.inc | 532 ++ .../perfschema/include/table_aggregate_setup.inc | 273 + .../perfschema/include/table_io_basic_dml.inc | 37 + .../perfschema/include/table_io_cleanup_helper.inc | 10 + .../perfschema/include/table_io_result_helper.inc | 22 + .../perfschema/include/table_io_setup_helper.inc | 58 + .../perfschema/include/transaction_cleanup.inc | 12 + .../include/transaction_nested_events_verifier.inc | 145 + .../suite/perfschema/include/transaction_setup.inc | 231 + .../suite/perfschema/include/upgrade_check.inc | 15 + .../include/wait_for_pfs_thread_count.inc | 9 + .../suite/perfschema/include/wait_till_sleep.inc | 19 + mysql-test/suite/perfschema/r/all_tests.result | 24 + .../suite/perfschema/r/alter_table_progress.result | 100 + mysql-test/suite/perfschema/r/bad_option.result | 8 + .../suite/perfschema/r/batch_table_io_func.result | 195 + .../suite/perfschema/r/binlog_edge_mix.result | 178 + .../suite/perfschema/r/binlog_edge_row.result | 183 + .../suite/perfschema/r/binlog_edge_stmt.result | 258 + mysql-test/suite/perfschema/r/binlog_mix.result | 54 + mysql-test/suite/perfschema/r/binlog_ok_mix.result | 119 + mysql-test/suite/perfschema/r/binlog_ok_row.result | 119 + .../suite/perfschema/r/binlog_ok_stmt.result | 119 + mysql-test/suite/perfschema/r/binlog_row.result | 54 + mysql-test/suite/perfschema/r/binlog_stmt.result | 55 + mysql-test/suite/perfschema/r/checksum.result | 106 + mysql-test/suite/perfschema/r/cnf_option.result | 6 + .../suite/perfschema/r/column_privilege.result | 30 + mysql-test/suite/perfschema/r/connect_attrs.result | 59 + mysql-test/suite/perfschema/r/connection.result | 908 +++ mysql-test/suite/perfschema/r/connection_3a.result | 853 +++ .../suite/perfschema/r/connection_3a_3u.result | 795 +++ mysql-test/suite/perfschema/r/connection_3u.result | 850 +++ .../perfschema/r/connection_type_notwin.result | 79 + .../suite/perfschema/r/connection_type_win.result | 77 + mysql-test/suite/perfschema/r/csv_table_io.result | 145 + mysql-test/suite/perfschema/r/ddl_accounts.result | 8 + .../suite/perfschema/r/ddl_cond_instances.result | 8 + .../r/ddl_esgs_by_account_by_event_name.result | 10 + .../r/ddl_esgs_by_host_by_event_name.result | 10 + .../r/ddl_esgs_by_thread_by_event_name.result | 9 + .../r/ddl_esgs_by_user_by_event_name.result | 10 + .../r/ddl_esgs_global_by_event_name.result | 10 + .../r/ddl_esms_by_account_by_event_name.result | 10 + .../suite/perfschema/r/ddl_esms_by_digest.result | 9 + .../r/ddl_esms_by_host_by_event_name.result | 10 + .../suite/perfschema/r/ddl_esms_by_program.result | 9 + .../r/ddl_esms_by_thread_by_event_name.result | 9 + .../r/ddl_esms_by_user_by_event_name.result | 10 + .../r/ddl_esms_global_by_event_name.result | 10 + .../r/ddl_ets_by_account_by_event_name.result | 10 + .../r/ddl_ets_by_host_by_event_name.result | 10 + .../r/ddl_ets_by_thread_by_event_name.result | 9 + .../r/ddl_ets_by_user_by_event_name.result | 10 + .../r/ddl_ets_global_by_event_name.result | 10 + .../perfschema/r/ddl_events_stages_current.result | 10 + .../perfschema/r/ddl_events_stages_history.result | 10 + .../r/ddl_events_stages_history_long.result | 10 + .../r/ddl_events_statements_current.result | 7 + .../r/ddl_events_statements_history.result | 7 + .../r/ddl_events_statements_history_long.result | 7 + .../r/ddl_events_transactions_current.result | 7 + .../r/ddl_events_transactions_history.result | 7 + .../r/ddl_events_transactions_history_long.result | 7 + .../perfschema/r/ddl_events_waits_current.result | 7 + .../perfschema/r/ddl_events_waits_history.result | 7 + .../r/ddl_events_waits_history_long.result | 7 + .../r/ddl_ews_by_account_by_event_name.result | 10 + .../r/ddl_ews_by_host_by_event_name.result | 10 + .../suite/perfschema/r/ddl_ews_by_instance.result | 7 + .../r/ddl_ews_by_thread_by_event_name.result | 9 + .../r/ddl_ews_by_user_by_event_name.result | 10 + .../r/ddl_ews_global_by_event_name.result | 10 + .../suite/perfschema/r/ddl_file_instances.result | 8 + .../suite/perfschema/r/ddl_fs_by_event_name.result | 7 + .../suite/perfschema/r/ddl_fs_by_instance.result | 7 + .../suite/perfschema/r/ddl_global_status.result | 10 + .../suite/perfschema/r/ddl_global_variables.result | 11 + .../suite/perfschema/r/ddl_host_cache.result | 7 + mysql-test/suite/perfschema/r/ddl_hosts.result | 8 + .../r/ddl_mems_by_account_by_event_name.result | 10 + .../r/ddl_mems_by_host_by_event_name.result | 10 + .../r/ddl_mems_by_thread_by_event_name.result | 10 + .../r/ddl_mems_by_user_by_event_name.result | 10 + .../r/ddl_mems_global_by_event_name.result | 10 + .../suite/perfschema/r/ddl_metadata_locks.result | 8 + .../suite/perfschema/r/ddl_mutex_instances.result | 8 + .../perfschema/r/ddl_os_global_by_type.result | 10 + .../perfschema/r/ddl_performance_timers.result | 8 + .../r/ddl_prepared_statements_instances.result | 9 + .../suite/perfschema/r/ddl_processlist.result | 20 + .../r/ddl_replication_applier_configuration.result | 11 + .../r/ddl_replication_applier_status.result | 11 + ...eplication_applier_status_by_coordinator.result | 11 + ...ddl_replication_applier_status_by_worker.result | 11 + ...ddl_replication_connection_configuration.result | 11 + .../r/ddl_replication_connection_status.result | 11 + .../r/ddl_replication_group_member_stats.result | 11 + .../r/ddl_replication_group_members.result | 11 + .../suite/perfschema/r/ddl_rwlock_instances.result | 8 + .../r/ddl_session_account_connect_attrs.result | 9 + .../perfschema/r/ddl_session_connect_attrs.result | 9 + .../suite/perfschema/r/ddl_session_status.result | 11 + .../perfschema/r/ddl_session_variables.result | 11 + .../suite/perfschema/r/ddl_setup_actors.result | 18 + .../suite/perfschema/r/ddl_setup_consumers.result | 8 + .../perfschema/r/ddl_setup_instruments.result | 8 + .../suite/perfschema/r/ddl_setup_objects.result | 16 + .../suite/perfschema/r/ddl_setup_timers.result | 8 + .../suite/perfschema/r/ddl_socket_instances.result | 8 + .../r/ddl_socket_summary_by_event_name.result | 7 + .../r/ddl_socket_summary_by_instance.result | 7 + .../perfschema/r/ddl_status_by_account.result | 10 + .../suite/perfschema/r/ddl_status_by_host.result | 10 + .../suite/perfschema/r/ddl_status_by_thread.result | 10 + .../suite/perfschema/r/ddl_status_by_user.result | 10 + .../suite/perfschema/r/ddl_table_handles.result | 8 + mysql-test/suite/perfschema/r/ddl_threads.result | 8 + .../perfschema/r/ddl_tiws_by_index_usage.result | 8 + .../suite/perfschema/r/ddl_tiws_by_table.result | 8 + .../suite/perfschema/r/ddl_tlws_by_table.result | 8 + mysql-test/suite/perfschema/r/ddl_users.result | 8 + .../suite/perfschema/r/ddl_uvar_by_thread.result | 11 + .../perfschema/r/ddl_variables_by_thread.result | 11 + .../suite/perfschema/r/digest_null_literal.result | 27 + .../suite/perfschema/r/digest_table_full.result | 134 + mysql-test/suite/perfschema/r/digest_view.result | 266 + mysql-test/suite/perfschema/r/discovery.result | 12 + mysql-test/suite/perfschema/r/dml_accounts.result | 36 + .../suite/perfschema/r/dml_cond_instances.result | 29 + .../r/dml_esgs_by_account_by_event_name.result | 41 + .../r/dml_esgs_by_host_by_event_name.result | 40 + .../r/dml_esgs_by_thread_by_event_name.result | 40 + .../r/dml_esgs_by_user_by_event_name.result | 40 + .../r/dml_esgs_global_by_event_name.result | 38 + .../r/dml_esms_by_account_by_event_name.result | 60 + .../suite/perfschema/r/dml_esms_by_digest.result | 63 + .../r/dml_esms_by_host_by_event_name.result | 59 + .../suite/perfschema/r/dml_esms_by_program.result | 27 + .../r/dml_esms_by_thread_by_event_name.result | 59 + .../r/dml_esms_by_user_by_event_name.result | 59 + .../r/dml_esms_global_by_event_name.result | 57 + .../r/dml_ets_by_account_by_event_name.result | 26 + .../r/dml_ets_by_host_by_event_name.result | 26 + .../r/dml_ets_by_thread_by_event_name.result | 26 + .../r/dml_ets_by_user_by_event_name.result | 26 + .../r/dml_ets_global_by_event_name.result | 25 + .../perfschema/r/dml_events_stages_current.result | 44 + .../perfschema/r/dml_events_stages_history.result | 48 + .../r/dml_events_stages_history_long.result | 48 + .../r/dml_events_statements_current.result | 73 + .../r/dml_events_statements_history.result | 77 + .../r/dml_events_statements_history_long.result | 77 + .../r/dml_events_transactions_current.result | 25 + .../r/dml_events_transactions_history.result | 29 + .../r/dml_events_transactions_history_long.result | 29 + .../perfschema/r/dml_events_waits_current.result | 51 + .../perfschema/r/dml_events_waits_history.result | 55 + .../r/dml_events_waits_history_long.result | 55 + .../r/dml_ews_by_account_by_event_name.result | 44 + .../r/dml_ews_by_host_by_event_name.result | 43 + .../suite/perfschema/r/dml_ews_by_instance.result | 48 + .../r/dml_ews_by_thread_by_event_name.result | 40 + .../r/dml_ews_by_user_by_event_name.result | 43 + .../r/dml_ews_global_by_event_name.result | 38 + .../suite/perfschema/r/dml_file_instances.result | 99 + .../suite/perfschema/r/dml_fs_by_event_name.result | 55 + .../suite/perfschema/r/dml_fs_by_instance.result | 57 + .../suite/perfschema/r/dml_global_status.result | 21 + .../suite/perfschema/r/dml_global_variables.result | 21 + mysql-test/suite/perfschema/r/dml_handler.result | 258 + .../suite/perfschema/r/dml_host_cache.result | 63 + mysql-test/suite/perfschema/r/dml_hosts.result | 35 + .../r/dml_mems_by_account_by_event_name.result | 46 + .../r/dml_mems_by_host_by_event_name.result | 45 + .../r/dml_mems_by_thread_by_event_name.result | 26 + .../r/dml_mems_by_user_by_event_name.result | 45 + .../r/dml_mems_global_by_event_name.result | 44 + .../suite/perfschema/r/dml_metadata_locks.result | 38 + .../suite/perfschema/r/dml_mutex_instances.result | 30 + .../perfschema/r/dml_os_global_by_type.result | 60 + .../perfschema/r/dml_performance_timers.result | 40 + .../r/dml_prepared_statements_instances.result | 26 + .../suite/perfschema/r/dml_processlist.result | 24 + .../r/dml_replication_applier_configuration.result | 21 + .../r/dml_replication_applier_status.result | 24 + ...eplication_applier_status_by_coordinator.result | 25 + ...dml_replication_applier_status_by_worker.result | 41 + ...dml_replication_connection_configuration.result | 25 + .../r/dml_replication_connection_status.result | 25 + .../r/dml_replication_group_member_stats.result | 26 + .../r/dml_replication_group_members.result | 24 + .../suite/perfschema/r/dml_rwlock_instances.result | 31 + .../r/dml_session_account_connect_attrs.result | 36 + .../perfschema/r/dml_session_connect_attrs.result | 36 + .../suite/perfschema/r/dml_session_status.result | 21 + .../perfschema/r/dml_session_variables.result | 21 + .../suite/perfschema/r/dml_setup_actors.result | 116 + .../suite/perfschema/r/dml_setup_consumers.result | 68 + .../perfschema/r/dml_setup_instruments.result | 97 + .../suite/perfschema/r/dml_setup_objects.result | 84 + .../suite/perfschema/r/dml_setup_timers.result | 111 + .../suite/perfschema/r/dml_socket_instances.result | 34 + .../r/dml_socket_summary_by_event_name.result | 56 + .../r/dml_socket_summary_by_instance.result | 57 + .../perfschema/r/dml_status_by_account.result | 24 + .../suite/perfschema/r/dml_status_by_host.result | 24 + .../suite/perfschema/r/dml_status_by_thread.result | 24 + .../suite/perfschema/r/dml_status_by_user.result | 24 + .../suite/perfschema/r/dml_table_handles.result | 21 + mysql-test/suite/perfschema/r/dml_threads.result | 58 + .../perfschema/r/dml_tiws_by_index_usage.result | 72 + .../suite/perfschema/r/dml_tiws_by_table.result | 71 + .../suite/perfschema/r/dml_tlws_by_table.result | 106 + mysql-test/suite/perfschema/r/dml_users.result | 35 + .../suite/perfschema/r/dml_uvar_by_thread.result | 30 + .../perfschema/r/dml_variables_by_thread.result | 24 + .../suite/perfschema/r/event_aggregate.result | 6911 ++++++++++++++++++++ .../suite/perfschema/r/event_aggregate_no_a.result | 5251 +++++++++++++++ .../perfschema/r/event_aggregate_no_a_no_h.result | 4747 ++++++++++++++ .../perfschema/r/event_aggregate_no_a_no_u.result | 3535 ++++++++++ .../r/event_aggregate_no_a_no_u_no_h.result | 3031 +++++++++ .../suite/perfschema/r/event_aggregate_no_h.result | 6407 ++++++++++++++++++ .../suite/perfschema/r/event_aggregate_no_u.result | 5195 +++++++++++++++ .../perfschema/r/event_aggregate_no_u_no_h.result | 4691 +++++++++++++ mysql-test/suite/perfschema/r/file_misc.result | 1 + mysql-test/suite/perfschema/r/func_file_io.result | 164 + mysql-test/suite/perfschema/r/func_mutex.result | 139 + .../suite/perfschema/r/global_objects.result | 33 + .../suite/perfschema/r/global_read_lock.result | 39 + mysql-test/suite/perfschema/r/grant.result | 7 + .../r/hostcache_ipv4_addrinfo_again_allow.result | 103 + .../r/hostcache_ipv4_addrinfo_again_deny.result | 85 + .../r/hostcache_ipv4_addrinfo_bad_allow.result | 103 + .../r/hostcache_ipv4_addrinfo_bad_deny.result | 85 + .../r/hostcache_ipv4_addrinfo_good_allow.result | 103 + .../r/hostcache_ipv4_addrinfo_good_deny.result | 85 + .../r/hostcache_ipv4_addrinfo_noname_allow.result | 107 + .../r/hostcache_ipv4_addrinfo_noname_deny.result | 85 + .../r/hostcache_ipv4_auth_ed25519.result | 121 + .../perfschema/r/hostcache_ipv4_auth_plugin.result | 199 + .../perfschema/r/hostcache_ipv4_blocked.result | 431 ++ .../perfschema/r/hostcache_ipv4_format.result | 85 + .../perfschema/r/hostcache_ipv4_max_con.result | 706 ++ .../r/hostcache_ipv4_nameinfo_again_allow.result | 182 + .../r/hostcache_ipv4_nameinfo_again_deny.result | 146 + .../r/hostcache_ipv4_nameinfo_noname_allow.result | 103 + .../r/hostcache_ipv4_nameinfo_noname_deny.result | 85 + .../perfschema/r/hostcache_ipv4_passwd.result | 211 + .../suite/perfschema/r/hostcache_ipv4_ssl.result | 155 + .../r/hostcache_ipv6_addrinfo_again_allow.result | 103 + .../r/hostcache_ipv6_addrinfo_again_deny.result | 85 + .../r/hostcache_ipv6_addrinfo_bad_allow.result | 103 + .../r/hostcache_ipv6_addrinfo_bad_deny.result | 85 + .../r/hostcache_ipv6_addrinfo_good_allow.result | 103 + .../r/hostcache_ipv6_addrinfo_good_deny.result | 84 + .../r/hostcache_ipv6_addrinfo_noname_allow.result | 107 + .../r/hostcache_ipv6_addrinfo_noname_deny.result | 85 + .../perfschema/r/hostcache_ipv6_auth_plugin.result | 199 + .../perfschema/r/hostcache_ipv6_blocked.result | 431 ++ .../perfschema/r/hostcache_ipv6_max_con.result | 706 ++ .../r/hostcache_ipv6_nameinfo_again_allow.result | 182 + .../r/hostcache_ipv6_nameinfo_again_deny.result | 146 + .../r/hostcache_ipv6_nameinfo_noname_allow.result | 103 + .../r/hostcache_ipv6_nameinfo_noname_deny.result | 85 + .../perfschema/r/hostcache_ipv6_passwd.result | 211 + .../suite/perfschema/r/hostcache_ipv6_ssl.result | 155 + .../suite/perfschema/r/hostcache_peer_addr.result | 63 + .../suite/perfschema/r/indexed_table_io.result | 166 + .../suite/perfschema/r/information_schema.result | 867 +++ .../innodb_events_transactions_history_long.result | 16 + .../suite/perfschema/r/innodb_table_io.result | 146 + mysql-test/suite/perfschema/r/io_cache.result | 96 + .../suite/perfschema/r/max_program_zero.result | 314 + mysql-test/suite/perfschema/r/mdl_func.result | 920 +++ .../suite/perfschema/r/memory_aggregate.result | 5602 ++++++++++++++++ .../perfschema/r/memory_aggregate_32bit.result | 5602 ++++++++++++++++ .../perfschema/r/memory_aggregate_no_a.result | 4014 ++++++++++++ .../perfschema/r/memory_aggregate_no_a_no_h.result | 3464 ++++++++++ .../perfschema/r/memory_aggregate_no_a_no_u.result | 2442 +++++++ .../r/memory_aggregate_no_a_no_u_no_h.result | 1892 ++++++ .../perfschema/r/memory_aggregate_no_h.result | 5052 ++++++++++++++ .../perfschema/r/memory_aggregate_no_u.result | 4030 ++++++++++++ .../perfschema/r/memory_aggregate_no_u_no_h.result | 3480 ++++++++++ .../suite/perfschema/r/memory_table_io.result | 145 + .../suite/perfschema/r/merge_table_io.result | 177 + mysql-test/suite/perfschema/r/misc.result | 189 + .../suite/perfschema/r/misc_global_status.result | 106 + .../suite/perfschema/r/mks_timer-6258.result | 3 + .../suite/perfschema/r/multi_table_io.result | 116 + .../suite/perfschema/r/myisam_file_io.result | 79 + .../suite/perfschema/r/myisam_table_io.result | 145 + mysql-test/suite/perfschema/r/nesting.result | 274 + mysql-test/suite/perfschema/r/no_threads.result | 47 + .../suite/perfschema/r/one_thread_per_con.result | 49 + mysql-test/suite/perfschema/r/ortho_iter.result | 1508 +++++ mysql-test/suite/perfschema/r/part_table_io.result | 147 + mysql-test/suite/perfschema/r/partition.result | 10 + .../suite/perfschema/r/pfs_upgrade_event.result | 11 + .../suite/perfschema/r/pfs_upgrade_func.result | 9 + .../suite/perfschema/r/pfs_upgrade_proc.result | 9 + .../suite/perfschema/r/pfs_upgrade_table.result | 11 + .../suite/perfschema/r/pfs_upgrade_view.result | 11 + .../suite/perfschema/r/prepared_statements.result | 672 ++ .../r/prepared_stmts_by_stored_programs.result | 126 + mysql-test/suite/perfschema/r/privilege.result | 616 ++ .../suite/perfschema/r/privilege_table_io.result | 178 + mysql-test/suite/perfschema/r/processlist.result | 201 + .../suite/perfschema/r/processlist_57.result | 345 + .../suite/perfschema/r/processlist_acl.result | 255 + .../perfschema/r/processlist_anonymous.result | 66 + .../suite/perfschema/r/processlist_no_pfs.result | 181 + .../suite/perfschema/r/processlist_port.result | 145 + .../suite/perfschema/r/processlist_reg_user.result | 89 + mysql-test/suite/perfschema/r/query_cache.result | 73 + mysql-test/suite/perfschema/r/read_only.result | 53 + mysql-test/suite/perfschema/r/relaylog.result | 207 + .../suite/perfschema/r/rollback_table_io.result | 97 + .../perfschema/r/rpl_group_member_stats.result | 8 + .../suite/perfschema/r/rpl_group_members.result | 5 + mysql-test/suite/perfschema/r/rpl_gtid_func.result | 128 + .../suite/perfschema/r/rpl_statements.result | 223 + mysql-test/suite/perfschema/r/rpl_threads.result | 61 + mysql-test/suite/perfschema/r/schema.result | 1386 ++++ mysql-test/suite/perfschema/r/selects.result | 117 + mysql-test/suite/perfschema/r/server_init.result | 156 + mysql-test/suite/perfschema/r/setup_actors.result | 141 + .../suite/perfschema/r/setup_actors_enabled.result | 136 + .../suite/perfschema/r/setup_actors_history.result | 138 + .../perfschema/r/setup_consumers_defaults.result | 23 + .../perfschema/r/setup_instruments_defaults.result | 74 + .../perfschema/r/setup_object_table_lock_io.result | 91 + mysql-test/suite/perfschema/r/setup_objects.result | 209 + .../suite/perfschema/r/short_option_1.result | 18 + .../suite/perfschema/r/short_option_2.result | 9 + .../suite/perfschema/r/show_aggregate.result | 525 ++ mysql-test/suite/perfschema/r/show_coverage.result | 142 + mysql-test/suite/perfschema/r/show_misc.result | 74 + mysql-test/suite/perfschema/r/show_plugin.result | 626 ++ mysql-test/suite/perfschema/r/show_sanity.result | 859 +++ .../suite/perfschema/r/socket_connect.result | 171 + .../perfschema/r/socket_instances_func.result | 217 + .../perfschema/r/socket_instances_func_win.result | 144 + .../r/socket_summary_by_event_name_func.result | 131 + .../r/socket_summary_by_instance_func.result | 226 + .../r/socket_summary_by_instance_func_win.result | 232 + .../suite/perfschema/r/stage_mdl_function.result | 32 + .../suite/perfschema/r/stage_mdl_global.result | 34 + .../suite/perfschema/r/stage_mdl_procedure.result | 40 + .../suite/perfschema/r/stage_mdl_table.result | 48 + .../perfschema/r/start_server_1_digest.result | 7 + .../perfschema/r/start_server_disable_idle.result | 168 + .../r/start_server_disable_stages.result | 168 + .../r/start_server_disable_statements.result | 168 + .../r/start_server_disable_transactions.result | 168 + .../perfschema/r/start_server_disable_waits.result | 168 + .../suite/perfschema/r/start_server_innodb.result | 182 + .../perfschema/r/start_server_low_digest.result | 12 + .../r/start_server_low_digest_sql_length.result | 12 + .../perfschema/r/start_server_low_index.result | 281 + .../r/start_server_low_table_lock.result | 238 + .../perfschema/r/start_server_no_account.result | 160 + .../perfschema/r/start_server_no_cond_class.result | 167 + .../perfschema/r/start_server_no_cond_inst.result | 170 + .../perfschema/r/start_server_no_digests.result | 132 + .../perfschema/r/start_server_no_file_class.result | 167 + .../perfschema/r/start_server_no_file_inst.result | 170 + .../suite/perfschema/r/start_server_no_host.result | 160 + .../perfschema/r/start_server_no_index.result | 186 + .../suite/perfschema/r/start_server_no_mdl.result | 162 + .../r/start_server_no_memory_class.result | 236 + .../r/start_server_no_mutex_class.result | 167 + .../perfschema/r/start_server_no_mutex_inst.result | 170 + ...start_server_no_prepared_stmts_instances.result | 213 + .../r/start_server_no_rwlock_class.result | 167 + .../r/start_server_no_rwlock_inst.result | 170 + .../r/start_server_no_setup_actors.result | 156 + .../r/start_server_no_setup_objects.result | 156 + .../r/start_server_no_socket_class.result | 167 + .../r/start_server_no_socket_inst.result | 170 + .../r/start_server_no_stage_class.result | 176 + .../r/start_server_no_stages_history.result | 157 + .../r/start_server_no_stages_history_long.result | 157 + .../r/start_server_no_statement_class.result | 176 + .../r/start_server_no_statements_history.result | 157 + .../start_server_no_statements_history_long.result | 157 + .../perfschema/r/start_server_no_table_hdl.result | 172 + .../perfschema/r/start_server_no_table_inst.result | 172 + .../perfschema/r/start_server_no_table_lock.result | 178 + .../r/start_server_no_thread_class.result | 167 + .../r/start_server_no_thread_inst.result | 166 + .../r/start_server_no_transactions_history.result | 157 + ...tart_server_no_transactions_history_long.result | 157 + .../suite/perfschema/r/start_server_no_user.result | 160 + .../r/start_server_no_waits_history.result | 157 + .../r/start_server_no_waits_history_long.result | 157 + .../suite/perfschema/r/start_server_nothing.result | 399 ++ .../suite/perfschema/r/start_server_off.result | 282 + .../suite/perfschema/r/start_server_on.result | 182 + .../perfschema/r/start_server_variables.result | 195 + .../r/start_server_zero_digest_sql_length.result | 12 + .../suite/perfschema/r/statement_digest.result | 163 + .../perfschema/r/statement_digest_charset.result | 14 + .../perfschema/r/statement_digest_consumers.result | 179 + .../r/statement_digest_consumers2.result | 145 + .../r/statement_digest_long_query.result | 12 + .../r/statement_program_concurrency.result | 117 + .../r/statement_program_lost_inst.result | 336 + .../perfschema/r/statement_program_nested.result | 2334 +++++++ .../r/statement_program_nesting_event_check.result | 1515 +++++ .../r/statement_program_non_nested.result | 704 ++ .../suite/perfschema/r/status_reprepare.result | 42 + mysql-test/suite/perfschema/r/sxlock_func.result | 58 + .../r/table_aggregate_global_2u_2t.result | 1646 +++++ .../r/table_aggregate_global_2u_3t.result | 1775 +++++ .../r/table_aggregate_global_4u_2t.result | 1646 +++++ .../r/table_aggregate_global_4u_3t.result | 1775 +++++ .../perfschema/r/table_aggregate_hist_2u_2t.result | 1724 +++++ .../perfschema/r/table_aggregate_hist_2u_3t.result | 1893 ++++++ .../perfschema/r/table_aggregate_hist_4u_2t.result | 1724 +++++ .../perfschema/r/table_aggregate_hist_4u_3t.result | 1893 ++++++ .../suite/perfschema/r/table_aggregate_off.result | 1715 +++++ .../r/table_aggregate_thread_2u_2t.result | 1646 +++++ .../r/table_aggregate_thread_2u_3t.result | 1775 +++++ .../r/table_aggregate_thread_4u_2t.result | 1646 +++++ .../r/table_aggregate_thread_4u_3t.result | 1775 +++++ .../r/table_io_aggregate_global_2u_2t.result | 1648 +++++ .../r/table_io_aggregate_global_2u_3t.result | 1777 +++++ .../r/table_io_aggregate_global_4u_2t.result | 1648 +++++ .../r/table_io_aggregate_global_4u_3t.result | 1777 +++++ .../r/table_io_aggregate_hist_2u_2t.result | 1686 +++++ .../r/table_io_aggregate_hist_2u_3t.result | 1835 ++++++ .../r/table_io_aggregate_hist_4u_2t.result | 1686 +++++ .../r/table_io_aggregate_hist_4u_3t.result | 1835 ++++++ .../r/table_io_aggregate_thread_2u_2t.result | 1648 +++++ .../r/table_io_aggregate_thread_2u_3t.result | 1777 +++++ .../r/table_io_aggregate_thread_4u_2t.result | 1648 +++++ .../r/table_io_aggregate_thread_4u_3t.result | 1777 +++++ .../r/table_lock_aggregate_global_2u_2t.result | 1608 +++++ .../r/table_lock_aggregate_global_2u_3t.result | 1717 +++++ .../r/table_lock_aggregate_global_4u_2t.result | 1608 +++++ .../r/table_lock_aggregate_global_4u_3t.result | 1717 +++++ .../r/table_lock_aggregate_hist_2u_2t.result | 1646 +++++ .../r/table_lock_aggregate_hist_2u_3t.result | 1775 +++++ .../r/table_lock_aggregate_hist_4u_2t.result | 1646 +++++ .../r/table_lock_aggregate_hist_4u_3t.result | 1775 +++++ .../r/table_lock_aggregate_thread_2u_2t.result | 1608 +++++ .../r/table_lock_aggregate_thread_2u_3t.result | 1717 +++++ .../r/table_lock_aggregate_thread_4u_2t.result | 1608 +++++ .../r/table_lock_aggregate_thread_4u_3t.result | 1717 +++++ mysql-test/suite/perfschema/r/table_name.result | 167 + mysql-test/suite/perfschema/r/table_schema.result | 1208 ++++ mysql-test/suite/perfschema/r/temp_table_io.result | 126 + mysql-test/suite/perfschema/r/thread_cache.result | 57 + mysql-test/suite/perfschema/r/thread_misc.result | 1 + .../suite/perfschema/r/threads_history.result | 700 ++ .../suite/perfschema/r/threads_innodb.result | 9 + .../perfschema/r/threads_insert_delayed.result | 19 + mysql-test/suite/perfschema/r/threads_mysql.result | 123 + .../perfschema/r/threads_mysql_freebsd.result | 3 + .../suite/perfschema/r/threads_mysql_linux.result | 3 + .../perfschema/r/threads_mysql_windows.result | 3 + mysql-test/suite/perfschema/r/transaction.result | 680 ++ .../suite/perfschema/r/transaction_gtid.result | 171 + .../perfschema/r/transaction_nested_events.result | 1284 ++++ .../suite/perfschema/r/trigger_table_io.result | 201 + mysql-test/suite/perfschema/r/unary_digest.result | 47 + .../suite/perfschema/r/update_order-3837.result | 1 + mysql-test/suite/perfschema/r/user_var_func.result | 91 + mysql-test/suite/perfschema/r/view_table_io.result | 154 + mysql-test/suite/perfschema/t/all_tests.test | 67 + .../suite/perfschema/t/alter_table_progress.test | 147 + mysql-test/suite/perfschema/t/bad_option.test | 75 + .../suite/perfschema/t/batch_table_io_func.test | 152 + .../suite/perfschema/t/binlog_edge_mix-master.opt | 2 + mysql-test/suite/perfschema/t/binlog_edge_mix.test | 10 + .../suite/perfschema/t/binlog_edge_row-master.opt | 2 + mysql-test/suite/perfschema/t/binlog_edge_row.test | 10 + .../suite/perfschema/t/binlog_edge_stmt-master.opt | 2 + .../suite/perfschema/t/binlog_edge_stmt.test | 10 + mysql-test/suite/perfschema/t/binlog_mix.test | 10 + .../suite/perfschema/t/binlog_ok_mix-master.opt | 2 + mysql-test/suite/perfschema/t/binlog_ok_mix.test | 10 + .../suite/perfschema/t/binlog_ok_row-master.opt | 2 + mysql-test/suite/perfschema/t/binlog_ok_row.test | 10 + .../suite/perfschema/t/binlog_ok_stmt-master.opt | 2 + mysql-test/suite/perfschema/t/binlog_ok_stmt.test | 10 + mysql-test/suite/perfschema/t/binlog_row.test | 10 + mysql-test/suite/perfschema/t/binlog_stmt.test | 11 + mysql-test/suite/perfschema/t/checksum.test | 121 + mysql-test/suite/perfschema/t/cnf_option.cnf | 10 + mysql-test/suite/perfschema/t/cnf_option.test | 9 + .../suite/perfschema/t/column_privilege.test | 62 + mysql-test/suite/perfschema/t/connect_attrs.test | 83 + mysql-test/suite/perfschema/t/connection.test | 7 + .../suite/perfschema/t/connection_3a-master.opt | 1 + mysql-test/suite/perfschema/t/connection_3a.test | 7 + .../suite/perfschema/t/connection_3a_3u-master.opt | 2 + .../suite/perfschema/t/connection_3a_3u.test | 7 + .../suite/perfschema/t/connection_3u-master.opt | 1 + mysql-test/suite/perfschema/t/connection_3u.test | 7 + .../suite/perfschema/t/connection_type_notwin.test | 92 + .../suite/perfschema/t/connection_type_win.test | 90 + mysql-test/suite/perfschema/t/csv_table_io.test | 28 + mysql-test/suite/perfschema/t/ddl_accounts.test | 17 + .../suite/perfschema/t/ddl_cond_instances.test | 17 + .../t/ddl_esgs_by_account_by_event_name.test | 19 + .../t/ddl_esgs_by_host_by_event_name.test | 19 + .../t/ddl_esgs_by_thread_by_event_name.test | 18 + .../t/ddl_esgs_by_user_by_event_name.test | 19 + .../t/ddl_esgs_global_by_event_name.test | 19 + .../t/ddl_esms_by_account_by_event_name.test | 19 + .../suite/perfschema/t/ddl_esms_by_digest.test | 40 + .../t/ddl_esms_by_host_by_event_name.test | 19 + .../suite/perfschema/t/ddl_esms_by_program.test | 21 + .../t/ddl_esms_by_thread_by_event_name.test | 18 + .../t/ddl_esms_by_user_by_event_name.test | 19 + .../t/ddl_esms_global_by_event_name.test | 19 + .../t/ddl_ets_by_account_by_event_name.test | 19 + .../t/ddl_ets_by_host_by_event_name.test | 19 + .../t/ddl_ets_by_thread_by_event_name.test | 18 + .../t/ddl_ets_by_user_by_event_name.test | 19 + .../perfschema/t/ddl_ets_global_by_event_name.test | 19 + .../perfschema/t/ddl_events_stages_current.test | 21 + .../perfschema/t/ddl_events_stages_history.test | 21 + .../t/ddl_events_stages_history_long.test | 21 + .../t/ddl_events_statements_current.test | 16 + .../t/ddl_events_statements_history.test | 16 + .../t/ddl_events_statements_history_long.test | 16 + .../t/ddl_events_transactions_current.test | 16 + .../t/ddl_events_transactions_history.test | 16 + .../t/ddl_events_transactions_history_long.test | 16 + .../perfschema/t/ddl_events_waits_current.test | 16 + .../perfschema/t/ddl_events_waits_history.test | 16 + .../t/ddl_events_waits_history_long.test | 16 + .../t/ddl_ews_by_account_by_event_name.test | 19 + .../t/ddl_ews_by_host_by_event_name.test | 19 + .../suite/perfschema/t/ddl_ews_by_instance.test | 16 + .../t/ddl_ews_by_thread_by_event_name.test | 18 + .../t/ddl_ews_by_user_by_event_name.test | 19 + .../perfschema/t/ddl_ews_global_by_event_name.test | 19 + .../suite/perfschema/t/ddl_file_instances.test | 17 + .../suite/perfschema/t/ddl_fs_by_event_name.test | 16 + .../suite/perfschema/t/ddl_fs_by_instance.test | 16 + .../suite/perfschema/t/ddl_global_status.test | 19 + .../suite/perfschema/t/ddl_global_variables.test | 20 + mysql-test/suite/perfschema/t/ddl_host_cache.test | 16 + mysql-test/suite/perfschema/t/ddl_hosts.test | 17 + .../t/ddl_mems_by_account_by_event_name.test | 19 + .../t/ddl_mems_by_host_by_event_name.test | 19 + .../t/ddl_mems_by_thread_by_event_name.test | 19 + .../t/ddl_mems_by_user_by_event_name.test | 19 + .../t/ddl_mems_global_by_event_name.test | 19 + .../suite/perfschema/t/ddl_metadata_locks.test | 17 + .../suite/perfschema/t/ddl_mutex_instances.test | 17 + .../suite/perfschema/t/ddl_os_global_by_type.test | 19 + .../suite/perfschema/t/ddl_performance_timers.test | 17 + .../t/ddl_prepared_statements_instances.test | 21 + mysql-test/suite/perfschema/t/ddl_processlist.test | 32 + .../t/ddl_replication_applier_configuration.test | 22 + .../t/ddl_replication_applier_status.test | 22 + ..._replication_applier_status_by_coordinator.test | 22 + .../ddl_replication_applier_status_by_worker.test | 22 + .../ddl_replication_connection_configuration.test | 22 + .../t/ddl_replication_connection_status.test | 22 + .../t/ddl_replication_group_member_stats.test | 21 + .../t/ddl_replication_group_members.test | 22 + .../suite/perfschema/t/ddl_rwlock_instances.test | 17 + .../t/ddl_session_account_connect_attrs.test | 15 + .../perfschema/t/ddl_session_connect_attrs.test | 15 + .../suite/perfschema/t/ddl_session_status.test | 20 + .../suite/perfschema/t/ddl_session_variables.test | 20 + .../suite/perfschema/t/ddl_setup_actors.test | 31 + .../suite/perfschema/t/ddl_setup_consumers.test | 17 + .../suite/perfschema/t/ddl_setup_instruments.test | 17 + .../suite/perfschema/t/ddl_setup_objects.test | 29 + .../suite/perfschema/t/ddl_setup_timers.test | 17 + .../suite/perfschema/t/ddl_socket_instances.test | 17 + .../t/ddl_socket_summary_by_event_name.test | 16 + .../t/ddl_socket_summary_by_instance.test | 16 + .../suite/perfschema/t/ddl_status_by_account.test | 19 + .../suite/perfschema/t/ddl_status_by_host.test | 19 + .../suite/perfschema/t/ddl_status_by_thread.test | 19 + .../suite/perfschema/t/ddl_status_by_user.test | 19 + .../suite/perfschema/t/ddl_table_handles.test | 17 + mysql-test/suite/perfschema/t/ddl_threads.test | 17 + .../perfschema/t/ddl_tiws_by_index_usage.test | 17 + .../suite/perfschema/t/ddl_tiws_by_table.test | 17 + .../suite/perfschema/t/ddl_tlws_by_table.test | 17 + mysql-test/suite/perfschema/t/ddl_users.test | 17 + .../suite/perfschema/t/ddl_uvar_by_thread.test | 20 + .../perfschema/t/ddl_variables_by_thread.test | 20 + .../suite/perfschema/t/digest_null_literal.test | 32 + .../perfschema/t/digest_table_full-master.opt | 1 + .../suite/perfschema/t/digest_table_full.test | 32 + mysql-test/suite/perfschema/t/digest_view.test | 153 + mysql-test/suite/perfschema/t/disabled.def | 12 + mysql-test/suite/perfschema/t/discovery.test | 15 + mysql-test/suite/perfschema/t/dml_accounts.test | 47 + .../suite/perfschema/t/dml_cond_instances.test | 41 + .../t/dml_esgs_by_account_by_event_name.test | 48 + .../t/dml_esgs_by_host_by_event_name.test | 48 + .../t/dml_esgs_by_thread_by_event_name.test | 48 + .../t/dml_esgs_by_user_by_event_name.test | 48 + .../t/dml_esgs_global_by_event_name.test | 47 + .../t/dml_esms_by_account_by_event_name.test | 48 + .../suite/perfschema/t/dml_esms_by_digest.test | 69 + .../t/dml_esms_by_host_by_event_name.test | 48 + .../suite/perfschema/t/dml_esms_by_program.test | 44 + .../t/dml_esms_by_thread_by_event_name.test | 48 + .../t/dml_esms_by_user_by_event_name.test | 48 + .../t/dml_esms_global_by_event_name.test | 47 + .../t/dml_ets_by_account_by_event_name.test | 42 + .../t/dml_ets_by_host_by_event_name.test | 42 + .../t/dml_ets_by_thread_by_event_name.test | 42 + .../t/dml_ets_by_user_by_event_name.test | 42 + .../perfschema/t/dml_ets_global_by_event_name.test | 41 + .../perfschema/t/dml_events_stages_current.test | 47 + .../perfschema/t/dml_events_stages_history.test | 53 + .../t/dml_events_stages_history_long.test | 53 + .../t/dml_events_statements_current.test | 47 + .../t/dml_events_statements_history.test | 53 + .../t/dml_events_statements_history_long.test | 53 + .../t/dml_events_transactions_current.test | 41 + .../t/dml_events_transactions_history.test | 47 + .../t/dml_events_transactions_history_long.test | 47 + .../perfschema/t/dml_events_waits_current.test | 47 + .../perfschema/t/dml_events_waits_history.test | 53 + .../t/dml_events_waits_history_long.test | 53 + .../t/dml_ews_by_account_by_event_name.test | 47 + .../t/dml_ews_by_host_by_event_name.test | 47 + .../suite/perfschema/t/dml_ews_by_instance.test | 60 + .../t/dml_ews_by_thread_by_event_name.test | 48 + .../t/dml_ews_by_user_by_event_name.test | 47 + .../perfschema/t/dml_ews_global_by_event_name.test | 47 + .../suite/perfschema/t/dml_file_instances.test | 113 + .../suite/perfschema/t/dml_fs_by_event_name.test | 47 + .../suite/perfschema/t/dml_fs_by_instance.test | 47 + .../suite/perfschema/t/dml_global_status.test | 36 + .../suite/perfschema/t/dml_global_variables.test | 36 + mysql-test/suite/perfschema/t/dml_handler.test | 46 + mysql-test/suite/perfschema/t/dml_host_cache.test | 49 + mysql-test/suite/perfschema/t/dml_hosts.test | 47 + .../t/dml_mems_by_account_by_event_name.test | 48 + .../t/dml_mems_by_host_by_event_name.test | 48 + .../t/dml_mems_by_thread_by_event_name.test | 42 + .../t/dml_mems_by_user_by_event_name.test | 48 + .../t/dml_mems_global_by_event_name.test | 48 + .../suite/perfschema/t/dml_metadata_locks.test | 41 + .../suite/perfschema/t/dml_mutex_instances.test | 41 + .../suite/perfschema/t/dml_os_global_by_type.test | 63 + .../suite/perfschema/t/dml_performance_timers.test | 43 + .../t/dml_prepared_statements_instances.test | 43 + mysql-test/suite/perfschema/t/dml_processlist.test | 39 + .../t/dml_replication_applier_configuration.test | 38 + .../t/dml_replication_applier_status.test | 42 + ..._replication_applier_status_by_coordinator.test | 43 + .../dml_replication_applier_status_by_worker.test | 50 + .../dml_replication_connection_configuration.test | 43 + .../t/dml_replication_connection_status.test | 43 + .../t/dml_replication_group_member_stats.test | 38 + .../t/dml_replication_group_members.test | 40 + .../suite/perfschema/t/dml_rwlock_instances.test | 41 + .../t/dml_session_account_connect_attrs.test | 47 + .../perfschema/t/dml_session_connect_attrs.test | 47 + .../suite/perfschema/t/dml_session_status.test | 36 + .../suite/perfschema/t/dml_session_variables.test | 36 + .../suite/perfschema/t/dml_setup_actors.test | 147 + .../suite/perfschema/t/dml_setup_consumers.test | 46 + .../suite/perfschema/t/dml_setup_instruments.test | 110 + .../suite/perfschema/t/dml_setup_objects.test | 102 + .../suite/perfschema/t/dml_setup_timers.test | 76 + .../suite/perfschema/t/dml_socket_instances.test | 41 + .../t/dml_socket_summary_by_event_name.test | 48 + .../t/dml_socket_summary_by_instance.test | 48 + .../suite/perfschema/t/dml_status_by_account.test | 40 + .../suite/perfschema/t/dml_status_by_host.test | 40 + .../suite/perfschema/t/dml_status_by_thread.test | 40 + .../suite/perfschema/t/dml_status_by_user.test | 40 + .../suite/perfschema/t/dml_table_handles.test | 35 + mysql-test/suite/perfschema/t/dml_threads.test | 56 + .../perfschema/t/dml_tiws_by_index_usage.test | 48 + .../suite/perfschema/t/dml_tiws_by_table.test | 48 + .../suite/perfschema/t/dml_tlws_by_table.test | 48 + mysql-test/suite/perfschema/t/dml_users.test | 47 + .../suite/perfschema/t/dml_uvar_by_thread.test | 48 + .../perfschema/t/dml_variables_by_thread.test | 40 + .../suite/perfschema/t/event_aggregate-master.opt | 2 + mysql-test/suite/perfschema/t/event_aggregate.test | 5 + .../perfschema/t/event_aggregate_no_a-master.opt | 3 + .../suite/perfschema/t/event_aggregate_no_a.test | 5 + .../t/event_aggregate_no_a_no_h-master.opt | 4 + .../perfschema/t/event_aggregate_no_a_no_h.test | 5 + .../t/event_aggregate_no_a_no_u-master.opt | 4 + .../perfschema/t/event_aggregate_no_a_no_u.test | 5 + .../t/event_aggregate_no_a_no_u_no_h-master.opt | 5 + .../t/event_aggregate_no_a_no_u_no_h.test | 5 + .../perfschema/t/event_aggregate_no_h-master.opt | 3 + .../suite/perfschema/t/event_aggregate_no_h.test | 5 + .../perfschema/t/event_aggregate_no_u-master.opt | 3 + .../suite/perfschema/t/event_aggregate_no_u.test | 5 + .../t/event_aggregate_no_u_no_h-master.opt | 4 + .../perfschema/t/event_aggregate_no_u_no_h.test | 5 + mysql-test/suite/perfschema/t/file_misc-master.opt | 1 + mysql-test/suite/perfschema/t/file_misc.test | 11 + mysql-test/suite/perfschema/t/func_file_io.test | 193 + mysql-test/suite/perfschema/t/func_mutex.test | 134 + .../suite/perfschema/t/global_objects-master.opt | 1 + mysql-test/suite/perfschema/t/global_objects.test | 29 + .../suite/perfschema/t/global_read_lock.test | 78 + mysql-test/suite/perfschema/t/grant.test | 12 + .../t/hostcache_ipv4_addrinfo_again_allow.test | 53 + .../t/hostcache_ipv4_addrinfo_again_deny.test | 48 + .../t/hostcache_ipv4_addrinfo_bad_allow.test | 56 + .../t/hostcache_ipv4_addrinfo_bad_deny.test | 50 + .../t/hostcache_ipv4_addrinfo_good_allow.test | 54 + .../t/hostcache_ipv4_addrinfo_good_deny.test | 48 + .../t/hostcache_ipv4_addrinfo_noname_allow.test | 58 + .../t/hostcache_ipv4_addrinfo_noname_deny.test | 48 + .../perfschema/t/hostcache_ipv4_auth_ed25519.test | 56 + .../perfschema/t/hostcache_ipv4_auth_plugin.test | 92 + .../suite/perfschema/t/hostcache_ipv4_blocked.test | 161 + .../suite/perfschema/t/hostcache_ipv4_format.test | 47 + .../perfschema/t/hostcache_ipv4_max_con-master.opt | 1 + .../suite/perfschema/t/hostcache_ipv4_max_con.test | 264 + .../t/hostcache_ipv4_nameinfo_again_allow.test | 76 + .../t/hostcache_ipv4_nameinfo_again_deny.test | 66 + .../t/hostcache_ipv4_nameinfo_noname_allow.test | 54 + .../t/hostcache_ipv4_nameinfo_noname_deny.test | 48 + .../suite/perfschema/t/hostcache_ipv4_passwd.test | 87 + .../suite/perfschema/t/hostcache_ipv4_ssl.test | 72 + .../hostcache_ipv6_addrinfo_again_allow-master.opt | 2 + .../t/hostcache_ipv6_addrinfo_again_allow.test | 55 + .../hostcache_ipv6_addrinfo_again_deny-master.opt | 2 + .../t/hostcache_ipv6_addrinfo_again_deny.test | 49 + .../t/hostcache_ipv6_addrinfo_bad_allow-master.opt | 2 + .../t/hostcache_ipv6_addrinfo_bad_allow.test | 57 + .../t/hostcache_ipv6_addrinfo_bad_deny-master.opt | 2 + .../t/hostcache_ipv6_addrinfo_bad_deny.test | 51 + .../hostcache_ipv6_addrinfo_good_allow-master.opt | 2 + .../t/hostcache_ipv6_addrinfo_good_allow.test | 55 + .../t/hostcache_ipv6_addrinfo_good_deny-master.opt | 2 + .../t/hostcache_ipv6_addrinfo_good_deny.test | 45 + ...hostcache_ipv6_addrinfo_noname_allow-master.opt | 2 + .../t/hostcache_ipv6_addrinfo_noname_allow.test | 58 + .../hostcache_ipv6_addrinfo_noname_deny-master.opt | 2 + .../t/hostcache_ipv6_addrinfo_noname_deny.test | 48 + .../t/hostcache_ipv6_auth_plugin-master.opt | 2 + .../perfschema/t/hostcache_ipv6_auth_plugin.test | 93 + .../perfschema/t/hostcache_ipv6_blocked-master.opt | 2 + .../suite/perfschema/t/hostcache_ipv6_blocked.test | 161 + .../perfschema/t/hostcache_ipv6_max_con-master.opt | 3 + .../suite/perfschema/t/hostcache_ipv6_max_con.test | 246 + .../hostcache_ipv6_nameinfo_again_allow-master.opt | 2 + .../t/hostcache_ipv6_nameinfo_again_allow.test | 77 + .../hostcache_ipv6_nameinfo_again_deny-master.opt | 2 + .../t/hostcache_ipv6_nameinfo_again_deny.test | 67 + ...hostcache_ipv6_nameinfo_noname_allow-master.opt | 2 + .../t/hostcache_ipv6_nameinfo_noname_allow.test | 55 + .../hostcache_ipv6_nameinfo_noname_deny-master.opt | 2 + .../t/hostcache_ipv6_nameinfo_noname_deny.test | 49 + .../perfschema/t/hostcache_ipv6_passwd-master.opt | 2 + .../suite/perfschema/t/hostcache_ipv6_passwd.test | 85 + .../perfschema/t/hostcache_ipv6_ssl-master.opt | 2 + .../suite/perfschema/t/hostcache_ipv6_ssl.test | 73 + .../suite/perfschema/t/hostcache_peer_addr.test | 50 + .../suite/perfschema/t/indexed_table_io.test | 114 + .../suite/perfschema/t/information_schema.test | 73 + .../t/innodb_events_transactions_history_long.test | 19 + mysql-test/suite/perfschema/t/innodb_table_io.test | 29 + mysql-test/suite/perfschema/t/io_cache-master.opt | 3 + mysql-test/suite/perfschema/t/io_cache.test | 121 + .../suite/perfschema/t/max_program_zero-master.opt | 3 + .../suite/perfschema/t/max_program_zero.test | 48 + mysql-test/suite/perfschema/t/mdl_func.test | 487 ++ .../suite/perfschema/t/memory_aggregate-master.opt | 1 + .../suite/perfschema/t/memory_aggregate.test | 7 + .../perfschema/t/memory_aggregate_32bit-master.opt | 1 + .../suite/perfschema/t/memory_aggregate_32bit.test | 7 + .../perfschema/t/memory_aggregate_no_a-master.opt | 2 + .../suite/perfschema/t/memory_aggregate_no_a.test | 7 + .../t/memory_aggregate_no_a_no_h-master.opt | 3 + .../perfschema/t/memory_aggregate_no_a_no_h.test | 7 + .../t/memory_aggregate_no_a_no_u-master.opt | 3 + .../perfschema/t/memory_aggregate_no_a_no_u.test | 7 + .../t/memory_aggregate_no_a_no_u_no_h-master.opt | 4 + .../t/memory_aggregate_no_a_no_u_no_h.test | 7 + .../perfschema/t/memory_aggregate_no_h-master.opt | 2 + .../suite/perfschema/t/memory_aggregate_no_h.test | 7 + .../perfschema/t/memory_aggregate_no_u-master.opt | 2 + .../suite/perfschema/t/memory_aggregate_no_u.test | 7 + .../t/memory_aggregate_no_u_no_h-master.opt | 3 + .../perfschema/t/memory_aggregate_no_u_no_h.test | 7 + mysql-test/suite/perfschema/t/memory_table_io.test | 28 + mysql-test/suite/perfschema/t/merge_table_io.test | 46 + mysql-test/suite/perfschema/t/misc.test | 320 + .../perfschema/t/misc_global_status-master.opt | 1 + .../suite/perfschema/t/misc_global_status.test | 142 + mysql-test/suite/perfschema/t/mks_timer-6258.test | 6 + mysql-test/suite/perfschema/t/multi_table_io.test | 55 + mysql-test/suite/perfschema/t/myisam_file_io.opt | 1 + mysql-test/suite/perfschema/t/myisam_file_io.test | 61 + mysql-test/suite/perfschema/t/myisam_table_io.test | 28 + mysql-test/suite/perfschema/t/nesting.test | 191 + .../suite/perfschema/t/no_threads-master.opt | 5 + mysql-test/suite/perfschema/t/no_threads.test | 59 + .../perfschema/t/one_thread_per_con-master.opt | 1 + .../suite/perfschema/t/one_thread_per_con.test | 70 + mysql-test/suite/perfschema/t/ortho_iter.test | 307 + mysql-test/suite/perfschema/t/part_table_io.test | 30 + mysql-test/suite/perfschema/t/partition.test | 16 + .../perfschema/t/pfs_upgrade_event-master.opt | 2 + .../suite/perfschema/t/pfs_upgrade_event.test | 24 + .../suite/perfschema/t/pfs_upgrade_func-master.opt | 2 + .../suite/perfschema/t/pfs_upgrade_func.test | 24 + .../suite/perfschema/t/pfs_upgrade_proc-master.opt | 2 + .../suite/perfschema/t/pfs_upgrade_proc.test | 24 + .../perfschema/t/pfs_upgrade_table-master.opt | 2 + .../suite/perfschema/t/pfs_upgrade_table.test | 30 + .../suite/perfschema/t/pfs_upgrade_view-master.opt | 2 + .../suite/perfschema/t/pfs_upgrade_view.test | 30 + .../suite/perfschema/t/prepared_statements.test | 210 + .../t/prepared_stmts_by_stored_programs.test | 151 + mysql-test/suite/perfschema/t/privilege.test | 353 + .../suite/perfschema/t/privilege_table_io.test | 53 + .../suite/perfschema/t/processlist-master.opt | 1 + mysql-test/suite/perfschema/t/processlist.test | 197 + mysql-test/suite/perfschema/t/processlist_57.test | 349 + .../suite/perfschema/t/processlist_acl-master.opt | 1 + mysql-test/suite/perfschema/t/processlist_acl.test | 196 + .../suite/perfschema/t/processlist_anonymous.test | 111 + .../perfschema/t/processlist_no_pfs-master.opt | 2 + .../suite/perfschema/t/processlist_no_pfs.test | 29 + .../suite/perfschema/t/processlist_port-master.opt | 1 + .../suite/perfschema/t/processlist_port.test | 162 + .../suite/perfschema/t/processlist_reg_user.test | 134 + .../suite/perfschema/t/query_cache-master.opt | 1 + mysql-test/suite/perfschema/t/query_cache.test | 61 + mysql-test/suite/perfschema/t/read_only.test | 77 + mysql-test/suite/perfschema/t/relaylog.test | 180 + .../suite/perfschema/t/rollback_table_io.test | 48 + .../suite/perfschema/t/rpl_group_member_stats.test | 48 + .../suite/perfschema/t/rpl_group_members.test | 33 + mysql-test/suite/perfschema/t/rpl_gtid_func.test | 86 + mysql-test/suite/perfschema/t/rpl_statements.test | 313 + mysql-test/suite/perfschema/t/rpl_threads.test | 85 + mysql-test/suite/perfschema/t/schema.test | 7 + mysql-test/suite/perfschema/t/selects-master.opt | 1 + mysql-test/suite/perfschema/t/selects.test | 181 + mysql-test/suite/perfschema/t/server_init.test | 144 + mysql-test/suite/perfschema/t/setup_actors.test | 230 + .../suite/perfschema/t/setup_actors_enabled.test | 219 + .../suite/perfschema/t/setup_actors_history.test | 177 + .../t/setup_consumers_defaults-master.opt | 18 + .../perfschema/t/setup_consumers_defaults.test | 18 + .../t/setup_instruments_defaults-master.opt | 28 + .../perfschema/t/setup_instruments_defaults.test | 100 + .../perfschema/t/setup_object_table_lock_io.test | 107 + mysql-test/suite/perfschema/t/setup_objects.test | 197 + .../suite/perfschema/t/short_option_1-master.opt | 1 + mysql-test/suite/perfschema/t/short_option_1.test | 16 + .../suite/perfschema/t/short_option_2-master.opt | 1 + mysql-test/suite/perfschema/t/short_option_2.test | 14 + mysql-test/suite/perfschema/t/show_aggregate.test | 301 + mysql-test/suite/perfschema/t/show_coverage.test | 186 + mysql-test/suite/perfschema/t/show_misc.test | 64 + mysql-test/suite/perfschema/t/show_plugin.test | 321 + mysql-test/suite/perfschema/t/show_sanity.test | 1831 ++++++ mysql-test/suite/perfschema/t/socket_connect.test | 293 + .../perfschema/t/socket_instances_func-master.opt | 1 + .../suite/perfschema/t/socket_instances_func.test | 443 ++ .../t/socket_instances_func_win-master.opt | 1 + .../perfschema/t/socket_instances_func_win.test | 339 + .../t/socket_summary_by_event_name_func.test | 337 + .../t/socket_summary_by_instance_func.test | 1713 +++++ .../t/socket_summary_by_instance_func_win.test | 1730 +++++ .../suite/perfschema/t/stage_mdl_function.test | 63 + mysql-test/suite/perfschema/t/stage_mdl_global.opt | 2 + .../suite/perfschema/t/stage_mdl_global.test | 54 + .../suite/perfschema/t/stage_mdl_procedure.test | 79 + mysql-test/suite/perfschema/t/stage_mdl_table.test | 59 + .../perfschema/t/start_server_1_digest-master.opt | 1 + .../suite/perfschema/t/start_server_1_digest.test | 15 + .../t/start_server_disable_idle-master.opt | 1 + .../perfschema/t/start_server_disable_idle.test | 28 + .../t/start_server_disable_stages-master.opt | 1 + .../perfschema/t/start_server_disable_stages.test | 28 + .../t/start_server_disable_statements-master.opt | 1 + .../t/start_server_disable_statements.test | 28 + .../t/start_server_disable_transactions-master.opt | 1 + .../t/start_server_disable_transactions.test | 28 + .../t/start_server_disable_waits-master.opt | 1 + .../perfschema/t/start_server_disable_waits.test | 28 + .../perfschema/t/start_server_innodb-master.opt | 1 + .../suite/perfschema/t/start_server_innodb.test | 11 + .../t/start_server_low_digest-master.opt | 1 + .../perfschema/t/start_server_low_digest.test | 21 + .../start_server_low_digest_sql_length-master.opt | 3 + .../t/start_server_low_digest_sql_length.test | 23 + .../perfschema/t/start_server_low_index-master.opt | 2 + .../suite/perfschema/t/start_server_low_index.test | 187 + .../t/start_server_low_table_lock-master.opt | 2 + .../perfschema/t/start_server_low_table_lock.test | 136 + .../t/start_server_no_account-master.opt | 2 + .../perfschema/t/start_server_no_account.test | 18 + .../t/start_server_no_cond_class-master.opt | 2 + .../perfschema/t/start_server_no_cond_class.test | 25 + .../t/start_server_no_cond_inst-master.opt | 2 + .../perfschema/t/start_server_no_cond_inst.test | 28 + .../t/start_server_no_digests-master.opt | 1 + .../perfschema/t/start_server_no_digests.test | 32 + .../t/start_server_no_file_class-master.opt | 2 + .../perfschema/t/start_server_no_file_class.test | 25 + .../t/start_server_no_file_inst-master.opt | 2 + .../perfschema/t/start_server_no_file_inst.test | 28 + .../perfschema/t/start_server_no_host-master.opt | 2 + .../suite/perfschema/t/start_server_no_host.test | 18 + .../perfschema/t/start_server_no_index-master.opt | 2 + .../suite/perfschema/t/start_server_no_index.test | 66 + .../perfschema/t/start_server_no_mdl-master.opt | 2 + .../suite/perfschema/t/start_server_no_mdl.test | 23 + .../t/start_server_no_memory_class-master.opt | 2 + .../perfschema/t/start_server_no_memory_class.test | 26 + .../t/start_server_no_mutex_class-master.opt | 2 + .../perfschema/t/start_server_no_mutex_class.test | 25 + .../t/start_server_no_mutex_inst-master.opt | 2 + .../perfschema/t/start_server_no_mutex_inst.test | 28 + ...t_server_no_prepared_stmts_instances-master.opt | 2 + .../start_server_no_prepared_stmts_instances.test | 43 + .../t/start_server_no_rwlock_class-master.opt | 2 + .../perfschema/t/start_server_no_rwlock_class.test | 25 + .../t/start_server_no_rwlock_inst-master.opt | 2 + .../perfschema/t/start_server_no_rwlock_inst.test | 28 + .../t/start_server_no_setup_actors-master.opt | 2 + .../perfschema/t/start_server_no_setup_actors.test | 13 + .../t/start_server_no_setup_objects-master.opt | 2 + .../t/start_server_no_setup_objects.test | 13 + .../t/start_server_no_socket_class-master.opt | 2 + .../perfschema/t/start_server_no_socket_class.test | 25 + .../t/start_server_no_socket_inst-master.opt | 2 + .../perfschema/t/start_server_no_socket_inst.test | 28 + .../t/start_server_no_stage_class-master.opt | 2 + .../perfschema/t/start_server_no_stage_class.test | 28 + .../t/start_server_no_stages_history-master.opt | 2 + .../t/start_server_no_stages_history.test | 14 + .../start_server_no_stages_history_long-master.opt | 2 + .../t/start_server_no_stages_history_long.test | 14 + .../t/start_server_no_statement_class-master.opt | 2 + .../t/start_server_no_statement_class.test | 28 + .../start_server_no_statements_history-master.opt | 2 + .../t/start_server_no_statements_history.test | 14 + ...rt_server_no_statements_history_long-master.opt | 2 + .../t/start_server_no_statements_history_long.test | 14 + .../t/start_server_no_table_hdl-master.opt | 2 + .../perfschema/t/start_server_no_table_hdl.test | 32 + .../t/start_server_no_table_inst-master.opt | 4 + .../perfschema/t/start_server_no_table_inst.test | 32 + .../t/start_server_no_table_lock-master.opt | 2 + .../perfschema/t/start_server_no_table_lock.test | 56 + .../t/start_server_no_thread_class-master.opt | 2 + .../perfschema/t/start_server_no_thread_class.test | 25 + .../t/start_server_no_thread_inst-master.opt | 2 + .../perfschema/t/start_server_no_thread_inst.test | 29 + ...start_server_no_transactions_history-master.opt | 2 + .../t/start_server_no_transactions_history.test | 14 + ..._server_no_transactions_history_long-master.opt | 2 + .../start_server_no_transactions_history_long.test | 14 + .../perfschema/t/start_server_no_user-master.opt | 2 + .../suite/perfschema/t/start_server_no_user.test | 18 + .../t/start_server_no_waits_history-master.opt | 2 + .../t/start_server_no_waits_history.test | 14 + .../start_server_no_waits_history_long-master.opt | 2 + .../t/start_server_no_waits_history_long.test | 14 + .../perfschema/t/start_server_nothing-master.opt | 47 + .../suite/perfschema/t/start_server_nothing.test | 62 + .../suite/perfschema/t/start_server_off-master.opt | 1 + .../suite/perfschema/t/start_server_off.test | 56 + .../suite/perfschema/t/start_server_on-master.opt | 1 + mysql-test/suite/perfschema/t/start_server_on.test | 10 + .../suite/perfschema/t/start_server_variables.test | 11 + .../start_server_zero_digest_sql_length-master.opt | 3 + .../t/start_server_zero_digest_sql_length.test | 20 + .../suite/perfschema/t/statement_digest.test | 25 + .../perfschema/t/statement_digest_charset.test | 36 + .../t/statement_digest_consumers-master.opt | 2 + .../perfschema/t/statement_digest_consumers.test | 35 + .../t/statement_digest_consumers2-master.opt | 2 + .../perfschema/t/statement_digest_consumers2.test | 37 + .../t/statement_digest_long_query-master.opt | 1 + .../perfschema/t/statement_digest_long_query.test | 31 + .../t/statement_program_concurrency-master.opt | 1 + .../t/statement_program_concurrency.test | 132 + .../t/statement_program_lost_inst-master.opt | 3 + .../perfschema/t/statement_program_lost_inst.test | 72 + .../t/statement_program_nested-master.opt | 1 + .../perfschema/t/statement_program_nested.test | 75 + ...tatement_program_nesting_event_check-master.opt | 1 + .../t/statement_program_nesting_event_check.test | 47 + .../t/statement_program_non_nested-master.opt | 1 + .../perfschema/t/statement_program_non_nested.test | 144 + .../suite/perfschema/t/status_reprepare.test | 61 + mysql-test/suite/perfschema/t/sxlock_func.test | 70 + .../perfschema/t/table_aggregate_global_2u_2t.test | 21 + .../perfschema/t/table_aggregate_global_2u_3t.test | 19 + .../perfschema/t/table_aggregate_global_4u_2t.test | 19 + .../perfschema/t/table_aggregate_global_4u_3t.test | 17 + .../perfschema/t/table_aggregate_hist_2u_2t.test | 19 + .../perfschema/t/table_aggregate_hist_2u_3t.test | 17 + .../perfschema/t/table_aggregate_hist_4u_2t.test | 17 + .../perfschema/t/table_aggregate_hist_4u_3t.test | 15 + .../suite/perfschema/t/table_aggregate_off.test | 13 + .../perfschema/t/table_aggregate_thread_2u_2t.test | 21 + .../perfschema/t/table_aggregate_thread_2u_3t.test | 19 + .../perfschema/t/table_aggregate_thread_4u_2t.test | 19 + .../perfschema/t/table_aggregate_thread_4u_3t.test | 17 + .../t/table_io_aggregate_global_2u_2t.test | 23 + .../t/table_io_aggregate_global_2u_3t.test | 21 + .../t/table_io_aggregate_global_4u_2t.test | 21 + .../t/table_io_aggregate_global_4u_3t.test | 19 + .../t/table_io_aggregate_hist_2u_2t.test | 21 + .../t/table_io_aggregate_hist_2u_3t.test | 19 + .../t/table_io_aggregate_hist_4u_2t.test | 19 + .../t/table_io_aggregate_hist_4u_3t.test | 17 + .../t/table_io_aggregate_thread_2u_2t.test | 23 + .../t/table_io_aggregate_thread_2u_3t.test | 21 + .../t/table_io_aggregate_thread_4u_2t.test | 21 + .../t/table_io_aggregate_thread_4u_3t.test | 19 + .../t/table_lock_aggregate_global_2u_2t.test | 26 + .../t/table_lock_aggregate_global_2u_3t.test | 24 + .../t/table_lock_aggregate_global_4u_2t.test | 24 + .../t/table_lock_aggregate_global_4u_3t.test | 22 + .../t/table_lock_aggregate_hist_2u_2t.test | 24 + .../t/table_lock_aggregate_hist_2u_3t.test | 22 + .../t/table_lock_aggregate_hist_4u_2t.test | 22 + .../t/table_lock_aggregate_hist_4u_3t.test | 20 + .../t/table_lock_aggregate_thread_2u_2t.test | 26 + .../t/table_lock_aggregate_thread_2u_3t.test | 24 + .../t/table_lock_aggregate_thread_4u_2t.test | 24 + .../t/table_lock_aggregate_thread_4u_3t.test | 22 + mysql-test/suite/perfschema/t/table_name.test | 177 + mysql-test/suite/perfschema/t/table_schema.test | 62 + mysql-test/suite/perfschema/t/temp_table_io.test | 28 + .../suite/perfschema/t/thread_cache-master.opt | 1 + mysql-test/suite/perfschema/t/thread_cache.test | 173 + .../suite/perfschema/t/thread_misc-master.opt | 1 + mysql-test/suite/perfschema/t/thread_misc.test | 11 + mysql-test/suite/perfschema/t/threads_history.test | 727 ++ mysql-test/suite/perfschema/t/threads_innodb.test | 23 + .../suite/perfschema/t/threads_mysql-master.opt | 1 + mysql-test/suite/perfschema/t/threads_mysql.test | 116 + .../suite/perfschema/t/threads_mysql_freebsd.test | 22 + .../suite/perfschema/t/threads_mysql_linux.test | 22 + .../suite/perfschema/t/threads_mysql_windows.test | 22 + .../suite/perfschema/t/transaction-master.opt | 4 + mysql-test/suite/perfschema/t/transaction.test | 734 +++ .../suite/perfschema/t/transaction_gtid.test | 194 + .../t/transaction_nested_events-master.opt | 19 + .../perfschema/t/transaction_nested_events.test | 387 ++ .../suite/perfschema/t/trigger_table_io.test | 76 + mysql-test/suite/perfschema/t/unary_digest.test | 98 + .../suite/perfschema/t/update_order-3837.test | 8 + mysql-test/suite/perfschema/t/user_var_func.test | 101 + mysql-test/suite/perfschema/t/view_table_io.test | 42 + 1119 files changed, 229929 insertions(+) create mode 100644 mysql-test/suite/perfschema/disabled.def create mode 100644 mysql-test/suite/perfschema/include/binlog_common.inc create mode 100644 mysql-test/suite/perfschema/include/binlog_edge_common.inc create mode 100644 mysql-test/suite/perfschema/include/binlog_ok_common.inc create mode 100644 mysql-test/suite/perfschema/include/cleanup_helper.inc create mode 100644 mysql-test/suite/perfschema/include/connection_cleanup.inc create mode 100644 mysql-test/suite/perfschema/include/connection_load.inc create mode 100644 mysql-test/suite/perfschema/include/connection_setup.inc create mode 100644 mysql-test/suite/perfschema/include/default_mysqld_autosize.cnf create mode 100644 mysql-test/suite/perfschema/include/digest_cleanup.inc create mode 100644 mysql-test/suite/perfschema/include/digest_execution.inc create mode 100644 mysql-test/suite/perfschema/include/digest_setup.inc create mode 100644 mysql-test/suite/perfschema/include/disable_instruments.inc create mode 100644 mysql-test/suite/perfschema/include/enable_instruments.inc create mode 100644 mysql-test/suite/perfschema/include/event_aggregate_cleanup.inc create mode 100644 mysql-test/suite/perfschema/include/event_aggregate_load.inc create mode 100644 mysql-test/suite/perfschema/include/event_aggregate_setup.inc create mode 100644 mysql-test/suite/perfschema/include/have_aligned_memory.inc create mode 100644 mysql-test/suite/perfschema/include/have_timer_cycle.inc create mode 100644 mysql-test/suite/perfschema/include/hostcache_dump.inc create mode 100644 mysql-test/suite/perfschema/include/hostcache_set_state.inc create mode 100644 mysql-test/suite/perfschema/include/memory_aggregate_cleanup.inc create mode 100644 mysql-test/suite/perfschema/include/memory_aggregate_load.inc create mode 100644 mysql-test/suite/perfschema/include/memory_aggregate_setup.inc create mode 100644 mysql-test/suite/perfschema/include/pfs_no_running_event_scheduler.inc create mode 100644 mysql-test/suite/perfschema/include/pfs_running_event_scheduler.inc create mode 100644 mysql-test/suite/perfschema/include/pfs_upgrade.inc create mode 100644 mysql-test/suite/perfschema/include/prepared_stmts_deallocation.inc create mode 100644 mysql-test/suite/perfschema/include/prepared_stmts_execution.inc create mode 100644 mysql-test/suite/perfschema/include/prepared_stmts_setup.inc create mode 100644 mysql-test/suite/perfschema/include/privilege.inc create mode 100644 mysql-test/suite/perfschema/include/processlist_load.inc create mode 100644 mysql-test/suite/perfschema/include/processlist_set.inc create mode 100644 mysql-test/suite/perfschema/include/program_cleanup.inc create mode 100644 mysql-test/suite/perfschema/include/program_execution.inc create mode 100644 mysql-test/suite/perfschema/include/program_nested_cleanup.inc create mode 100644 mysql-test/suite/perfschema/include/program_nested_execution.inc create mode 100644 mysql-test/suite/perfschema/include/program_nested_setup.inc create mode 100644 mysql-test/suite/perfschema/include/program_setup.inc create mode 100644 mysql-test/suite/perfschema/include/reset_transaction_gtid.inc create mode 100644 mysql-test/suite/perfschema/include/rpl_statements_truncate.inc create mode 100644 mysql-test/suite/perfschema/include/schema.inc create mode 100644 mysql-test/suite/perfschema/include/setup_helper.inc create mode 100644 mysql-test/suite/perfschema/include/show_aggregate.inc create mode 100644 mysql-test/suite/perfschema/include/show_plugin_verifier.inc create mode 100644 mysql-test/suite/perfschema/include/show_transaction_gtid.inc create mode 100644 mysql-test/suite/perfschema/include/socket_check1.inc create mode 100644 mysql-test/suite/perfschema/include/socket_event.inc create mode 100644 mysql-test/suite/perfschema/include/socket_event_dbg.inc create mode 100644 mysql-test/suite/perfschema/include/socket_ipv6.inc create mode 100644 mysql-test/suite/perfschema/include/socket_summary_check.inc create mode 100644 mysql-test/suite/perfschema/include/socket_summary_check_dbg.inc create mode 100644 mysql-test/suite/perfschema/include/stage_cleanup.inc create mode 100644 mysql-test/suite/perfschema/include/stage_setup.inc create mode 100644 mysql-test/suite/perfschema/include/start_server_common.inc create mode 100644 mysql-test/suite/perfschema/include/table_aggregate_cleanup.inc create mode 100644 mysql-test/suite/perfschema/include/table_aggregate_load.inc create mode 100644 mysql-test/suite/perfschema/include/table_aggregate_setup.inc create mode 100644 mysql-test/suite/perfschema/include/table_io_basic_dml.inc create mode 100644 mysql-test/suite/perfschema/include/table_io_cleanup_helper.inc create mode 100644 mysql-test/suite/perfschema/include/table_io_result_helper.inc create mode 100644 mysql-test/suite/perfschema/include/table_io_setup_helper.inc create mode 100644 mysql-test/suite/perfschema/include/transaction_cleanup.inc create mode 100644 mysql-test/suite/perfschema/include/transaction_nested_events_verifier.inc create mode 100644 mysql-test/suite/perfschema/include/transaction_setup.inc create mode 100644 mysql-test/suite/perfschema/include/upgrade_check.inc create mode 100644 mysql-test/suite/perfschema/include/wait_for_pfs_thread_count.inc create mode 100644 mysql-test/suite/perfschema/include/wait_till_sleep.inc create mode 100644 mysql-test/suite/perfschema/r/all_tests.result create mode 100644 mysql-test/suite/perfschema/r/alter_table_progress.result create mode 100644 mysql-test/suite/perfschema/r/bad_option.result create mode 100644 mysql-test/suite/perfschema/r/batch_table_io_func.result create mode 100644 mysql-test/suite/perfschema/r/binlog_edge_mix.result create mode 100644 mysql-test/suite/perfschema/r/binlog_edge_row.result create mode 100644 mysql-test/suite/perfschema/r/binlog_edge_stmt.result create mode 100644 mysql-test/suite/perfschema/r/binlog_mix.result create mode 100644 mysql-test/suite/perfschema/r/binlog_ok_mix.result create mode 100644 mysql-test/suite/perfschema/r/binlog_ok_row.result create mode 100644 mysql-test/suite/perfschema/r/binlog_ok_stmt.result create mode 100644 mysql-test/suite/perfschema/r/binlog_row.result create mode 100644 mysql-test/suite/perfschema/r/binlog_stmt.result create mode 100644 mysql-test/suite/perfschema/r/checksum.result create mode 100644 mysql-test/suite/perfschema/r/cnf_option.result create mode 100644 mysql-test/suite/perfschema/r/column_privilege.result create mode 100644 mysql-test/suite/perfschema/r/connect_attrs.result create mode 100644 mysql-test/suite/perfschema/r/connection.result create mode 100644 mysql-test/suite/perfschema/r/connection_3a.result create mode 100644 mysql-test/suite/perfschema/r/connection_3a_3u.result create mode 100644 mysql-test/suite/perfschema/r/connection_3u.result create mode 100644 mysql-test/suite/perfschema/r/connection_type_notwin.result create mode 100644 mysql-test/suite/perfschema/r/connection_type_win.result create mode 100644 mysql-test/suite/perfschema/r/csv_table_io.result create mode 100644 mysql-test/suite/perfschema/r/ddl_accounts.result create mode 100644 mysql-test/suite/perfschema/r/ddl_cond_instances.result create mode 100644 mysql-test/suite/perfschema/r/ddl_esgs_by_account_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_esgs_by_host_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_esgs_by_thread_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_esgs_by_user_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_esgs_global_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_esms_by_account_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_esms_by_digest.result create mode 100644 mysql-test/suite/perfschema/r/ddl_esms_by_host_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_esms_by_program.result create mode 100644 mysql-test/suite/perfschema/r/ddl_esms_by_thread_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_esms_by_user_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_esms_global_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_ets_by_account_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_ets_by_host_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_ets_by_thread_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_ets_by_user_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_ets_global_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_events_stages_current.result create mode 100644 mysql-test/suite/perfschema/r/ddl_events_stages_history.result create mode 100644 mysql-test/suite/perfschema/r/ddl_events_stages_history_long.result create mode 100644 mysql-test/suite/perfschema/r/ddl_events_statements_current.result create mode 100644 mysql-test/suite/perfschema/r/ddl_events_statements_history.result create mode 100644 mysql-test/suite/perfschema/r/ddl_events_statements_history_long.result create mode 100644 mysql-test/suite/perfschema/r/ddl_events_transactions_current.result create mode 100644 mysql-test/suite/perfschema/r/ddl_events_transactions_history.result create mode 100644 mysql-test/suite/perfschema/r/ddl_events_transactions_history_long.result create mode 100644 mysql-test/suite/perfschema/r/ddl_events_waits_current.result create mode 100644 mysql-test/suite/perfschema/r/ddl_events_waits_history.result create mode 100644 mysql-test/suite/perfschema/r/ddl_events_waits_history_long.result create mode 100644 mysql-test/suite/perfschema/r/ddl_ews_by_account_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_ews_by_host_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_ews_by_instance.result create mode 100644 mysql-test/suite/perfschema/r/ddl_ews_by_thread_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_ews_by_user_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_ews_global_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_file_instances.result create mode 100644 mysql-test/suite/perfschema/r/ddl_fs_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_fs_by_instance.result create mode 100644 mysql-test/suite/perfschema/r/ddl_global_status.result create mode 100644 mysql-test/suite/perfschema/r/ddl_global_variables.result create mode 100644 mysql-test/suite/perfschema/r/ddl_host_cache.result create mode 100644 mysql-test/suite/perfschema/r/ddl_hosts.result create mode 100644 mysql-test/suite/perfschema/r/ddl_mems_by_account_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_mems_by_host_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_mems_by_thread_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_mems_by_user_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_mems_global_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_metadata_locks.result create mode 100644 mysql-test/suite/perfschema/r/ddl_mutex_instances.result create mode 100644 mysql-test/suite/perfschema/r/ddl_os_global_by_type.result create mode 100644 mysql-test/suite/perfschema/r/ddl_performance_timers.result create mode 100644 mysql-test/suite/perfschema/r/ddl_prepared_statements_instances.result create mode 100644 mysql-test/suite/perfschema/r/ddl_processlist.result create mode 100644 mysql-test/suite/perfschema/r/ddl_replication_applier_configuration.result create mode 100644 mysql-test/suite/perfschema/r/ddl_replication_applier_status.result create mode 100644 mysql-test/suite/perfschema/r/ddl_replication_applier_status_by_coordinator.result create mode 100644 mysql-test/suite/perfschema/r/ddl_replication_applier_status_by_worker.result create mode 100644 mysql-test/suite/perfschema/r/ddl_replication_connection_configuration.result create mode 100644 mysql-test/suite/perfschema/r/ddl_replication_connection_status.result create mode 100644 mysql-test/suite/perfschema/r/ddl_replication_group_member_stats.result create mode 100644 mysql-test/suite/perfschema/r/ddl_replication_group_members.result create mode 100644 mysql-test/suite/perfschema/r/ddl_rwlock_instances.result create mode 100644 mysql-test/suite/perfschema/r/ddl_session_account_connect_attrs.result create mode 100644 mysql-test/suite/perfschema/r/ddl_session_connect_attrs.result create mode 100644 mysql-test/suite/perfschema/r/ddl_session_status.result create mode 100644 mysql-test/suite/perfschema/r/ddl_session_variables.result create mode 100644 mysql-test/suite/perfschema/r/ddl_setup_actors.result create mode 100644 mysql-test/suite/perfschema/r/ddl_setup_consumers.result create mode 100644 mysql-test/suite/perfschema/r/ddl_setup_instruments.result create mode 100644 mysql-test/suite/perfschema/r/ddl_setup_objects.result create mode 100644 mysql-test/suite/perfschema/r/ddl_setup_timers.result create mode 100644 mysql-test/suite/perfschema/r/ddl_socket_instances.result create mode 100644 mysql-test/suite/perfschema/r/ddl_socket_summary_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/ddl_socket_summary_by_instance.result create mode 100644 mysql-test/suite/perfschema/r/ddl_status_by_account.result create mode 100644 mysql-test/suite/perfschema/r/ddl_status_by_host.result create mode 100644 mysql-test/suite/perfschema/r/ddl_status_by_thread.result create mode 100644 mysql-test/suite/perfschema/r/ddl_status_by_user.result create mode 100644 mysql-test/suite/perfschema/r/ddl_table_handles.result create mode 100644 mysql-test/suite/perfschema/r/ddl_threads.result create mode 100644 mysql-test/suite/perfschema/r/ddl_tiws_by_index_usage.result create mode 100644 mysql-test/suite/perfschema/r/ddl_tiws_by_table.result create mode 100644 mysql-test/suite/perfschema/r/ddl_tlws_by_table.result create mode 100644 mysql-test/suite/perfschema/r/ddl_users.result create mode 100644 mysql-test/suite/perfschema/r/ddl_uvar_by_thread.result create mode 100644 mysql-test/suite/perfschema/r/ddl_variables_by_thread.result create mode 100644 mysql-test/suite/perfschema/r/digest_null_literal.result create mode 100644 mysql-test/suite/perfschema/r/digest_table_full.result create mode 100644 mysql-test/suite/perfschema/r/digest_view.result create mode 100644 mysql-test/suite/perfschema/r/discovery.result create mode 100644 mysql-test/suite/perfschema/r/dml_accounts.result create mode 100644 mysql-test/suite/perfschema/r/dml_cond_instances.result create mode 100644 mysql-test/suite/perfschema/r/dml_esgs_by_account_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_esgs_by_host_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_esgs_by_thread_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_esgs_by_user_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_esgs_global_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_esms_by_account_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_esms_by_digest.result create mode 100644 mysql-test/suite/perfschema/r/dml_esms_by_host_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_esms_by_program.result create mode 100644 mysql-test/suite/perfschema/r/dml_esms_by_thread_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_esms_by_user_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_esms_global_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_ets_by_account_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_ets_by_host_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_ets_by_thread_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_ets_by_user_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_ets_global_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_events_stages_current.result create mode 100644 mysql-test/suite/perfschema/r/dml_events_stages_history.result create mode 100644 mysql-test/suite/perfschema/r/dml_events_stages_history_long.result create mode 100644 mysql-test/suite/perfschema/r/dml_events_statements_current.result create mode 100644 mysql-test/suite/perfschema/r/dml_events_statements_history.result create mode 100644 mysql-test/suite/perfschema/r/dml_events_statements_history_long.result create mode 100644 mysql-test/suite/perfschema/r/dml_events_transactions_current.result create mode 100644 mysql-test/suite/perfschema/r/dml_events_transactions_history.result create mode 100644 mysql-test/suite/perfschema/r/dml_events_transactions_history_long.result create mode 100644 mysql-test/suite/perfschema/r/dml_events_waits_current.result create mode 100644 mysql-test/suite/perfschema/r/dml_events_waits_history.result create mode 100644 mysql-test/suite/perfschema/r/dml_events_waits_history_long.result create mode 100644 mysql-test/suite/perfschema/r/dml_ews_by_account_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_ews_by_host_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_ews_by_instance.result create mode 100644 mysql-test/suite/perfschema/r/dml_ews_by_thread_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_ews_by_user_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_ews_global_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_file_instances.result create mode 100644 mysql-test/suite/perfschema/r/dml_fs_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_fs_by_instance.result create mode 100644 mysql-test/suite/perfschema/r/dml_global_status.result create mode 100644 mysql-test/suite/perfschema/r/dml_global_variables.result create mode 100644 mysql-test/suite/perfschema/r/dml_handler.result create mode 100644 mysql-test/suite/perfschema/r/dml_host_cache.result create mode 100644 mysql-test/suite/perfschema/r/dml_hosts.result create mode 100644 mysql-test/suite/perfschema/r/dml_mems_by_account_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_mems_by_host_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_mems_by_thread_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_mems_by_user_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_mems_global_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_metadata_locks.result create mode 100644 mysql-test/suite/perfschema/r/dml_mutex_instances.result create mode 100644 mysql-test/suite/perfschema/r/dml_os_global_by_type.result create mode 100644 mysql-test/suite/perfschema/r/dml_performance_timers.result create mode 100644 mysql-test/suite/perfschema/r/dml_prepared_statements_instances.result create mode 100644 mysql-test/suite/perfschema/r/dml_processlist.result create mode 100644 mysql-test/suite/perfschema/r/dml_replication_applier_configuration.result create mode 100644 mysql-test/suite/perfschema/r/dml_replication_applier_status.result create mode 100644 mysql-test/suite/perfschema/r/dml_replication_applier_status_by_coordinator.result create mode 100644 mysql-test/suite/perfschema/r/dml_replication_applier_status_by_worker.result create mode 100644 mysql-test/suite/perfschema/r/dml_replication_connection_configuration.result create mode 100644 mysql-test/suite/perfschema/r/dml_replication_connection_status.result create mode 100644 mysql-test/suite/perfschema/r/dml_replication_group_member_stats.result create mode 100644 mysql-test/suite/perfschema/r/dml_replication_group_members.result create mode 100644 mysql-test/suite/perfschema/r/dml_rwlock_instances.result create mode 100644 mysql-test/suite/perfschema/r/dml_session_account_connect_attrs.result create mode 100644 mysql-test/suite/perfschema/r/dml_session_connect_attrs.result create mode 100644 mysql-test/suite/perfschema/r/dml_session_status.result create mode 100644 mysql-test/suite/perfschema/r/dml_session_variables.result create mode 100644 mysql-test/suite/perfschema/r/dml_setup_actors.result create mode 100644 mysql-test/suite/perfschema/r/dml_setup_consumers.result create mode 100644 mysql-test/suite/perfschema/r/dml_setup_instruments.result create mode 100644 mysql-test/suite/perfschema/r/dml_setup_objects.result create mode 100644 mysql-test/suite/perfschema/r/dml_setup_timers.result create mode 100644 mysql-test/suite/perfschema/r/dml_socket_instances.result create mode 100644 mysql-test/suite/perfschema/r/dml_socket_summary_by_event_name.result create mode 100644 mysql-test/suite/perfschema/r/dml_socket_summary_by_instance.result create mode 100644 mysql-test/suite/perfschema/r/dml_status_by_account.result create mode 100644 mysql-test/suite/perfschema/r/dml_status_by_host.result create mode 100644 mysql-test/suite/perfschema/r/dml_status_by_thread.result create mode 100644 mysql-test/suite/perfschema/r/dml_status_by_user.result create mode 100644 mysql-test/suite/perfschema/r/dml_table_handles.result create mode 100644 mysql-test/suite/perfschema/r/dml_threads.result create mode 100644 mysql-test/suite/perfschema/r/dml_tiws_by_index_usage.result create mode 100644 mysql-test/suite/perfschema/r/dml_tiws_by_table.result create mode 100644 mysql-test/suite/perfschema/r/dml_tlws_by_table.result create mode 100644 mysql-test/suite/perfschema/r/dml_users.result create mode 100644 mysql-test/suite/perfschema/r/dml_uvar_by_thread.result create mode 100644 mysql-test/suite/perfschema/r/dml_variables_by_thread.result create mode 100644 mysql-test/suite/perfschema/r/event_aggregate.result create mode 100644 mysql-test/suite/perfschema/r/event_aggregate_no_a.result create mode 100644 mysql-test/suite/perfschema/r/event_aggregate_no_a_no_h.result create mode 100644 mysql-test/suite/perfschema/r/event_aggregate_no_a_no_u.result create mode 100644 mysql-test/suite/perfschema/r/event_aggregate_no_a_no_u_no_h.result create mode 100644 mysql-test/suite/perfschema/r/event_aggregate_no_h.result create mode 100644 mysql-test/suite/perfschema/r/event_aggregate_no_u.result create mode 100644 mysql-test/suite/perfschema/r/event_aggregate_no_u_no_h.result create mode 100644 mysql-test/suite/perfschema/r/file_misc.result create mode 100644 mysql-test/suite/perfschema/r/func_file_io.result create mode 100644 mysql-test/suite/perfschema/r/func_mutex.result create mode 100644 mysql-test/suite/perfschema/r/global_objects.result create mode 100644 mysql-test/suite/perfschema/r/global_read_lock.result create mode 100644 mysql-test/suite/perfschema/r/grant.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv4_addrinfo_again_allow.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv4_addrinfo_again_deny.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv4_addrinfo_bad_allow.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv4_addrinfo_bad_deny.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv4_addrinfo_good_allow.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv4_addrinfo_good_deny.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv4_addrinfo_noname_allow.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv4_addrinfo_noname_deny.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv4_auth_ed25519.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv4_auth_plugin.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv4_blocked.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv4_format.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv4_max_con.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv4_nameinfo_again_allow.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv4_nameinfo_again_deny.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv4_nameinfo_noname_allow.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv4_nameinfo_noname_deny.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv4_passwd.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv4_ssl.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv6_addrinfo_again_allow.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv6_addrinfo_again_deny.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv6_addrinfo_bad_allow.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv6_addrinfo_bad_deny.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv6_addrinfo_good_allow.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv6_addrinfo_good_deny.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv6_addrinfo_noname_allow.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv6_addrinfo_noname_deny.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv6_auth_plugin.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv6_blocked.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv6_max_con.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv6_nameinfo_again_allow.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv6_nameinfo_again_deny.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv6_nameinfo_noname_allow.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv6_nameinfo_noname_deny.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv6_passwd.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_ipv6_ssl.result create mode 100644 mysql-test/suite/perfschema/r/hostcache_peer_addr.result create mode 100644 mysql-test/suite/perfschema/r/indexed_table_io.result create mode 100644 mysql-test/suite/perfschema/r/information_schema.result create mode 100644 mysql-test/suite/perfschema/r/innodb_events_transactions_history_long.result create mode 100644 mysql-test/suite/perfschema/r/innodb_table_io.result create mode 100644 mysql-test/suite/perfschema/r/io_cache.result create mode 100644 mysql-test/suite/perfschema/r/max_program_zero.result create mode 100644 mysql-test/suite/perfschema/r/mdl_func.result create mode 100644 mysql-test/suite/perfschema/r/memory_aggregate.result create mode 100644 mysql-test/suite/perfschema/r/memory_aggregate_32bit.result create mode 100644 mysql-test/suite/perfschema/r/memory_aggregate_no_a.result create mode 100644 mysql-test/suite/perfschema/r/memory_aggregate_no_a_no_h.result create mode 100644 mysql-test/suite/perfschema/r/memory_aggregate_no_a_no_u.result create mode 100644 mysql-test/suite/perfschema/r/memory_aggregate_no_a_no_u_no_h.result create mode 100644 mysql-test/suite/perfschema/r/memory_aggregate_no_h.result create mode 100644 mysql-test/suite/perfschema/r/memory_aggregate_no_u.result create mode 100644 mysql-test/suite/perfschema/r/memory_aggregate_no_u_no_h.result create mode 100644 mysql-test/suite/perfschema/r/memory_table_io.result create mode 100644 mysql-test/suite/perfschema/r/merge_table_io.result create mode 100644 mysql-test/suite/perfschema/r/misc.result create mode 100644 mysql-test/suite/perfschema/r/misc_global_status.result create mode 100644 mysql-test/suite/perfschema/r/mks_timer-6258.result create mode 100644 mysql-test/suite/perfschema/r/multi_table_io.result create mode 100644 mysql-test/suite/perfschema/r/myisam_file_io.result create mode 100644 mysql-test/suite/perfschema/r/myisam_table_io.result create mode 100644 mysql-test/suite/perfschema/r/nesting.result create mode 100644 mysql-test/suite/perfschema/r/no_threads.result create mode 100644 mysql-test/suite/perfschema/r/one_thread_per_con.result create mode 100644 mysql-test/suite/perfschema/r/ortho_iter.result create mode 100644 mysql-test/suite/perfschema/r/part_table_io.result create mode 100644 mysql-test/suite/perfschema/r/partition.result create mode 100644 mysql-test/suite/perfschema/r/pfs_upgrade_event.result create mode 100644 mysql-test/suite/perfschema/r/pfs_upgrade_func.result create mode 100644 mysql-test/suite/perfschema/r/pfs_upgrade_proc.result create mode 100644 mysql-test/suite/perfschema/r/pfs_upgrade_table.result create mode 100644 mysql-test/suite/perfschema/r/pfs_upgrade_view.result create mode 100644 mysql-test/suite/perfschema/r/prepared_statements.result create mode 100644 mysql-test/suite/perfschema/r/prepared_stmts_by_stored_programs.result create mode 100644 mysql-test/suite/perfschema/r/privilege.result create mode 100644 mysql-test/suite/perfschema/r/privilege_table_io.result create mode 100644 mysql-test/suite/perfschema/r/processlist.result create mode 100644 mysql-test/suite/perfschema/r/processlist_57.result create mode 100644 mysql-test/suite/perfschema/r/processlist_acl.result create mode 100644 mysql-test/suite/perfschema/r/processlist_anonymous.result create mode 100644 mysql-test/suite/perfschema/r/processlist_no_pfs.result create mode 100644 mysql-test/suite/perfschema/r/processlist_port.result create mode 100644 mysql-test/suite/perfschema/r/processlist_reg_user.result create mode 100644 mysql-test/suite/perfschema/r/query_cache.result create mode 100644 mysql-test/suite/perfschema/r/read_only.result create mode 100644 mysql-test/suite/perfschema/r/relaylog.result create mode 100644 mysql-test/suite/perfschema/r/rollback_table_io.result create mode 100644 mysql-test/suite/perfschema/r/rpl_group_member_stats.result create mode 100644 mysql-test/suite/perfschema/r/rpl_group_members.result create mode 100644 mysql-test/suite/perfschema/r/rpl_gtid_func.result create mode 100644 mysql-test/suite/perfschema/r/rpl_statements.result create mode 100644 mysql-test/suite/perfschema/r/rpl_threads.result create mode 100644 mysql-test/suite/perfschema/r/schema.result create mode 100644 mysql-test/suite/perfschema/r/selects.result create mode 100644 mysql-test/suite/perfschema/r/server_init.result create mode 100644 mysql-test/suite/perfschema/r/setup_actors.result create mode 100644 mysql-test/suite/perfschema/r/setup_actors_enabled.result create mode 100644 mysql-test/suite/perfschema/r/setup_actors_history.result create mode 100644 mysql-test/suite/perfschema/r/setup_consumers_defaults.result create mode 100644 mysql-test/suite/perfschema/r/setup_instruments_defaults.result create mode 100644 mysql-test/suite/perfschema/r/setup_object_table_lock_io.result create mode 100644 mysql-test/suite/perfschema/r/setup_objects.result create mode 100644 mysql-test/suite/perfschema/r/short_option_1.result create mode 100644 mysql-test/suite/perfschema/r/short_option_2.result create mode 100644 mysql-test/suite/perfschema/r/show_aggregate.result create mode 100644 mysql-test/suite/perfschema/r/show_coverage.result create mode 100644 mysql-test/suite/perfschema/r/show_misc.result create mode 100644 mysql-test/suite/perfschema/r/show_plugin.result create mode 100644 mysql-test/suite/perfschema/r/show_sanity.result create mode 100644 mysql-test/suite/perfschema/r/socket_connect.result create mode 100644 mysql-test/suite/perfschema/r/socket_instances_func.result create mode 100644 mysql-test/suite/perfschema/r/socket_instances_func_win.result create mode 100644 mysql-test/suite/perfschema/r/socket_summary_by_event_name_func.result create mode 100644 mysql-test/suite/perfschema/r/socket_summary_by_instance_func.result create mode 100644 mysql-test/suite/perfschema/r/socket_summary_by_instance_func_win.result create mode 100644 mysql-test/suite/perfschema/r/stage_mdl_function.result create mode 100644 mysql-test/suite/perfschema/r/stage_mdl_global.result create mode 100644 mysql-test/suite/perfschema/r/stage_mdl_procedure.result create mode 100644 mysql-test/suite/perfschema/r/stage_mdl_table.result create mode 100644 mysql-test/suite/perfschema/r/start_server_1_digest.result create mode 100644 mysql-test/suite/perfschema/r/start_server_disable_idle.result create mode 100644 mysql-test/suite/perfschema/r/start_server_disable_stages.result create mode 100644 mysql-test/suite/perfschema/r/start_server_disable_statements.result create mode 100644 mysql-test/suite/perfschema/r/start_server_disable_transactions.result create mode 100644 mysql-test/suite/perfschema/r/start_server_disable_waits.result create mode 100644 mysql-test/suite/perfschema/r/start_server_innodb.result create mode 100644 mysql-test/suite/perfschema/r/start_server_low_digest.result create mode 100644 mysql-test/suite/perfschema/r/start_server_low_digest_sql_length.result create mode 100644 mysql-test/suite/perfschema/r/start_server_low_index.result create mode 100644 mysql-test/suite/perfschema/r/start_server_low_table_lock.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_account.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_cond_class.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_cond_inst.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_digests.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_file_class.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_file_inst.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_host.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_index.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_mdl.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_memory_class.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_mutex_class.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_mutex_inst.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_prepared_stmts_instances.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_rwlock_class.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_rwlock_inst.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_setup_actors.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_setup_objects.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_socket_class.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_socket_inst.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_stage_class.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_stages_history.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_stages_history_long.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_statement_class.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_statements_history.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_statements_history_long.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_table_hdl.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_table_inst.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_table_lock.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_thread_class.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_thread_inst.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_transactions_history.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_transactions_history_long.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_user.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_waits_history.result create mode 100644 mysql-test/suite/perfschema/r/start_server_no_waits_history_long.result create mode 100644 mysql-test/suite/perfschema/r/start_server_nothing.result create mode 100644 mysql-test/suite/perfschema/r/start_server_off.result create mode 100644 mysql-test/suite/perfschema/r/start_server_on.result create mode 100644 mysql-test/suite/perfschema/r/start_server_variables.result create mode 100644 mysql-test/suite/perfschema/r/start_server_zero_digest_sql_length.result create mode 100644 mysql-test/suite/perfschema/r/statement_digest.result create mode 100644 mysql-test/suite/perfschema/r/statement_digest_charset.result create mode 100644 mysql-test/suite/perfschema/r/statement_digest_consumers.result create mode 100644 mysql-test/suite/perfschema/r/statement_digest_consumers2.result create mode 100644 mysql-test/suite/perfschema/r/statement_digest_long_query.result create mode 100644 mysql-test/suite/perfschema/r/statement_program_concurrency.result create mode 100644 mysql-test/suite/perfschema/r/statement_program_lost_inst.result create mode 100644 mysql-test/suite/perfschema/r/statement_program_nested.result create mode 100644 mysql-test/suite/perfschema/r/statement_program_nesting_event_check.result create mode 100644 mysql-test/suite/perfschema/r/statement_program_non_nested.result create mode 100644 mysql-test/suite/perfschema/r/status_reprepare.result create mode 100644 mysql-test/suite/perfschema/r/sxlock_func.result create mode 100644 mysql-test/suite/perfschema/r/table_aggregate_global_2u_2t.result create mode 100644 mysql-test/suite/perfschema/r/table_aggregate_global_2u_3t.result create mode 100644 mysql-test/suite/perfschema/r/table_aggregate_global_4u_2t.result create mode 100644 mysql-test/suite/perfschema/r/table_aggregate_global_4u_3t.result create mode 100644 mysql-test/suite/perfschema/r/table_aggregate_hist_2u_2t.result create mode 100644 mysql-test/suite/perfschema/r/table_aggregate_hist_2u_3t.result create mode 100644 mysql-test/suite/perfschema/r/table_aggregate_hist_4u_2t.result create mode 100644 mysql-test/suite/perfschema/r/table_aggregate_hist_4u_3t.result create mode 100644 mysql-test/suite/perfschema/r/table_aggregate_off.result create mode 100644 mysql-test/suite/perfschema/r/table_aggregate_thread_2u_2t.result create mode 100644 mysql-test/suite/perfschema/r/table_aggregate_thread_2u_3t.result create mode 100644 mysql-test/suite/perfschema/r/table_aggregate_thread_4u_2t.result create mode 100644 mysql-test/suite/perfschema/r/table_aggregate_thread_4u_3t.result create mode 100644 mysql-test/suite/perfschema/r/table_io_aggregate_global_2u_2t.result create mode 100644 mysql-test/suite/perfschema/r/table_io_aggregate_global_2u_3t.result create mode 100644 mysql-test/suite/perfschema/r/table_io_aggregate_global_4u_2t.result create mode 100644 mysql-test/suite/perfschema/r/table_io_aggregate_global_4u_3t.result create mode 100644 mysql-test/suite/perfschema/r/table_io_aggregate_hist_2u_2t.result create mode 100644 mysql-test/suite/perfschema/r/table_io_aggregate_hist_2u_3t.result create mode 100644 mysql-test/suite/perfschema/r/table_io_aggregate_hist_4u_2t.result create mode 100644 mysql-test/suite/perfschema/r/table_io_aggregate_hist_4u_3t.result create mode 100644 mysql-test/suite/perfschema/r/table_io_aggregate_thread_2u_2t.result create mode 100644 mysql-test/suite/perfschema/r/table_io_aggregate_thread_2u_3t.result create mode 100644 mysql-test/suite/perfschema/r/table_io_aggregate_thread_4u_2t.result create mode 100644 mysql-test/suite/perfschema/r/table_io_aggregate_thread_4u_3t.result create mode 100644 mysql-test/suite/perfschema/r/table_lock_aggregate_global_2u_2t.result create mode 100644 mysql-test/suite/perfschema/r/table_lock_aggregate_global_2u_3t.result create mode 100644 mysql-test/suite/perfschema/r/table_lock_aggregate_global_4u_2t.result create mode 100644 mysql-test/suite/perfschema/r/table_lock_aggregate_global_4u_3t.result create mode 100644 mysql-test/suite/perfschema/r/table_lock_aggregate_hist_2u_2t.result create mode 100644 mysql-test/suite/perfschema/r/table_lock_aggregate_hist_2u_3t.result create mode 100644 mysql-test/suite/perfschema/r/table_lock_aggregate_hist_4u_2t.result create mode 100644 mysql-test/suite/perfschema/r/table_lock_aggregate_hist_4u_3t.result create mode 100644 mysql-test/suite/perfschema/r/table_lock_aggregate_thread_2u_2t.result create mode 100644 mysql-test/suite/perfschema/r/table_lock_aggregate_thread_2u_3t.result create mode 100644 mysql-test/suite/perfschema/r/table_lock_aggregate_thread_4u_2t.result create mode 100644 mysql-test/suite/perfschema/r/table_lock_aggregate_thread_4u_3t.result create mode 100644 mysql-test/suite/perfschema/r/table_name.result create mode 100644 mysql-test/suite/perfschema/r/table_schema.result create mode 100644 mysql-test/suite/perfschema/r/temp_table_io.result create mode 100644 mysql-test/suite/perfschema/r/thread_cache.result create mode 100644 mysql-test/suite/perfschema/r/thread_misc.result create mode 100644 mysql-test/suite/perfschema/r/threads_history.result create mode 100644 mysql-test/suite/perfschema/r/threads_innodb.result create mode 100644 mysql-test/suite/perfschema/r/threads_insert_delayed.result create mode 100644 mysql-test/suite/perfschema/r/threads_mysql.result create mode 100644 mysql-test/suite/perfschema/r/threads_mysql_freebsd.result create mode 100644 mysql-test/suite/perfschema/r/threads_mysql_linux.result create mode 100644 mysql-test/suite/perfschema/r/threads_mysql_windows.result create mode 100644 mysql-test/suite/perfschema/r/transaction.result create mode 100644 mysql-test/suite/perfschema/r/transaction_gtid.result create mode 100644 mysql-test/suite/perfschema/r/transaction_nested_events.result create mode 100644 mysql-test/suite/perfschema/r/trigger_table_io.result create mode 100644 mysql-test/suite/perfschema/r/unary_digest.result create mode 100644 mysql-test/suite/perfschema/r/update_order-3837.result create mode 100644 mysql-test/suite/perfschema/r/user_var_func.result create mode 100644 mysql-test/suite/perfschema/r/view_table_io.result create mode 100644 mysql-test/suite/perfschema/t/all_tests.test create mode 100644 mysql-test/suite/perfschema/t/alter_table_progress.test create mode 100644 mysql-test/suite/perfschema/t/bad_option.test create mode 100644 mysql-test/suite/perfschema/t/batch_table_io_func.test create mode 100644 mysql-test/suite/perfschema/t/binlog_edge_mix-master.opt create mode 100644 mysql-test/suite/perfschema/t/binlog_edge_mix.test create mode 100644 mysql-test/suite/perfschema/t/binlog_edge_row-master.opt create mode 100644 mysql-test/suite/perfschema/t/binlog_edge_row.test create mode 100644 mysql-test/suite/perfschema/t/binlog_edge_stmt-master.opt create mode 100644 mysql-test/suite/perfschema/t/binlog_edge_stmt.test create mode 100644 mysql-test/suite/perfschema/t/binlog_mix.test create mode 100644 mysql-test/suite/perfschema/t/binlog_ok_mix-master.opt create mode 100644 mysql-test/suite/perfschema/t/binlog_ok_mix.test create mode 100644 mysql-test/suite/perfschema/t/binlog_ok_row-master.opt create mode 100644 mysql-test/suite/perfschema/t/binlog_ok_row.test create mode 100644 mysql-test/suite/perfschema/t/binlog_ok_stmt-master.opt create mode 100644 mysql-test/suite/perfschema/t/binlog_ok_stmt.test create mode 100644 mysql-test/suite/perfschema/t/binlog_row.test create mode 100644 mysql-test/suite/perfschema/t/binlog_stmt.test create mode 100644 mysql-test/suite/perfschema/t/checksum.test create mode 100644 mysql-test/suite/perfschema/t/cnf_option.cnf create mode 100644 mysql-test/suite/perfschema/t/cnf_option.test create mode 100644 mysql-test/suite/perfschema/t/column_privilege.test create mode 100644 mysql-test/suite/perfschema/t/connect_attrs.test create mode 100644 mysql-test/suite/perfschema/t/connection.test create mode 100644 mysql-test/suite/perfschema/t/connection_3a-master.opt create mode 100644 mysql-test/suite/perfschema/t/connection_3a.test create mode 100644 mysql-test/suite/perfschema/t/connection_3a_3u-master.opt create mode 100644 mysql-test/suite/perfschema/t/connection_3a_3u.test create mode 100644 mysql-test/suite/perfschema/t/connection_3u-master.opt create mode 100644 mysql-test/suite/perfschema/t/connection_3u.test create mode 100644 mysql-test/suite/perfschema/t/connection_type_notwin.test create mode 100644 mysql-test/suite/perfschema/t/connection_type_win.test create mode 100644 mysql-test/suite/perfschema/t/csv_table_io.test create mode 100644 mysql-test/suite/perfschema/t/ddl_accounts.test create mode 100644 mysql-test/suite/perfschema/t/ddl_cond_instances.test create mode 100644 mysql-test/suite/perfschema/t/ddl_esgs_by_account_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_esgs_by_host_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_esgs_by_thread_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_esgs_by_user_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_esgs_global_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_esms_by_account_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_esms_by_digest.test create mode 100644 mysql-test/suite/perfschema/t/ddl_esms_by_host_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_esms_by_program.test create mode 100644 mysql-test/suite/perfschema/t/ddl_esms_by_thread_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_esms_by_user_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_esms_global_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_ets_by_account_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_ets_by_host_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_ets_by_thread_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_ets_by_user_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_ets_global_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_events_stages_current.test create mode 100644 mysql-test/suite/perfschema/t/ddl_events_stages_history.test create mode 100644 mysql-test/suite/perfschema/t/ddl_events_stages_history_long.test create mode 100644 mysql-test/suite/perfschema/t/ddl_events_statements_current.test create mode 100644 mysql-test/suite/perfschema/t/ddl_events_statements_history.test create mode 100644 mysql-test/suite/perfschema/t/ddl_events_statements_history_long.test create mode 100644 mysql-test/suite/perfschema/t/ddl_events_transactions_current.test create mode 100644 mysql-test/suite/perfschema/t/ddl_events_transactions_history.test create mode 100644 mysql-test/suite/perfschema/t/ddl_events_transactions_history_long.test create mode 100644 mysql-test/suite/perfschema/t/ddl_events_waits_current.test create mode 100644 mysql-test/suite/perfschema/t/ddl_events_waits_history.test create mode 100644 mysql-test/suite/perfschema/t/ddl_events_waits_history_long.test create mode 100644 mysql-test/suite/perfschema/t/ddl_ews_by_account_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_ews_by_host_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_ews_by_instance.test create mode 100644 mysql-test/suite/perfschema/t/ddl_ews_by_thread_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_ews_by_user_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_ews_global_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_file_instances.test create mode 100644 mysql-test/suite/perfschema/t/ddl_fs_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_fs_by_instance.test create mode 100644 mysql-test/suite/perfschema/t/ddl_global_status.test create mode 100644 mysql-test/suite/perfschema/t/ddl_global_variables.test create mode 100644 mysql-test/suite/perfschema/t/ddl_host_cache.test create mode 100644 mysql-test/suite/perfschema/t/ddl_hosts.test create mode 100644 mysql-test/suite/perfschema/t/ddl_mems_by_account_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_mems_by_host_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_mems_by_thread_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_mems_by_user_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_mems_global_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_metadata_locks.test create mode 100644 mysql-test/suite/perfschema/t/ddl_mutex_instances.test create mode 100644 mysql-test/suite/perfschema/t/ddl_os_global_by_type.test create mode 100644 mysql-test/suite/perfschema/t/ddl_performance_timers.test create mode 100644 mysql-test/suite/perfschema/t/ddl_prepared_statements_instances.test create mode 100644 mysql-test/suite/perfschema/t/ddl_processlist.test create mode 100644 mysql-test/suite/perfschema/t/ddl_replication_applier_configuration.test create mode 100644 mysql-test/suite/perfschema/t/ddl_replication_applier_status.test create mode 100644 mysql-test/suite/perfschema/t/ddl_replication_applier_status_by_coordinator.test create mode 100644 mysql-test/suite/perfschema/t/ddl_replication_applier_status_by_worker.test create mode 100644 mysql-test/suite/perfschema/t/ddl_replication_connection_configuration.test create mode 100644 mysql-test/suite/perfschema/t/ddl_replication_connection_status.test create mode 100644 mysql-test/suite/perfschema/t/ddl_replication_group_member_stats.test create mode 100644 mysql-test/suite/perfschema/t/ddl_replication_group_members.test create mode 100644 mysql-test/suite/perfschema/t/ddl_rwlock_instances.test create mode 100644 mysql-test/suite/perfschema/t/ddl_session_account_connect_attrs.test create mode 100644 mysql-test/suite/perfschema/t/ddl_session_connect_attrs.test create mode 100644 mysql-test/suite/perfschema/t/ddl_session_status.test create mode 100644 mysql-test/suite/perfschema/t/ddl_session_variables.test create mode 100644 mysql-test/suite/perfschema/t/ddl_setup_actors.test create mode 100644 mysql-test/suite/perfschema/t/ddl_setup_consumers.test create mode 100644 mysql-test/suite/perfschema/t/ddl_setup_instruments.test create mode 100644 mysql-test/suite/perfschema/t/ddl_setup_objects.test create mode 100644 mysql-test/suite/perfschema/t/ddl_setup_timers.test create mode 100644 mysql-test/suite/perfschema/t/ddl_socket_instances.test create mode 100644 mysql-test/suite/perfschema/t/ddl_socket_summary_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/ddl_socket_summary_by_instance.test create mode 100644 mysql-test/suite/perfschema/t/ddl_status_by_account.test create mode 100644 mysql-test/suite/perfschema/t/ddl_status_by_host.test create mode 100644 mysql-test/suite/perfschema/t/ddl_status_by_thread.test create mode 100644 mysql-test/suite/perfschema/t/ddl_status_by_user.test create mode 100644 mysql-test/suite/perfschema/t/ddl_table_handles.test create mode 100644 mysql-test/suite/perfschema/t/ddl_threads.test create mode 100644 mysql-test/suite/perfschema/t/ddl_tiws_by_index_usage.test create mode 100644 mysql-test/suite/perfschema/t/ddl_tiws_by_table.test create mode 100644 mysql-test/suite/perfschema/t/ddl_tlws_by_table.test create mode 100644 mysql-test/suite/perfschema/t/ddl_users.test create mode 100644 mysql-test/suite/perfschema/t/ddl_uvar_by_thread.test create mode 100644 mysql-test/suite/perfschema/t/ddl_variables_by_thread.test create mode 100644 mysql-test/suite/perfschema/t/digest_null_literal.test create mode 100644 mysql-test/suite/perfschema/t/digest_table_full-master.opt create mode 100644 mysql-test/suite/perfschema/t/digest_table_full.test create mode 100644 mysql-test/suite/perfschema/t/digest_view.test create mode 100644 mysql-test/suite/perfschema/t/disabled.def create mode 100644 mysql-test/suite/perfschema/t/discovery.test create mode 100644 mysql-test/suite/perfschema/t/dml_accounts.test create mode 100644 mysql-test/suite/perfschema/t/dml_cond_instances.test create mode 100644 mysql-test/suite/perfschema/t/dml_esgs_by_account_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_esgs_by_host_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_esgs_by_thread_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_esgs_by_user_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_esgs_global_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_esms_by_account_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_esms_by_digest.test create mode 100644 mysql-test/suite/perfschema/t/dml_esms_by_host_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_esms_by_program.test create mode 100644 mysql-test/suite/perfschema/t/dml_esms_by_thread_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_esms_by_user_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_esms_global_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_ets_by_account_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_ets_by_host_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_ets_by_thread_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_ets_by_user_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_ets_global_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_events_stages_current.test create mode 100644 mysql-test/suite/perfschema/t/dml_events_stages_history.test create mode 100644 mysql-test/suite/perfschema/t/dml_events_stages_history_long.test create mode 100644 mysql-test/suite/perfschema/t/dml_events_statements_current.test create mode 100644 mysql-test/suite/perfschema/t/dml_events_statements_history.test create mode 100644 mysql-test/suite/perfschema/t/dml_events_statements_history_long.test create mode 100644 mysql-test/suite/perfschema/t/dml_events_transactions_current.test create mode 100644 mysql-test/suite/perfschema/t/dml_events_transactions_history.test create mode 100644 mysql-test/suite/perfschema/t/dml_events_transactions_history_long.test create mode 100644 mysql-test/suite/perfschema/t/dml_events_waits_current.test create mode 100644 mysql-test/suite/perfschema/t/dml_events_waits_history.test create mode 100644 mysql-test/suite/perfschema/t/dml_events_waits_history_long.test create mode 100644 mysql-test/suite/perfschema/t/dml_ews_by_account_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_ews_by_host_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_ews_by_instance.test create mode 100644 mysql-test/suite/perfschema/t/dml_ews_by_thread_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_ews_by_user_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_ews_global_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_file_instances.test create mode 100644 mysql-test/suite/perfschema/t/dml_fs_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_fs_by_instance.test create mode 100644 mysql-test/suite/perfschema/t/dml_global_status.test create mode 100644 mysql-test/suite/perfschema/t/dml_global_variables.test create mode 100644 mysql-test/suite/perfschema/t/dml_handler.test create mode 100644 mysql-test/suite/perfschema/t/dml_host_cache.test create mode 100644 mysql-test/suite/perfschema/t/dml_hosts.test create mode 100644 mysql-test/suite/perfschema/t/dml_mems_by_account_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_mems_by_host_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_mems_by_thread_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_mems_by_user_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_mems_global_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_metadata_locks.test create mode 100644 mysql-test/suite/perfschema/t/dml_mutex_instances.test create mode 100644 mysql-test/suite/perfschema/t/dml_os_global_by_type.test create mode 100644 mysql-test/suite/perfschema/t/dml_performance_timers.test create mode 100644 mysql-test/suite/perfschema/t/dml_prepared_statements_instances.test create mode 100644 mysql-test/suite/perfschema/t/dml_processlist.test create mode 100644 mysql-test/suite/perfschema/t/dml_replication_applier_configuration.test create mode 100644 mysql-test/suite/perfschema/t/dml_replication_applier_status.test create mode 100644 mysql-test/suite/perfschema/t/dml_replication_applier_status_by_coordinator.test create mode 100644 mysql-test/suite/perfschema/t/dml_replication_applier_status_by_worker.test create mode 100644 mysql-test/suite/perfschema/t/dml_replication_connection_configuration.test create mode 100644 mysql-test/suite/perfschema/t/dml_replication_connection_status.test create mode 100644 mysql-test/suite/perfschema/t/dml_replication_group_member_stats.test create mode 100644 mysql-test/suite/perfschema/t/dml_replication_group_members.test create mode 100644 mysql-test/suite/perfschema/t/dml_rwlock_instances.test create mode 100644 mysql-test/suite/perfschema/t/dml_session_account_connect_attrs.test create mode 100644 mysql-test/suite/perfschema/t/dml_session_connect_attrs.test create mode 100644 mysql-test/suite/perfschema/t/dml_session_status.test create mode 100644 mysql-test/suite/perfschema/t/dml_session_variables.test create mode 100644 mysql-test/suite/perfschema/t/dml_setup_actors.test create mode 100644 mysql-test/suite/perfschema/t/dml_setup_consumers.test create mode 100644 mysql-test/suite/perfschema/t/dml_setup_instruments.test create mode 100644 mysql-test/suite/perfschema/t/dml_setup_objects.test create mode 100644 mysql-test/suite/perfschema/t/dml_setup_timers.test create mode 100644 mysql-test/suite/perfschema/t/dml_socket_instances.test create mode 100644 mysql-test/suite/perfschema/t/dml_socket_summary_by_event_name.test create mode 100644 mysql-test/suite/perfschema/t/dml_socket_summary_by_instance.test create mode 100644 mysql-test/suite/perfschema/t/dml_status_by_account.test create mode 100644 mysql-test/suite/perfschema/t/dml_status_by_host.test create mode 100644 mysql-test/suite/perfschema/t/dml_status_by_thread.test create mode 100644 mysql-test/suite/perfschema/t/dml_status_by_user.test create mode 100644 mysql-test/suite/perfschema/t/dml_table_handles.test create mode 100644 mysql-test/suite/perfschema/t/dml_threads.test create mode 100644 mysql-test/suite/perfschema/t/dml_tiws_by_index_usage.test create mode 100644 mysql-test/suite/perfschema/t/dml_tiws_by_table.test create mode 100644 mysql-test/suite/perfschema/t/dml_tlws_by_table.test create mode 100644 mysql-test/suite/perfschema/t/dml_users.test create mode 100644 mysql-test/suite/perfschema/t/dml_uvar_by_thread.test create mode 100644 mysql-test/suite/perfschema/t/dml_variables_by_thread.test create mode 100644 mysql-test/suite/perfschema/t/event_aggregate-master.opt create mode 100644 mysql-test/suite/perfschema/t/event_aggregate.test create mode 100644 mysql-test/suite/perfschema/t/event_aggregate_no_a-master.opt create mode 100644 mysql-test/suite/perfschema/t/event_aggregate_no_a.test create mode 100644 mysql-test/suite/perfschema/t/event_aggregate_no_a_no_h-master.opt create mode 100644 mysql-test/suite/perfschema/t/event_aggregate_no_a_no_h.test create mode 100644 mysql-test/suite/perfschema/t/event_aggregate_no_a_no_u-master.opt create mode 100644 mysql-test/suite/perfschema/t/event_aggregate_no_a_no_u.test create mode 100644 mysql-test/suite/perfschema/t/event_aggregate_no_a_no_u_no_h-master.opt create mode 100644 mysql-test/suite/perfschema/t/event_aggregate_no_a_no_u_no_h.test create mode 100644 mysql-test/suite/perfschema/t/event_aggregate_no_h-master.opt create mode 100644 mysql-test/suite/perfschema/t/event_aggregate_no_h.test create mode 100644 mysql-test/suite/perfschema/t/event_aggregate_no_u-master.opt create mode 100644 mysql-test/suite/perfschema/t/event_aggregate_no_u.test create mode 100644 mysql-test/suite/perfschema/t/event_aggregate_no_u_no_h-master.opt create mode 100644 mysql-test/suite/perfschema/t/event_aggregate_no_u_no_h.test create mode 100644 mysql-test/suite/perfschema/t/file_misc-master.opt create mode 100644 mysql-test/suite/perfschema/t/file_misc.test create mode 100644 mysql-test/suite/perfschema/t/func_file_io.test create mode 100644 mysql-test/suite/perfschema/t/func_mutex.test create mode 100644 mysql-test/suite/perfschema/t/global_objects-master.opt create mode 100644 mysql-test/suite/perfschema/t/global_objects.test create mode 100644 mysql-test/suite/perfschema/t/global_read_lock.test create mode 100644 mysql-test/suite/perfschema/t/grant.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_again_allow.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_again_deny.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_bad_allow.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_bad_deny.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_good_allow.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_good_deny.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_noname_allow.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_addrinfo_noname_deny.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_auth_ed25519.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_auth_plugin.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_blocked.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_format.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_max_con-master.opt create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_max_con.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_nameinfo_again_allow.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_nameinfo_again_deny.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_nameinfo_noname_allow.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_nameinfo_noname_deny.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_passwd.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv4_ssl.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_again_allow-master.opt create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_again_allow.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_again_deny-master.opt create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_again_deny.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_bad_allow-master.opt create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_bad_allow.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_bad_deny-master.opt create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_bad_deny.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_good_allow-master.opt create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_good_allow.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_good_deny-master.opt create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_good_deny.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_noname_allow-master.opt create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_noname_allow.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_noname_deny-master.opt create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_addrinfo_noname_deny.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_auth_plugin-master.opt create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_auth_plugin.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_blocked-master.opt create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_blocked.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_max_con-master.opt create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_max_con.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_nameinfo_again_allow-master.opt create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_nameinfo_again_allow.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_nameinfo_again_deny-master.opt create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_nameinfo_again_deny.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_nameinfo_noname_allow-master.opt create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_nameinfo_noname_allow.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_nameinfo_noname_deny-master.opt create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_nameinfo_noname_deny.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_passwd-master.opt create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_passwd.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_ssl-master.opt create mode 100644 mysql-test/suite/perfschema/t/hostcache_ipv6_ssl.test create mode 100644 mysql-test/suite/perfschema/t/hostcache_peer_addr.test create mode 100644 mysql-test/suite/perfschema/t/indexed_table_io.test create mode 100644 mysql-test/suite/perfschema/t/information_schema.test create mode 100644 mysql-test/suite/perfschema/t/innodb_events_transactions_history_long.test create mode 100644 mysql-test/suite/perfschema/t/innodb_table_io.test create mode 100644 mysql-test/suite/perfschema/t/io_cache-master.opt create mode 100644 mysql-test/suite/perfschema/t/io_cache.test create mode 100644 mysql-test/suite/perfschema/t/max_program_zero-master.opt create mode 100644 mysql-test/suite/perfschema/t/max_program_zero.test create mode 100644 mysql-test/suite/perfschema/t/mdl_func.test create mode 100644 mysql-test/suite/perfschema/t/memory_aggregate-master.opt create mode 100644 mysql-test/suite/perfschema/t/memory_aggregate.test create mode 100644 mysql-test/suite/perfschema/t/memory_aggregate_32bit-master.opt create mode 100644 mysql-test/suite/perfschema/t/memory_aggregate_32bit.test create mode 100644 mysql-test/suite/perfschema/t/memory_aggregate_no_a-master.opt create mode 100644 mysql-test/suite/perfschema/t/memory_aggregate_no_a.test create mode 100644 mysql-test/suite/perfschema/t/memory_aggregate_no_a_no_h-master.opt create mode 100644 mysql-test/suite/perfschema/t/memory_aggregate_no_a_no_h.test create mode 100644 mysql-test/suite/perfschema/t/memory_aggregate_no_a_no_u-master.opt create mode 100644 mysql-test/suite/perfschema/t/memory_aggregate_no_a_no_u.test create mode 100644 mysql-test/suite/perfschema/t/memory_aggregate_no_a_no_u_no_h-master.opt create mode 100644 mysql-test/suite/perfschema/t/memory_aggregate_no_a_no_u_no_h.test create mode 100644 mysql-test/suite/perfschema/t/memory_aggregate_no_h-master.opt create mode 100644 mysql-test/suite/perfschema/t/memory_aggregate_no_h.test create mode 100644 mysql-test/suite/perfschema/t/memory_aggregate_no_u-master.opt create mode 100644 mysql-test/suite/perfschema/t/memory_aggregate_no_u.test create mode 100644 mysql-test/suite/perfschema/t/memory_aggregate_no_u_no_h-master.opt create mode 100644 mysql-test/suite/perfschema/t/memory_aggregate_no_u_no_h.test create mode 100644 mysql-test/suite/perfschema/t/memory_table_io.test create mode 100644 mysql-test/suite/perfschema/t/merge_table_io.test create mode 100644 mysql-test/suite/perfschema/t/misc.test create mode 100644 mysql-test/suite/perfschema/t/misc_global_status-master.opt create mode 100644 mysql-test/suite/perfschema/t/misc_global_status.test create mode 100644 mysql-test/suite/perfschema/t/mks_timer-6258.test create mode 100644 mysql-test/suite/perfschema/t/multi_table_io.test create mode 100644 mysql-test/suite/perfschema/t/myisam_file_io.opt create mode 100644 mysql-test/suite/perfschema/t/myisam_file_io.test create mode 100644 mysql-test/suite/perfschema/t/myisam_table_io.test create mode 100644 mysql-test/suite/perfschema/t/nesting.test create mode 100644 mysql-test/suite/perfschema/t/no_threads-master.opt create mode 100644 mysql-test/suite/perfschema/t/no_threads.test create mode 100644 mysql-test/suite/perfschema/t/one_thread_per_con-master.opt create mode 100644 mysql-test/suite/perfschema/t/one_thread_per_con.test create mode 100644 mysql-test/suite/perfschema/t/ortho_iter.test create mode 100644 mysql-test/suite/perfschema/t/part_table_io.test create mode 100644 mysql-test/suite/perfschema/t/partition.test create mode 100644 mysql-test/suite/perfschema/t/pfs_upgrade_event-master.opt create mode 100644 mysql-test/suite/perfschema/t/pfs_upgrade_event.test create mode 100644 mysql-test/suite/perfschema/t/pfs_upgrade_func-master.opt create mode 100644 mysql-test/suite/perfschema/t/pfs_upgrade_func.test create mode 100644 mysql-test/suite/perfschema/t/pfs_upgrade_proc-master.opt create mode 100644 mysql-test/suite/perfschema/t/pfs_upgrade_proc.test create mode 100644 mysql-test/suite/perfschema/t/pfs_upgrade_table-master.opt create mode 100644 mysql-test/suite/perfschema/t/pfs_upgrade_table.test create mode 100644 mysql-test/suite/perfschema/t/pfs_upgrade_view-master.opt create mode 100644 mysql-test/suite/perfschema/t/pfs_upgrade_view.test create mode 100644 mysql-test/suite/perfschema/t/prepared_statements.test create mode 100644 mysql-test/suite/perfschema/t/prepared_stmts_by_stored_programs.test create mode 100644 mysql-test/suite/perfschema/t/privilege.test create mode 100644 mysql-test/suite/perfschema/t/privilege_table_io.test create mode 100644 mysql-test/suite/perfschema/t/processlist-master.opt create mode 100644 mysql-test/suite/perfschema/t/processlist.test create mode 100644 mysql-test/suite/perfschema/t/processlist_57.test create mode 100644 mysql-test/suite/perfschema/t/processlist_acl-master.opt create mode 100644 mysql-test/suite/perfschema/t/processlist_acl.test create mode 100644 mysql-test/suite/perfschema/t/processlist_anonymous.test create mode 100644 mysql-test/suite/perfschema/t/processlist_no_pfs-master.opt create mode 100644 mysql-test/suite/perfschema/t/processlist_no_pfs.test create mode 100644 mysql-test/suite/perfschema/t/processlist_port-master.opt create mode 100644 mysql-test/suite/perfschema/t/processlist_port.test create mode 100644 mysql-test/suite/perfschema/t/processlist_reg_user.test create mode 100644 mysql-test/suite/perfschema/t/query_cache-master.opt create mode 100644 mysql-test/suite/perfschema/t/query_cache.test create mode 100644 mysql-test/suite/perfschema/t/read_only.test create mode 100644 mysql-test/suite/perfschema/t/relaylog.test create mode 100644 mysql-test/suite/perfschema/t/rollback_table_io.test create mode 100644 mysql-test/suite/perfschema/t/rpl_group_member_stats.test create mode 100644 mysql-test/suite/perfschema/t/rpl_group_members.test create mode 100644 mysql-test/suite/perfschema/t/rpl_gtid_func.test create mode 100644 mysql-test/suite/perfschema/t/rpl_statements.test create mode 100644 mysql-test/suite/perfschema/t/rpl_threads.test create mode 100644 mysql-test/suite/perfschema/t/schema.test create mode 100644 mysql-test/suite/perfschema/t/selects-master.opt create mode 100644 mysql-test/suite/perfschema/t/selects.test create mode 100644 mysql-test/suite/perfschema/t/server_init.test create mode 100644 mysql-test/suite/perfschema/t/setup_actors.test create mode 100644 mysql-test/suite/perfschema/t/setup_actors_enabled.test create mode 100644 mysql-test/suite/perfschema/t/setup_actors_history.test create mode 100644 mysql-test/suite/perfschema/t/setup_consumers_defaults-master.opt create mode 100644 mysql-test/suite/perfschema/t/setup_consumers_defaults.test create mode 100644 mysql-test/suite/perfschema/t/setup_instruments_defaults-master.opt create mode 100644 mysql-test/suite/perfschema/t/setup_instruments_defaults.test create mode 100644 mysql-test/suite/perfschema/t/setup_object_table_lock_io.test create mode 100644 mysql-test/suite/perfschema/t/setup_objects.test create mode 100644 mysql-test/suite/perfschema/t/short_option_1-master.opt create mode 100644 mysql-test/suite/perfschema/t/short_option_1.test create mode 100644 mysql-test/suite/perfschema/t/short_option_2-master.opt create mode 100644 mysql-test/suite/perfschema/t/short_option_2.test create mode 100644 mysql-test/suite/perfschema/t/show_aggregate.test create mode 100644 mysql-test/suite/perfschema/t/show_coverage.test create mode 100644 mysql-test/suite/perfschema/t/show_misc.test create mode 100644 mysql-test/suite/perfschema/t/show_plugin.test create mode 100644 mysql-test/suite/perfschema/t/show_sanity.test create mode 100644 mysql-test/suite/perfschema/t/socket_connect.test create mode 100644 mysql-test/suite/perfschema/t/socket_instances_func-master.opt create mode 100644 mysql-test/suite/perfschema/t/socket_instances_func.test create mode 100644 mysql-test/suite/perfschema/t/socket_instances_func_win-master.opt create mode 100644 mysql-test/suite/perfschema/t/socket_instances_func_win.test create mode 100644 mysql-test/suite/perfschema/t/socket_summary_by_event_name_func.test create mode 100644 mysql-test/suite/perfschema/t/socket_summary_by_instance_func.test create mode 100644 mysql-test/suite/perfschema/t/socket_summary_by_instance_func_win.test create mode 100644 mysql-test/suite/perfschema/t/stage_mdl_function.test create mode 100644 mysql-test/suite/perfschema/t/stage_mdl_global.opt create mode 100644 mysql-test/suite/perfschema/t/stage_mdl_global.test create mode 100644 mysql-test/suite/perfschema/t/stage_mdl_procedure.test create mode 100644 mysql-test/suite/perfschema/t/stage_mdl_table.test create mode 100644 mysql-test/suite/perfschema/t/start_server_1_digest-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_1_digest.test create mode 100644 mysql-test/suite/perfschema/t/start_server_disable_idle-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_disable_idle.test create mode 100644 mysql-test/suite/perfschema/t/start_server_disable_stages-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_disable_stages.test create mode 100644 mysql-test/suite/perfschema/t/start_server_disable_statements-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_disable_statements.test create mode 100644 mysql-test/suite/perfschema/t/start_server_disable_transactions-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_disable_transactions.test create mode 100644 mysql-test/suite/perfschema/t/start_server_disable_waits-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_disable_waits.test create mode 100644 mysql-test/suite/perfschema/t/start_server_innodb-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_innodb.test create mode 100644 mysql-test/suite/perfschema/t/start_server_low_digest-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_low_digest.test create mode 100644 mysql-test/suite/perfschema/t/start_server_low_digest_sql_length-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_low_digest_sql_length.test create mode 100644 mysql-test/suite/perfschema/t/start_server_low_index-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_low_index.test create mode 100644 mysql-test/suite/perfschema/t/start_server_low_table_lock-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_low_table_lock.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_account-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_account.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_cond_class-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_cond_class.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_cond_inst-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_cond_inst.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_digests-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_digests.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_file_class-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_file_class.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_file_inst-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_file_inst.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_host-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_host.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_index-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_index.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_mdl-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_mdl.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_memory_class-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_memory_class.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_mutex_class-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_mutex_class.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_mutex_inst-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_mutex_inst.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_prepared_stmts_instances-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_prepared_stmts_instances.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_rwlock_class-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_rwlock_class.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_rwlock_inst-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_rwlock_inst.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_setup_actors-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_setup_actors.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_setup_objects-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_setup_objects.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_socket_class-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_socket_class.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_socket_inst-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_socket_inst.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_stage_class-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_stage_class.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_stages_history-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_stages_history.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_stages_history_long-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_stages_history_long.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_statement_class-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_statement_class.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_statements_history-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_statements_history.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_statements_history_long-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_statements_history_long.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_table_hdl-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_table_hdl.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_table_inst-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_table_inst.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_table_lock-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_table_lock.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_thread_class-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_thread_class.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_thread_inst-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_thread_inst.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_transactions_history-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_transactions_history.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_transactions_history_long-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_transactions_history_long.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_user-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_user.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_waits_history-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_waits_history.test create mode 100644 mysql-test/suite/perfschema/t/start_server_no_waits_history_long-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_no_waits_history_long.test create mode 100644 mysql-test/suite/perfschema/t/start_server_nothing-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_nothing.test create mode 100644 mysql-test/suite/perfschema/t/start_server_off-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_off.test create mode 100644 mysql-test/suite/perfschema/t/start_server_on-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_on.test create mode 100644 mysql-test/suite/perfschema/t/start_server_variables.test create mode 100644 mysql-test/suite/perfschema/t/start_server_zero_digest_sql_length-master.opt create mode 100644 mysql-test/suite/perfschema/t/start_server_zero_digest_sql_length.test create mode 100644 mysql-test/suite/perfschema/t/statement_digest.test create mode 100644 mysql-test/suite/perfschema/t/statement_digest_charset.test create mode 100644 mysql-test/suite/perfschema/t/statement_digest_consumers-master.opt create mode 100644 mysql-test/suite/perfschema/t/statement_digest_consumers.test create mode 100644 mysql-test/suite/perfschema/t/statement_digest_consumers2-master.opt create mode 100644 mysql-test/suite/perfschema/t/statement_digest_consumers2.test create mode 100644 mysql-test/suite/perfschema/t/statement_digest_long_query-master.opt create mode 100644 mysql-test/suite/perfschema/t/statement_digest_long_query.test create mode 100644 mysql-test/suite/perfschema/t/statement_program_concurrency-master.opt create mode 100644 mysql-test/suite/perfschema/t/statement_program_concurrency.test create mode 100644 mysql-test/suite/perfschema/t/statement_program_lost_inst-master.opt create mode 100644 mysql-test/suite/perfschema/t/statement_program_lost_inst.test create mode 100644 mysql-test/suite/perfschema/t/statement_program_nested-master.opt create mode 100644 mysql-test/suite/perfschema/t/statement_program_nested.test create mode 100644 mysql-test/suite/perfschema/t/statement_program_nesting_event_check-master.opt create mode 100644 mysql-test/suite/perfschema/t/statement_program_nesting_event_check.test create mode 100644 mysql-test/suite/perfschema/t/statement_program_non_nested-master.opt create mode 100644 mysql-test/suite/perfschema/t/statement_program_non_nested.test create mode 100644 mysql-test/suite/perfschema/t/status_reprepare.test create mode 100644 mysql-test/suite/perfschema/t/sxlock_func.test create mode 100644 mysql-test/suite/perfschema/t/table_aggregate_global_2u_2t.test create mode 100644 mysql-test/suite/perfschema/t/table_aggregate_global_2u_3t.test create mode 100644 mysql-test/suite/perfschema/t/table_aggregate_global_4u_2t.test create mode 100644 mysql-test/suite/perfschema/t/table_aggregate_global_4u_3t.test create mode 100644 mysql-test/suite/perfschema/t/table_aggregate_hist_2u_2t.test create mode 100644 mysql-test/suite/perfschema/t/table_aggregate_hist_2u_3t.test create mode 100644 mysql-test/suite/perfschema/t/table_aggregate_hist_4u_2t.test create mode 100644 mysql-test/suite/perfschema/t/table_aggregate_hist_4u_3t.test create mode 100644 mysql-test/suite/perfschema/t/table_aggregate_off.test create mode 100644 mysql-test/suite/perfschema/t/table_aggregate_thread_2u_2t.test create mode 100644 mysql-test/suite/perfschema/t/table_aggregate_thread_2u_3t.test create mode 100644 mysql-test/suite/perfschema/t/table_aggregate_thread_4u_2t.test create mode 100644 mysql-test/suite/perfschema/t/table_aggregate_thread_4u_3t.test create mode 100644 mysql-test/suite/perfschema/t/table_io_aggregate_global_2u_2t.test create mode 100644 mysql-test/suite/perfschema/t/table_io_aggregate_global_2u_3t.test create mode 100644 mysql-test/suite/perfschema/t/table_io_aggregate_global_4u_2t.test create mode 100644 mysql-test/suite/perfschema/t/table_io_aggregate_global_4u_3t.test create mode 100644 mysql-test/suite/perfschema/t/table_io_aggregate_hist_2u_2t.test create mode 100644 mysql-test/suite/perfschema/t/table_io_aggregate_hist_2u_3t.test create mode 100644 mysql-test/suite/perfschema/t/table_io_aggregate_hist_4u_2t.test create mode 100644 mysql-test/suite/perfschema/t/table_io_aggregate_hist_4u_3t.test create mode 100644 mysql-test/suite/perfschema/t/table_io_aggregate_thread_2u_2t.test create mode 100644 mysql-test/suite/perfschema/t/table_io_aggregate_thread_2u_3t.test create mode 100644 mysql-test/suite/perfschema/t/table_io_aggregate_thread_4u_2t.test create mode 100644 mysql-test/suite/perfschema/t/table_io_aggregate_thread_4u_3t.test create mode 100644 mysql-test/suite/perfschema/t/table_lock_aggregate_global_2u_2t.test create mode 100644 mysql-test/suite/perfschema/t/table_lock_aggregate_global_2u_3t.test create mode 100644 mysql-test/suite/perfschema/t/table_lock_aggregate_global_4u_2t.test create mode 100644 mysql-test/suite/perfschema/t/table_lock_aggregate_global_4u_3t.test create mode 100644 mysql-test/suite/perfschema/t/table_lock_aggregate_hist_2u_2t.test create mode 100644 mysql-test/suite/perfschema/t/table_lock_aggregate_hist_2u_3t.test create mode 100644 mysql-test/suite/perfschema/t/table_lock_aggregate_hist_4u_2t.test create mode 100644 mysql-test/suite/perfschema/t/table_lock_aggregate_hist_4u_3t.test create mode 100644 mysql-test/suite/perfschema/t/table_lock_aggregate_thread_2u_2t.test create mode 100644 mysql-test/suite/perfschema/t/table_lock_aggregate_thread_2u_3t.test create mode 100644 mysql-test/suite/perfschema/t/table_lock_aggregate_thread_4u_2t.test create mode 100644 mysql-test/suite/perfschema/t/table_lock_aggregate_thread_4u_3t.test create mode 100644 mysql-test/suite/perfschema/t/table_name.test create mode 100644 mysql-test/suite/perfschema/t/table_schema.test create mode 100644 mysql-test/suite/perfschema/t/temp_table_io.test create mode 100644 mysql-test/suite/perfschema/t/thread_cache-master.opt create mode 100644 mysql-test/suite/perfschema/t/thread_cache.test create mode 100644 mysql-test/suite/perfschema/t/thread_misc-master.opt create mode 100644 mysql-test/suite/perfschema/t/thread_misc.test create mode 100644 mysql-test/suite/perfschema/t/threads_history.test create mode 100644 mysql-test/suite/perfschema/t/threads_innodb.test create mode 100644 mysql-test/suite/perfschema/t/threads_mysql-master.opt create mode 100644 mysql-test/suite/perfschema/t/threads_mysql.test create mode 100644 mysql-test/suite/perfschema/t/threads_mysql_freebsd.test create mode 100644 mysql-test/suite/perfschema/t/threads_mysql_linux.test create mode 100644 mysql-test/suite/perfschema/t/threads_mysql_windows.test create mode 100644 mysql-test/suite/perfschema/t/transaction-master.opt create mode 100644 mysql-test/suite/perfschema/t/transaction.test create mode 100644 mysql-test/suite/perfschema/t/transaction_gtid.test create mode 100644 mysql-test/suite/perfschema/t/transaction_nested_events-master.opt create mode 100644 mysql-test/suite/perfschema/t/transaction_nested_events.test create mode 100644 mysql-test/suite/perfschema/t/trigger_table_io.test create mode 100644 mysql-test/suite/perfschema/t/unary_digest.test create mode 100644 mysql-test/suite/perfschema/t/update_order-3837.test create mode 100644 mysql-test/suite/perfschema/t/user_var_func.test create mode 100644 mysql-test/suite/perfschema/t/view_table_io.test (limited to 'mysql-test/suite/perfschema') diff --git a/mysql-test/suite/perfschema/disabled.def b/mysql-test/suite/perfschema/disabled.def new file mode 100644 index 00000000..935548fc --- /dev/null +++ b/mysql-test/suite/perfschema/disabled.def @@ -0,0 +1,65 @@ +############################################################################## +# +# List the test cases that are to be disabled temporarily. +# +# Separate the test case name and the comment with ':'. +# +# : BUG# +# +# Do not use any TAB characters for whitespace. +# +############################################################################## +sizing_off: not updated for 10.0 yet +sizing_med: not updated for 10.0 yet +sizing_low: not updated for 10.0 yet +sizing_high: not updated for 10.0 yet +sizing_growth: not updated for 10.0 yet +sizing_default: not updated for 10.0 yet + +binlog_edge_mix: needs slave_relay_log_info +binlog_edge_row: needs slave_relay_log_info +binlog_edge_stmt: needs slave_relay_log_info +binlog_ok_mix: needs slave_relay_log_info +binlog_ok_row: needs slave_relay_log_info +binlog_ok_stmt: needs slave_relay_log_info + +server_init : Nirbhay TODO: Fix the test +show_sanity: +threads_mysql_freebsd: + +transaction_gtid: needs to be updated for MariaDB gtids + +ddl_replication_connection_status: todo +dml_replication_connection_status: todo + +dml_replication_group_member_stats: todo? +ddl_replication_group_member_stats: todo? +ddl_replication_group_members: todo? +dml_replication_group_members: todo? +replication_group_members: todo? +replication_group_member_stats: todo? +rpl_group_member_stats: todo? +rpl_group_members: todo? + +ddl_session_variables: todo +ddl_global_variables: todo +ddl_variables_by_thread: todo +dml_global_variables: todo +dml_session_variables: todo +dml_variables_by_thread: todo +variables_by_thread: todo +show_coverage: todo +show_misc: todo +show_plugin: todo + +status_reprepare:why P_S filters out Com_* variables? + +processlist: todo +processlist_acl: todo +processlist_port: todo +processlist_no_pfs: todo +ddl_processlist: todo +dml_processlist: todo +processlist_57: todo +processlist_anonymous: todo +processlist_reg_user: todo diff --git a/mysql-test/suite/perfschema/include/binlog_common.inc b/mysql-test/suite/perfschema/include/binlog_common.inc new file mode 100644 index 00000000..1c8651a0 --- /dev/null +++ b/mysql-test/suite/perfschema/include/binlog_common.inc @@ -0,0 +1,41 @@ +# Tests for PERFORMANCE_SCHEMA + +RESET MASTER; + +select count(*) > 0 from performance_schema.setup_instruments; + +# Note: +# Do not include records that could depend on +# compiling options (storage engines, SSL), +# to ensure the expected output in the binlog is predictable. +update performance_schema.setup_instruments set enabled='NO' + where name like "wait/synch/rwlock/sql/%" + and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock"); + +select count(*) > 0 from performance_schema.events_waits_current; + +--disable_warnings +drop table if exists test.t1; +drop table if exists test.t2; +--enable_warnings + +create table test.t1 (thread_id integer); +create table test.t2 (name varchar(128)); + +insert into test.t1 + select thread_id from performance_schema.events_waits_current; + +insert into test.t2 + select name from performance_schema.setup_instruments + where name like "wait/synch/rwlock/sql/%" + and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock"); + +drop table test.t1; +drop table test.t2; + +update performance_schema.setup_instruments set enabled='YES' + where name like "wait/synch/rwlock/sql/%" + and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock"); + +--source include/show_binlog_events.inc + diff --git a/mysql-test/suite/perfschema/include/binlog_edge_common.inc b/mysql-test/suite/perfschema/include/binlog_edge_common.inc new file mode 100644 index 00000000..6ecd50af --- /dev/null +++ b/mysql-test/suite/perfschema/include/binlog_edge_common.inc @@ -0,0 +1,188 @@ +# Test replication, when using special non-replicated tables. +# +# This test involve special statements that use non-replicated tables. +# Changes affecting non replicated tables are never written to the binlog. +# Executing these statements may or may not work, as the statements involved +# are edge cases. +# In MIXED or ROW binlog format, execution should succeed, +# and only partial data (the rows affecting replicated tables only) +# should be written to the binlog. +# In STATEMENT binlog format, execution should +# raise a warning (ER_BINLOG_UNSAFE_STATEMENT) if a non replicated table is +# only read from, or fail with an error (ER_BINLOG_STMT_MODE_AND_NO_REPL_TABLES) +# if a non replicated table is written to. +# +# SHOW ERRORS will print in the +# test .result file the exact outcome. + +RESET MASTER; + +--disable_warnings +drop database if exists my_replicated_db; +--enable_warnings + +call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT"); + +create database my_replicated_db; + +create table my_replicated_db.my_tx_table(a bigint) engine = innodb; +create table my_replicated_db.my_non_tx_table(a bigint) engine = myisam; +create table my_replicated_db.my_bh_table(a bigint) engine = blackhole; + +use test; +drop table if exists marker_start; + +use my_replicated_db; + +insert into my_tx_table(a) + values (1000), (2000), (3000); + +insert into my_non_tx_table(a) + values (1000), (2000), (3000); + +insert into my_bh_table(a) + values (1000), (2000), (3000); + +use test; +drop table if exists marker_insert_select; + +use my_replicated_db; + +# Note: +# The queries used here do not make any sense (no semantic). +# What this test is interrested in, is check the behavior +# when replicating queries that mix both: +# - non replicated tables +# - replicated tables + +insert into my_tx_table(a) + select thread_id from performance_schema.threads; + +insert into my_non_tx_table(a) + select thread_id from performance_schema.threads; + +insert into my_bh_table(a) + select thread_id from performance_schema.threads; + +# For the information_schema, +# no error is enforced yet. +# Documenting the current behavior + +insert into my_tx_table(a) + select id from information_schema.processlist; + +insert into my_non_tx_table(a) + select id from information_schema.processlist; + +insert into my_bh_table(a) + select id from information_schema.processlist; + +insert into my_tx_table(a) + select thread_id from mysql.general_log; + +insert into my_non_tx_table(a) + select thread_id from mysql.general_log; + +insert into my_bh_table(a) + select thread_id from mysql.general_log; + +insert into my_tx_table(a) + select thread_id from mysql.slow_log; + +insert into my_non_tx_table(a) + select thread_id from mysql.slow_log; + +insert into my_bh_table(a) + select thread_id from mysql.slow_log; + +insert into my_tx_table(a) + select Relay_log_pos from mysql.slave_relay_log_info; + +insert into my_non_tx_table(a) + select Relay_log_pos from mysql.slave_relay_log_info; + +insert into my_bh_table(a) + select Relay_log_pos from mysql.slave_relay_log_info; + +insert into my_tx_table(a) + select Master_log_pos from mysql.slave_master_info; + +insert into my_non_tx_table(a) + select Master_log_pos from mysql.slave_master_info; + +insert into my_bh_table(a) + select Master_log_pos from mysql.slave_master_info; + +insert into my_tx_table(a) + select Relay_log_pos from mysql.slave_worker_info; + +insert into my_non_tx_table(a) + select Relay_log_pos from mysql.slave_worker_info; + +insert into my_bh_table(a) + select Relay_log_pos from mysql.slave_worker_info; + +use test; +drop table if exists marker_multi_update; + +use my_replicated_db; + +--error 0, ER_BINLOG_STMT_MODE_AND_NO_REPL_TABLES +update my_tx_table, performance_schema.setup_instruments + set my_tx_table.a = my_tx_table.a + 1, + performance_schema.setup_instruments.timed= 'NO'; + +--error 0, ER_BINLOG_STMT_MODE_AND_NO_REPL_TABLES +update my_non_tx_table, performance_schema.setup_instruments + set my_non_tx_table.a = my_non_tx_table.a + 1, + performance_schema.setup_instruments.timed= 'NO'; + +--error 0, ER_BINLOG_STMT_MODE_AND_NO_REPL_TABLES +update my_bh_table, performance_schema.setup_instruments + set my_bh_table.a = my_bh_table.a + 1, + performance_schema.setup_instruments.timed= 'NO'; + +use test; +drop table if exists marker_multi_delete; + +use my_replicated_db; + +insert into performance_schema.setup_actors + values ('FOO', 'FOO', 'FOO', 'YES', 'YES'); + +--error 0, ER_BINLOG_STMT_MODE_AND_NO_REPL_TABLES +delete my_tx_table.*, performance_schema.setup_actors.* + from my_tx_table, performance_schema.setup_actors + where my_tx_table.a != 1000 + or performance_schema.setup_actors.role='FOO'; + +insert into performance_schema.setup_actors + values ('BAR', 'BAR', 'BAR', 'YES', 'YES'); + +--error 0, ER_BINLOG_STMT_MODE_AND_NO_REPL_TABLES +delete my_non_tx_table.*, performance_schema.setup_actors.* + from my_non_tx_table, performance_schema.setup_actors + where my_non_tx_table.a != 1000 + or performance_schema.setup_actors.role='BAR'; + +insert into performance_schema.setup_actors + values ('BAZ', 'BAZ', 'BAZ', 'YES', 'YES'); + +--error 0, ER_BINLOG_STMT_MODE_AND_NO_REPL_TABLES +delete my_bh_table.*, performance_schema.setup_actors.* + from my_bh_table, performance_schema.setup_actors + where my_bh_table.a != 1000 + or performance_schema.setup_actors.role='BAZ'; + +use test; +drop table if exists marker_end; + +drop database my_replicated_db; + +--source include/show_binlog_events.inc + +# Restore performance_schema.setup_actors, damaged by this script + +truncate table performance_schema.setup_actors; +insert into performance_schema.setup_actors values ('%', '%', '%', 'YES', 'YES'); + diff --git a/mysql-test/suite/perfschema/include/binlog_ok_common.inc b/mysql-test/suite/perfschema/include/binlog_ok_common.inc new file mode 100644 index 00000000..d537c6cf --- /dev/null +++ b/mysql-test/suite/perfschema/include/binlog_ok_common.inc @@ -0,0 +1,146 @@ +# Test replication, when using special non-replicated tables. +# +# This test involve special statements that use non-replicated tables. +# Changes affecting non replicated tables are never written to the binlog. +# Executing these statements should work nicely with replication in all cases: +# - STATEMENT binlog format +# - MIXED binlog format +# - ROW binlog format. + +RESET MASTER; + +--disable_warnings +drop database if exists my_local_db; +--enable_warnings + +create database my_local_db; + +create table my_local_db.my_tx_table(a bigint) engine = innodb; +create table my_local_db.my_non_tx_table(a bigint) engine = myisam; + +use test; +drop table if exists marker_start; + +# --binlog-ignore-db only works with the current database. +use my_local_db; + +insert into my_tx_table(a) + values (1000), (2000), (3000); + +insert into my_non_tx_table(a) + values (1000), (2000), (3000); + +use test; +drop table if exists marker_truncate; + +use performance_schema; +truncate table events_waits_history; +truncate table events_waits_history_long; + +use test; +truncate table performance_schema.events_statements_history_long; +truncate table performance_schema.host_cache; + +use test; +drop table if exists marker_update; + +use performance_schema; +update setup_instruments set enabled='NO'; +update setup_instruments set timed='NO'; +use test; +update performance_schema.setup_instruments set enabled='YES', timed='YES'; +update performance_schema.threads set instrumented='YES'; + +use test; +drop table if exists marker_insert; + +insert into performance_schema.setup_actors(`user`, `host`, `role`) + values ('XXX', 'XXX', 'XXX'), + ('YYY', 'YYY', 'YYY'), + ('ZZZ', 'ZZZ', 'ZZZ'); + +select * from performance_schema.setup_actors + where user in ('XXX', 'YYY', 'ZZZ') order by user; + +insert into performance_schema.setup_objects + (object_type, object_schema, object_name, enabled, timed) + values ('TABLE', 'DB1', 'AAA', 'YES', 'YES'), + ('TABLE', 'DB1', 'BBB', 'NO', 'NO'), + ('TABLE', 'DB2', 'CCC', 'YES', 'NO'), + ('TABLE', 'DB2', 'DDD', 'NO', 'YES'); + +select * from performance_schema.setup_objects + where object_schema like 'DB%' order by object_name; + +use test; +drop table if exists marker_insert_select; + +# Note: +# The queries used here do not make any sense (no semantic). +# What this test is interrested in, is check the behavior +# when replicating queries that mix both: +# - non replicated tables +# - replicated tables + +use my_local_db; +insert into my_tx_table(a) + select thread_id from performance_schema.threads; + +insert into my_non_tx_table(a) + select thread_id from performance_schema.threads; + +insert into my_tx_table(a) + select id from information_schema.processlist; + +insert into my_non_tx_table(a) + select id from information_schema.processlist; + +insert into my_tx_table(a) + select thread_id from mysql.general_log; + +insert into my_non_tx_table(a) + select thread_id from mysql.general_log; + +insert into my_tx_table(a) + select thread_id from mysql.slow_log; + +insert into my_non_tx_table(a) + select thread_id from mysql.slow_log; + +insert into my_tx_table(a) + select Relay_log_pos from mysql.slave_relay_log_info; + +insert into my_non_tx_table(a) + select Relay_log_pos from mysql.slave_relay_log_info; + +insert into my_tx_table(a) + select Master_log_pos from mysql.slave_master_info; + +insert into my_non_tx_table(a) + select Master_log_pos from mysql.slave_master_info; + +insert into my_tx_table(a) + select Relay_log_pos from mysql.slave_worker_info; + +insert into my_non_tx_table(a) + select Relay_log_pos from mysql.slave_worker_info; + +use test; +drop table if exists marker_delete; + +delete from performance_schema.setup_actors + where user in ('XXX', 'YYY', 'ZZZ'); + +delete from performance_schema.setup_objects + where object_schema like 'DB%'; + +use test; +drop table if exists marker_end; + +drop database my_local_db; + +# The content of the binlog dumped in the result file +# should not contain any references to non-replicated tables. + +--source include/show_binlog_events.inc + diff --git a/mysql-test/suite/perfschema/include/cleanup_helper.inc b/mysql-test/suite/perfschema/include/cleanup_helper.inc new file mode 100644 index 00000000..24b2cbec --- /dev/null +++ b/mysql-test/suite/perfschema/include/cleanup_helper.inc @@ -0,0 +1,17 @@ + +# Tests for PERFORMANCE_SCHEMA + +update performance_schema.setup_instruments set enabled='YES'; + +connection con1; +disconnect con1; +--source include/wait_until_disconnected.inc +connection con2; +disconnect con2; +--source include/wait_until_disconnected.inc +connection con3; +disconnect con3; +--source include/wait_until_disconnected.inc + +connection default; + diff --git a/mysql-test/suite/perfschema/include/connection_cleanup.inc b/mysql-test/suite/perfschema/include/connection_cleanup.inc new file mode 100644 index 00000000..761540b4 --- /dev/null +++ b/mysql-test/suite/perfschema/include/connection_cleanup.inc @@ -0,0 +1,27 @@ +# Tests for the performance schema + +# ===================================== +# HELPER include/connection_cleanup.inc +# ===================================== + +--disable_query_log +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; +revoke all privileges, grant option from user5@localhost; +drop user user1@localhost; +drop user user2@localhost; +drop user user3@localhost; +drop user user4@localhost; +drop user user5@localhost; +flush privileges; + +drop procedure dump_all; + +truncate table performance_schema.accounts; +truncate table performance_schema.users; +truncate table performance_schema.hosts; + +--enable_query_log + diff --git a/mysql-test/suite/perfschema/include/connection_load.inc b/mysql-test/suite/perfschema/include/connection_load.inc new file mode 100644 index 00000000..02c8e2ad --- /dev/null +++ b/mysql-test/suite/perfschema/include/connection_load.inc @@ -0,0 +1,245 @@ +# Tests for the performance schema + +# ======================================= +# HELPER include/connection_load.inc +# ======================================= + +call dump_all(); + +connect (con1a, localhost, user1, , ); +select "user1 in con1a" as status; +call dump_all(); + +connect (con1b, localhost, user1, , ); +select "user1 in con1b" as status; +call dump_all(); + +connect (con1c, localhost, user1, , ); +select "user1 in con1c" as status; +call dump_all(); + +connect (con2a, localhost, user2, , ); +select "user2 in con2a" as status; +call dump_all(); + +connect (con2b, localhost, user2, , ); +select "user2 in con2b" as status; +call dump_all(); + +connect (con2c, localhost, user2, , ); +select "user2 in con2c" as status; +call dump_all(); + +connect (con3a, localhost, user3, , ); +select "user3 in con3a" as status; +call dump_all(); + +connect (con3b, localhost, user3, , ); +select "user3 in con3b" as status; +call dump_all(); + +connect (con3c, localhost, user3, , ); +select "user3 in con3c" as status; +call dump_all(); + +--connection default + +--disconnect con1a + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 8 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; +--source include/wait_condition.inc + +select "con1a disconnected" as status; +call dump_all(); + +--disconnect con2a + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 7 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; +--source include/wait_condition.inc + +select "con2a disconnected" as status; +call dump_all(); + +--disconnect con3a + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 6 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; +--source include/wait_condition.inc + +select "con3a disconnected" as status; +call dump_all(); + +truncate table performance_schema.accounts; +call dump_all(); +truncate table performance_schema.users; +call dump_all(); +truncate table performance_schema.hosts; +call dump_all(); + +connect (con4a, localhost, user4, , ); +select "user4 in con4a" as status; +call dump_all(); + +connect (con4b, localhost, user4, , ); +select "user4 in con4b" as status; +call dump_all(); + +connect (con4c, localhost, user4, , ); +select "user4 in con4c" as status; +call dump_all(); + +--connection default + +--disconnect con1b + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 8 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; +--source include/wait_condition.inc + +select "con1b disconnected" as status; +call dump_all(); + +--disconnect con2b + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 7 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; +--source include/wait_condition.inc + +select "con2b disconnected" as status; +call dump_all(); + +--disconnect con3b + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 6 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; +--source include/wait_condition.inc + +select "con3b disconnected" as status; +call dump_all(); + +--disconnect con1c + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 5 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; +--source include/wait_condition.inc + +select "con1c disconnected" as status; +call dump_all(); + +--disconnect con2c + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 4 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; +--source include/wait_condition.inc + +select "con2c disconnected" as status; +call dump_all(); + +--disconnect con3c + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 3 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; +--source include/wait_condition.inc + +select "con3c disconnected" as status; +call dump_all(); + +truncate table performance_schema.accounts; +call dump_all(); +truncate table performance_schema.users; +call dump_all(); +truncate table performance_schema.hosts; +call dump_all(); + +connect (con5a, localhost, user5, , ); +select "user5 in con5a" as status; +call dump_all(); + +connect (con5b, localhost, user5, , ); +select "user5 in con5b" as status; +call dump_all(); + +connect (con5c, localhost, user5, , ); +select "user5 in con5c" as status; +call dump_all(); + +--connection default + +--disconnect con4a + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 5 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; +--source include/wait_condition.inc + +--disconnect con4b + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 4 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; +--source include/wait_condition.inc + +--disconnect con4c + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 3 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; +--source include/wait_condition.inc + +--disconnect con5a + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 2 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; +--source include/wait_condition.inc + +--disconnect con5b + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 1 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; +--source include/wait_condition.inc + +--disconnect con5c + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 0 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; +--source include/wait_condition.inc + +select "con 5a, 5b, 5c, 6a, 6b, 6c disconnected" as status; +call dump_all(); + +truncate table performance_schema.hosts; +call dump_all(); +truncate table performance_schema.users; +call dump_all(); +truncate table performance_schema.accounts; +call dump_all(); + diff --git a/mysql-test/suite/perfschema/include/connection_setup.inc b/mysql-test/suite/perfschema/include/connection_setup.inc new file mode 100644 index 00000000..93b8e959 --- /dev/null +++ b/mysql-test/suite/perfschema/include/connection_setup.inc @@ -0,0 +1,114 @@ +# Tests for the performance schema + +# ============= +# DOCUMENTATION +# ============= + +# Verify how connections are counted into various tables: +# - accounts +# - users +# - hosts +# +# The tests are written with the following helpers: +# - include/connection_setup.inc +# - include/connection_load.inc +# - include/connection_cleanup.inc +# +# Helpers are intended to be used as follows. +# +# A Typical test t/connection_xxx.test will consist of: +# --source ../include/connection_setup.inc +# --source ../include/connection_load.inc +# --source ../include/connection_cleanup.inc +# and a t/connection_xxx-master.opt file +# +# Naming conventions for t/connection_xxx.test are as follows: +# t/connection_ +# +# corresponds to different sizing settings for +# the variable performance-schema-accounts-size +# - (blank): accounts-size sufficient to represent all records +# - 3a: accounts-size set to 3 +# - no_a: accounts-size set to 0 +# +# corresponds to different sizing settings for +# the variable performance-schema-users-size +# - (blank): users-size sufficient to represent all records +# - 3u: users-size set to 3 +# - no_u: users-size set to 0 +# +# corresponds to different sizing settings for +# the variable performance-schema-hosts-size +# - (blank): hosts-size sufficient to represent all records +# - no_h: hosts-size set to 0 + +# ======================================== +# HELPER include/event_aggregate_setup.inc +# ======================================== + +--source include/not_embedded.inc +--source include/have_perfschema.inc +--source include/no_protocol.inc +--source ../include/wait_for_pfs_thread_count.inc + +--disable_query_log + +create user user1@localhost; +grant ALL on *.* to user1@localhost; +create user user2@localhost; +grant ALL on *.* to user2@localhost; +create user user3@localhost; +grant ALL on *.* to user3@localhost; +create user user4@localhost; +grant ALL on *.* to user4@localhost; +create user user5@localhost; +grant ALL on *.* to user5@localhost; + +flush privileges; + +# Purge old users, hosts, user/host from previous tests +truncate table performance_schema.accounts; +truncate table performance_schema.users; +truncate table performance_schema.hosts; + +# Save the setup + +# Start from a known clean state, to avoid noise from previous tests +flush tables; +flush status; + +--disable_warnings +drop procedure if exists dump_all; +--enable_warnings + +delimiter $$; + +create procedure dump_all() +begin + select processlist_user, processlist_host + from performance_schema.threads + where (processlist_user is not null) and (processlist_host is not null) + order by processlist_user; + + select * from performance_schema.accounts + where (user is not null) and (host is not null) + order by user, host; + + select * from performance_schema.users + where user is not null + order by user; + + select * from performance_schema.hosts + where host is not null + order by host; + + select variable_name, variable_value from information_schema.global_status + where variable_name in ('PERFORMANCE_SCHEMA_ACCOUNTS_LOST', + 'PERFORMANCE_SCHEMA_USERS_LOST', + 'PERFORMANCE_SCHEMA_HOSTS_LOST'); +end +$$ + +delimiter ;$$ + +--enable_query_log diff --git a/mysql-test/suite/perfschema/include/default_mysqld_autosize.cnf b/mysql-test/suite/perfschema/include/default_mysqld_autosize.cnf new file mode 100644 index 00000000..6bcf7a09 --- /dev/null +++ b/mysql-test/suite/perfschema/include/default_mysqld_autosize.cnf @@ -0,0 +1,52 @@ + +# Default values that applies to all MySQL Servers +[mysqld] +local-infile +character-set-server= latin1 +default-storage-engine=myisam + +# Increase default connect_timeout to avoid intermittent +# disconnects when test servers are put under load see BUG#28359 +connect-timeout= 60 + +log-bin-trust-function-creators=1 +key_buffer_size= 1M +sort_buffer_size= 256K +max_heap_table_size= 1M + +loose-innodb_data_file_path= ibdata1:10M:autoextend +loose-innodb_buffer_pool_size= 8M +loose-innodb_lru_scan_depth= 100 +loose-innodb_write_io_threads= 2 +loose-innodb_read_io_threads= 2 +loose-innodb_log_buffer_size= 2M +loose-innodb_log_file_size= 10M + +slave-net-timeout=120 + +log-bin=mysqld-bin + +# No performance schema sizing provided + +# Disable everything, we only need the sizing data, +# and also need a stable output for show engine performance_schema status +loose-performance-schema-consumer-global-instrumentation=OFF + +loose-performance-schema-instrument='%=ON' + +loose-performance-schema-consumer-events-stages-current=ON +loose-performance-schema-consumer-events-stages-history=ON +loose-performance-schema-consumer-events-stages-history-long=ON +loose-performance-schema-consumer-events-statements-current=ON +loose-performance-schema-consumer-events-statements-history=ON +loose-performance-schema-consumer-events-statements-history-long=ON +loose-performance-schema-consumer-events-transactions-current=ON +loose-performance-schema-consumer-events-transactions-history=ON +loose-performance-schema-consumer-events-transactions-history-long=ON +loose-performance-schema-consumer-events-waits-current=ON +loose-performance-schema-consumer-events-waits-history=ON +loose-performance-schema-consumer-events-waits-history-long=ON +loose-performance-schema-consumer-thread-instrumentation=ON + +binlog-direct-non-transactional-updates + diff --git a/mysql-test/suite/perfschema/include/digest_cleanup.inc b/mysql-test/suite/perfschema/include/digest_cleanup.inc new file mode 100644 index 00000000..47dd7618 --- /dev/null +++ b/mysql-test/suite/perfschema/include/digest_cleanup.inc @@ -0,0 +1,14 @@ +--echo #################################### +--echo # CLEANUP +--echo #################################### +--disable_warnings +DROP TABLE IF EXISTS t1; +DROP TABLE IF EXISTS t2; +DROP TABLE IF EXISTS t3; +DROP TABLE IF EXISTS t4; +DROP TABLE IF EXISTS t5; +DROP TABLE IF EXISTS t6; +DROP TABLE IF EXISTS t11; +DROP TABLE IF EXISTS t12; +DROP DATABASE IF EXISTS statements_digest; +--enable_warnings diff --git a/mysql-test/suite/perfschema/include/digest_execution.inc b/mysql-test/suite/perfschema/include/digest_execution.inc new file mode 100644 index 00000000..cf83bf9f --- /dev/null +++ b/mysql-test/suite/perfschema/include/digest_execution.inc @@ -0,0 +1,130 @@ +--echo #################################### +--echo # EXECUTION +--echo #################################### + +# ----------------------------------- +# SQL Queries to test normalizations. +# ----------------------------------- +SELECT 1 FROM t1; +SELECT 1 FROM `t1`; +SELECT 1,2 FROM t1; +SELECT 1, 2, 3, 4 FROM t1; +SELECT 1 FROM t2; +SELECT 1,2 FROM t2; +SELECT 1, 2, 3, 4 FROM t2; + +# (NUM) => (#) +INSERT INTO t1 VALUES (1); +INSERT INTO t2 VALUES (1); + +# (NUM,NUM) => (#,#) +INSERT INTO t3 VALUES (1, 2); +INSERT INTO t4 VALUES (1, 2); +# (NUM,NUM,NUM) => (#,#) +INSERT INTO t5 VALUES (1, 2, 3); + +# (NUM),(NUM) => (#),(#) +INSERT INTO t1 VALUES (1), (2), (3); +# (NUM),(NUM),(NUM) => (#),(#) +INSERT INTO t1 VALUES (1), (2), (3), (4); + +# (NUM,NUM),(NUM,NUM) => (#,#),(#,#) +INSERT INTO t3 VALUES (1, 2), (3, 4), (5, 6); +# (NUM,NUM,NUM),(NUM,NUM,NUM),(NUM,NUM,NUM) => (#,#),(#,#) +INSERT INTO t5 VALUES (1, 2, 3), (4, 5, 6), (7, 8, 9); + +# ----------------------------------------------------------------------- +# Test case to handle NULL. If alone, not normalized otherwise normalized. +# ----------------------------------------------------------------------- +INSERT INTO t1 VALUES (NULL); +INSERT INTO t3 VALUES (NULL,NULL); +INSERT INTO t3 VALUES (1,NULL); +INSERT INTO t3 VALUES (NULL,1); +INSERT INTO t6 VALUES (NULL, NULL, NULL, NULL); +INSERT INTO t6 VALUES (1, NULL, NULL, NULL); +INSERT INTO t6 VALUES (NULL, 2, NULL, NULL); +INSERT INTO t6 VALUES (1, 2, 3, NULL); +INSERT INTO t6 VALUES (1, 2, NULL, 4); + +# ----------------------------------------------------------------------- +# Test case for handling spaces in statement. +# ----------------------------------------------------------------------- + +SELECT 1 + 1; + +# ----------------------------------------------------------------------- +# Test case for handling comments. +# ----------------------------------------------------------------------- + +# comment starting with "--" +# TODO : SELECT 1; -- This comment continues to the end of line +# comment starting from "#" +SELECT 1; # This comment continues to the end of line + +# Inline comment +SELECT 1 /* This is an inline comment */ + 1; + +# Multiple line comments + SELECT 1+ + /* + this is a + multiple-line comment + */ + 1; + +# ----------------------------------------------------------------------- +# Tests to show how the digest behaves with tokens that can have multiple +# names (such as DATABASE = "DATABASE" or "SCHEMA", SUBSTRING, STD_SYM, +# VARIANCE_SYM ... ) +# ----------------------------------------------------------------------- + +--disable_warnings +CREATE SCHEMA statements_digest_temp; +DROP SCHEMA statements_digest_temp; +CREATE DATABASE statements_digest_temp; +DROP DATABASE statements_digest_temp; +# TODO : add more +--enable_warnings + +# ----------------------------------------------------------------------- +# Test case to show stats for statements giving ERRORS/WARNINGS, are also +# captured. +# ----------------------------------------------------------------------- +--ERROR ER_NO_SUCH_TABLE +SELECT 1 FROM no_such_table; +CREATE TABLE dup_table (c char(4)); +--ERROR ER_TABLE_EXISTS_ERROR +CREATE TABLE dup_table (c char(4)); +DROP TABLE dup_table; +INSERT IGNORE INTO t11 VALUES("MySQL"); + +# ----------------------------------------------------------------------- +# Tests to show sub-statements for following statements are not +# instrumented. +# - Prepared Statements +# - Stored Procedures/Functions. +# - Table Triggers +# ----------------------------------------------------------------------- +PREPARE stmt FROM "SELECT * FROM t12"; +EXECUTE stmt; +EXECUTE stmt; +DEALLOCATE PREPARE stmt; + +DELIMITER //; +CREATE PROCEDURE p1() BEGIN SELECT * FROM t12; END// +DELIMITER ;// +CALL p1(); +CALL p1(); +DROP PROCEDURE p1; + +DELIMITER //; +CREATE FUNCTION `func`(a INT, b INT) RETURNS int(11) RETURN a+b // +DELIMITER ;// +select func(3,4); +select func(13,42); +DROP FUNCTION func; + +CREATE TRIGGER trg BEFORE INSERT ON t12 FOR EACH ROW SET @a:=1; +INSERT INTO t12 VALUES ("abc"); +INSERT INTO t12 VALUES ("def"); +DROP TRIGGER trg; diff --git a/mysql-test/suite/perfschema/include/digest_setup.inc b/mysql-test/suite/perfschema/include/digest_setup.inc new file mode 100644 index 00000000..6efab880 --- /dev/null +++ b/mysql-test/suite/perfschema/include/digest_setup.inc @@ -0,0 +1,24 @@ +# Making sure not to run when ps-protocol is set. +--source include/no_protocol.inc + +--echo #################################### +--echo # SETUP +--echo #################################### +# Database setup +--disable_warnings +CREATE DATABASE statements_digest; +--enable_warnings +USE statements_digest; + +# Table set up for queries +--disable_warnings +CREATE TABLE t1(a int); +CREATE TABLE t2(a int); +CREATE TABLE t3(a int, b int); +CREATE TABLE t4(a int, b int); +CREATE TABLE t5(a int, b int, c int); +CREATE TABLE t6(a int, b int, c int, d int); +CREATE TABLE t11 (c CHAR(4)); +CREATE TABLE t12 (c CHAR(4)); +--enable_warnings + diff --git a/mysql-test/suite/perfschema/include/disable_instruments.inc b/mysql-test/suite/perfschema/include/disable_instruments.inc new file mode 100644 index 00000000..b0a4ddec --- /dev/null +++ b/mysql-test/suite/perfschema/include/disable_instruments.inc @@ -0,0 +1,23 @@ +# Tests for the performance schema + +# ========================================== +# HELPER include/disable_instruments +# ========================================== +# +# ==== Usage ==== +# +# 1. Define the instrument to be disabled/enabled: +# +# let $pfs_instrument= +# +# Where is the instrument name with or without wildcards, e.g. +# +# let $pfs_instrument='%statement/sql%' +# +--disable_query_log ONCE + +eval update performance_schema.setup_instruments + set enabled='no', timed='no' + where name like $pfs_instrument; + + diff --git a/mysql-test/suite/perfschema/include/enable_instruments.inc b/mysql-test/suite/perfschema/include/enable_instruments.inc new file mode 100644 index 00000000..94d63aee --- /dev/null +++ b/mysql-test/suite/perfschema/include/enable_instruments.inc @@ -0,0 +1,23 @@ +# Tests for the performance schema + +# ========================================== +# HELPER include/enable_instruments +# ========================================== +# +# ==== Usage ==== +# +# 1. Define the instrument to be enabled/disabled: +# +# let $pfs_instrument= +# +# Where is the instrument name with or without wildcards, e.g. +# +# let $pfs_instrument='%statement/sql%' +# +--disable_query_log ONCE + +eval update performance_schema.setup_instruments + set enabled='yes', timed='yes' + where name like $pfs_instrument; + + diff --git a/mysql-test/suite/perfschema/include/event_aggregate_cleanup.inc b/mysql-test/suite/perfschema/include/event_aggregate_cleanup.inc new file mode 100644 index 00000000..2cb8a69e --- /dev/null +++ b/mysql-test/suite/perfschema/include/event_aggregate_cleanup.inc @@ -0,0 +1,64 @@ +# Tests for the performance schema + +# ========================================== +# HELPER include/event_aggregate_cleanup.inc +# ========================================== + +--disable_query_log +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; + +drop procedure dump_thread; +drop procedure dump_one_thread; + +drop prepare dump_waits_account; +drop prepare dump_waits_user; +drop prepare dump_waits_host; +drop prepare dump_waits_history; +drop prepare dump_waits_global; + +drop prepare dump_stages_account; +drop prepare dump_stages_user; +drop prepare dump_stages_host; +drop prepare dump_stages_history; +drop prepare dump_stages_global; + +drop prepare dump_statements_account; +drop prepare dump_statements_user; +drop prepare dump_statements_host; +drop prepare dump_statements_history; +drop prepare dump_statements_global; + +drop prepare dump_transactions_account; +drop prepare dump_transactions_user; +drop prepare dump_transactions_host; +drop prepare dump_transactions_history; +drop prepare dump_transactions_global; + +drop prepare dump_users; +drop prepare dump_hosts; +drop prepare dump_accounts; + +truncate table performance_schema.accounts; +truncate table performance_schema.users; +truncate table performance_schema.hosts; + +truncate table performance_schema.setup_actors; +insert into performance_schema.setup_actors + select * from test.setup_actors; +drop table test.setup_actors; +drop table test.t1; +drop function test.f; + +update performance_schema.threads set instrumented='YES'; +update performance_schema.setup_instruments set enabled='YES', timed='YES'; + +--enable_query_log + diff --git a/mysql-test/suite/perfschema/include/event_aggregate_load.inc b/mysql-test/suite/perfschema/include/event_aggregate_load.inc new file mode 100644 index 00000000..a4815eaf --- /dev/null +++ b/mysql-test/suite/perfschema/include/event_aggregate_load.inc @@ -0,0 +1,1197 @@ +# Tests for the performance schema + +# ======================================= +# HELPER include/event_aggregate_load.inc +# ======================================= + +echo "================== Step 1 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +# Notes about this test +# +# The main thread does not count for BY_ACCOUNT / BY_HOST. +# The user thread does count for BY_ACCOUNT, BY_HOST +# +# Each uuid_short() causes 1 wait/synch/mutex/sql/LOCK_uuid_generator +# +# To avoid noise from main, the background threads are disabled. + +connect (con1, localhost, user1, ,test); + +--connection default + +# Wait for the connect to complete +let $wait_condition= + select count(*) = 1 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user1'; +--source include/wait_condition.inc + +echo "================== Step 2 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +--connection con1 + +select uuid_short() <> 1; +select uuid_short() <> 1; +start transaction; +insert into test.t1 values ("marker"); +commit; +select test.f(10,20); + +--connection default + +# Wait for the payload to complete +let $wait_condition= + select count(*) = 1 from performance_schema.events_waits_current + where EVENT_NAME= 'idle'; +--source include/wait_condition.inc + +echo "================== Step 3 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +# Debugging helpers +# select * from performance_schema.events_waits_history_long; +# select PROCESSLIST_USER, PROCESSLIST_HOST, INSTRUMENTED from performance_schema.threads; + +connect (con2, localhost, user2, ,test); + +--connection default + +# Wait for the connect to complete +let $wait_condition= + select count(*) = 1 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user2'; +--source include/wait_condition.inc + +echo "================== Step 4 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +--connection con2 + +select uuid_short() <> 1; +select uuid_short() <> 1; +start transaction; +insert into test.t1 values ("marker"); +commit; +select test.f(10,20); + +--connection default + +# Wait for the payload to complete +let $wait_condition= + select count(*) = 2 from performance_schema.events_waits_current + where EVENT_NAME= 'idle'; +--source include/wait_condition.inc + +echo "================== Step 5 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +connect (con3, localhost, user3, ,test); + +--connection default + +# Wait for the connect to complete +let $wait_condition= + select count(*) = 1 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user3'; +--source include/wait_condition.inc + +echo "================== Step 6 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +--connection con3 + +select uuid_short() <> 1; +select uuid_short() <> 1; +start transaction; +insert into test.t1 values ("marker"); +commit; +select test.f(10,20); + +--connection default + +# Wait for the payload to complete +let $wait_condition= + select count(*) = 3 from performance_schema.events_waits_current + where EVENT_NAME= 'idle'; +--source include/wait_condition.inc + +echo "================== Step 7 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +connect (con4, localhost, user4, ,test); + +--connection default + +# Wait for the connect to complete +let $wait_condition= + select count(*) = 1 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user4'; +--source include/wait_condition.inc + +echo "================== Step 8 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +--connection con4 + +select uuid_short() <> 1; +select uuid_short() <> 1; +start transaction; +insert into test.t1 values ("marker"); +commit; +select test.f(10,20); + +--connection default + +# Wait for the payload to complete +let $wait_condition= + select count(*) = 4 from performance_schema.events_waits_current + where EVENT_NAME= 'idle'; +--source include/wait_condition.inc + +echo "================== Step 9 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +--disconnect con1 + +--connection default + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 0 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user1'; +--source include/wait_condition.inc + +echo "================== Step 10 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +--disconnect con2 + +--connection default + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 0 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user2'; +--source include/wait_condition.inc + +echo "================== Step 11 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +--disconnect con3 + +--connection default + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 0 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user3'; +--source include/wait_condition.inc + +echo "================== Step 12 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +--disconnect con4 + +--connection default + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 0 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user4'; +--source include/wait_condition.inc + +echo "================== Step 13 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +--connection default + +truncate performance_schema.events_waits_summary_by_thread_by_event_name; + +echo "================== WAITS_BY_THREAD truncated =================="; + +echo "================== Step 14 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.events_waits_summary_by_account_by_event_name; + +echo "================== WAITS_BY_ACCOUNT truncated =================="; + +echo "================== Step 15 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.events_waits_summary_by_user_by_event_name; + +echo "================== WAITS_BY_USER truncated =================="; + +echo "================== Step 16 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.events_waits_summary_by_host_by_event_name; + +echo "================== WAITS_BY_HOST truncated =================="; + +echo "================== Step 17 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.events_waits_summary_global_by_event_name; + +echo "================== WAITS_GLOBAL truncated =================="; + +echo "================== Step 18 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.events_stages_summary_by_thread_by_event_name; + +echo "================== STAGES_BY_THREAD truncated =================="; + +echo "================== Step 19 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.events_stages_summary_by_account_by_event_name; + +echo "================== STAGES_BY_ACCOUNT truncated =================="; + +echo "================== Step 20 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.events_stages_summary_by_user_by_event_name; + +echo "================== STAGES_BY_USER truncated =================="; + +echo "================== Step 21 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.events_stages_summary_by_host_by_event_name; + +echo "================== STAGES_BY_HOST truncated =================="; + +echo "================== Step 22 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.events_stages_summary_global_by_event_name; + +echo "================== STAGES_GLOBAL truncated =================="; + +echo "================== Step 23 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.events_statements_summary_by_thread_by_event_name; + +echo "================== STATEMENTS_BY_THREAD truncated =================="; + +echo "================== Step 24 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.events_statements_summary_by_account_by_event_name; + +echo "================== STATEMENTS_BY_ACCOUNT truncated =================="; + +echo "================== Step 25 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.events_statements_summary_by_user_by_event_name; + +echo "================== STATEMENTS_BY_USER truncated =================="; + +echo "================== Step 26 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.events_statements_summary_by_host_by_event_name; + +echo "================== STATEMENTS_BY_HOST truncated =================="; + +echo "================== Step 27 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.events_statements_summary_global_by_event_name; + +echo "================== STATEMENTS_GLOBAL truncated =================="; + +echo "================== Step 28 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.events_transactions_summary_by_thread_by_event_name; + +echo "================== TRANSACTIONS_BY_THREAD truncated =================="; + +echo "================== Step 29 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.events_transactions_summary_by_account_by_event_name; + +echo "================== TRANSACTIONS_BY_ACCOUNT truncated =================="; + +echo "================== Step 30 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.events_transactions_summary_by_user_by_event_name; + +echo "================== TRANSACTIONS_BY_USER truncated =================="; + +echo "================== Step 31 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.events_transactions_summary_by_host_by_event_name; + +echo "================== TRANSACTIONS_BY_HOST truncated =================="; + +echo "================== Step 32 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.events_transactions_summary_global_by_event_name; + +echo "================== TRANSACTIONS_GLOBAL truncated =================="; + +echo "================== Step 33 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.accounts; + +echo "================== ACCOUNTS truncated =================="; + +echo "================== Step 34 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.users; + +echo "================== USERS truncated =================="; + +echo "================== Step 35 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.hosts; + +echo "================== HOSTS truncated =================="; + +echo "================== Step 36 =================="; +call dump_thread(); +execute dump_waits_account; +execute dump_waits_user; +execute dump_waits_host; +execute dump_waits_global; +execute dump_waits_history; +execute dump_stages_account; +execute dump_stages_user; +execute dump_stages_host; +execute dump_stages_global; +execute dump_stages_history; +execute dump_statements_account; +execute dump_statements_user; +execute dump_statements_host; +execute dump_statements_global; +execute dump_statements_history; +execute dump_transactions_account; +execute dump_transactions_user; +execute dump_transactions_host; +execute dump_transactions_global; +execute dump_transactions_history; +execute dump_accounts; +execute dump_users; +execute dump_hosts; + diff --git a/mysql-test/suite/perfschema/include/event_aggregate_setup.inc b/mysql-test/suite/perfschema/include/event_aggregate_setup.inc new file mode 100644 index 00000000..03f88e97 --- /dev/null +++ b/mysql-test/suite/perfschema/include/event_aggregate_setup.inc @@ -0,0 +1,413 @@ +# Tests for the performance schema + +# ============= +# DOCUMENTATION +# ============= + +# Verify how events are aggregated into various tables +# +# In the thread dimension: +# - events_waits_summary_by_thread_by_event_name +# - events_waits_summary_by_account_by_event_name +# - events_waits_summary_by_user_by_event_name +# - events_waits_summary_by_host_by_event_name +# - events_stages_summary_by_thread_by_event_name +# - events_stages_summary_by_account_by_event_name +# - events_stages_summary_by_user_by_event_name +# - events_stages_summary_by_host_by_event_name +# - events_statements_summary_by_thread_by_event_name +# - events_statements_summary_by_account_by_event_name +# - events_statements_summary_by_user_by_event_name +# - events_statements_summary_by_host_by_event_name +# - events_transactions_summary_by_thread_by_event_name +# - events_transactions_summary_by_account_by_event_name +# - events_transactions_summary_by_user_by_event_name +# - events_transactions_summary_by_host_by_event_name +# +# Globally: +# - events_waits_summary_global_by_event_name +# - events_stages_summary_global_by_event_name +# - events_statements_summary_global_by_event_name +# - events_transactions_summary_global_by_event_name +# +# The tests are written with the following helpers: +# - include/event_aggregate_setup.inc +# - include/event_aggregate_load.inc +# - include/event_aggregate_cleanup.inc +# +# Helpers are intended to be used as follows. +# +# A Typical test t/event_aggregate_xxx.test will consist of: +# --source ../include/event_aggregate_setup.inc +# --source ../include/event_aggregate_load.inc +# --source ../include/event_aggregate_cleanup.inc +# and a t/event_aggregate_xxx-master.opt file +# +# Naming conventions for t/event_aggregate_xxx.test are as follows: +# t/event_aggregate_ +# +# corresponds to different sizing settings for +# the variable performance-schema-accounts-size +# - (blank): accounts-size sufficient to represent all records +# - no_a: accounts-size set to 0 +# +# corresponds to different sizing settings for +# the variable performance-schema-users-size +# - (blank): users-size sufficient to represent all records +# - no_u: users-size set to 0 +# +# corresponds to different sizing settings for +# the variable performance-schema-hosts-size +# - (blank): hosts-size sufficient to represent all records +# - no_h: hosts-size set to 0 + +# ======================================== +# HELPER include/event_aggregate_setup.inc +# ======================================== + +--source include/not_embedded.inc +--source include/have_perfschema.inc +--source include/no_protocol.inc +--source ../include/wait_for_pfs_thread_count.inc + +--disable_query_log +create user user1@localhost; +grant ALL on *.* to user1@localhost; +create user user2@localhost; +grant ALL on *.* to user2@localhost; +create user user3@localhost; +grant ALL on *.* to user3@localhost; +create user user4@localhost; +grant ALL on *.* to user4@localhost; + +flush privileges; + +# Purge old users, hosts, user/host from previous tests +truncate table performance_schema.accounts; +truncate table performance_schema.users; +truncate table performance_schema.hosts; + +# Save the setup + +--disable_warnings +drop table if exists test.setup_actors; +drop table if exists test.t1; +--enable_warnings + +create table test.t1(a varchar(64)); +create function test.f(a int, b int) returns int +return a+b; + +create table test.setup_actors as + select * from performance_schema.setup_actors; + +# Only instrument the user connections +truncate table performance_schema.setup_actors; +insert into performance_schema.setup_actors + set host= 'localhost', user= 'user1', role= '%'; +insert into performance_schema.setup_actors + set host= 'localhost', user= 'user2', role= '%'; +insert into performance_schema.setup_actors + set host= 'localhost', user= 'user3', role= '%'; +insert into performance_schema.setup_actors + set host= 'localhost', user= 'user4', role= '%'; + +update performance_schema.threads set instrumented='NO'; + +# Only instrument a few events of each kind +update performance_schema.setup_instruments set enabled='NO', timed='NO'; + +update performance_schema.setup_instruments set enabled='YES', timed='YES' + where name in ('wait/synch/mutex/sql/LOCK_connection_count', + 'wait/synch/mutex/sql/LOCK_uuid_generator', + 'wait/synch/rwlock/sql/LOCK_grant', + 'wait/io/file/sql/query_log', + 'idle'); + +update performance_schema.setup_instruments set enabled='YES', timed='YES' + where name in ('stage/sql/starting', + 'stage/sql/init', + 'stage/sql/checking permissions', + 'stage/sql/Opening tables', + 'stage/sql/Closing tables'); + +update performance_schema.setup_instruments set enabled='YES', timed='YES' + where name in ('statement/sql/select', + 'statement/sql/insert', + 'statement/abstract/new_packet', + 'statement/abstract/Query', + 'statement/com/Quit', + 'statement/com/error', + 'statement/sp/freturn'); + +update performance_schema.setup_instruments set enabled='YES', timed='YES' + where name in ('transaction'); + +# Start from a known clean state, to avoid noise from previous tests +flush tables; +flush status; +truncate performance_schema.events_waits_summary_by_thread_by_event_name; +truncate performance_schema.events_waits_summary_by_account_by_event_name; +truncate performance_schema.events_waits_summary_by_user_by_event_name; +truncate performance_schema.events_waits_summary_by_host_by_event_name; +truncate performance_schema.events_waits_summary_global_by_event_name; +truncate performance_schema.events_waits_history_long; + +truncate performance_schema.events_stages_summary_by_thread_by_event_name; +truncate performance_schema.events_stages_summary_by_account_by_event_name; +truncate performance_schema.events_stages_summary_by_user_by_event_name; +truncate performance_schema.events_stages_summary_by_host_by_event_name; +truncate performance_schema.events_stages_summary_global_by_event_name; +truncate performance_schema.events_stages_history_long; + +truncate performance_schema.events_statements_summary_by_thread_by_event_name; +truncate performance_schema.events_statements_summary_by_account_by_event_name; +truncate performance_schema.events_statements_summary_by_user_by_event_name; +truncate performance_schema.events_statements_summary_by_host_by_event_name; +truncate performance_schema.events_statements_summary_global_by_event_name; +truncate performance_schema.events_statements_history_long; + +truncate performance_schema.events_transactions_summary_by_thread_by_event_name; +truncate performance_schema.events_transactions_summary_by_account_by_event_name; +truncate performance_schema.events_transactions_summary_by_user_by_event_name; +truncate performance_schema.events_transactions_summary_by_host_by_event_name; +truncate performance_schema.events_transactions_summary_global_by_event_name; +truncate performance_schema.events_transactions_history_long; + +--disable_warnings +drop procedure if exists dump_thread; +drop procedure if exists dump_one_thread; +--enable_warnings + +delimiter $$; + +create procedure dump_thread() +begin + call dump_one_thread('user1'); + call dump_one_thread('user2'); + call dump_one_thread('user3'); + call dump_one_thread('user4'); +end +$$ + +create procedure dump_one_thread(in username varchar(64)) +begin + declare my_thread_id int; + + set my_thread_id = (select thread_id from performance_schema.threads + where processlist_user=username); + + if (my_thread_id is not null) then + select username, event_name, count_star + from performance_schema.events_waits_summary_by_thread_by_event_name + where event_name in ('wait/synch/mutex/sql/LOCK_connection_count', + 'wait/synch/mutex/sql/LOCK_uuid_generator', + 'wait/synch/rwlock/sql/LOCK_grant', + 'wait/io/file/sql/query_log') + and thread_id = my_thread_id + order by event_name; + else + select username, "not found" as status; + end if; +end +$$ + +delimiter ;$$ + +prepare dump_waits_account from + "select user, host, event_name, count_star + from performance_schema.events_waits_summary_by_account_by_event_name + where user like \'user%\' + and event_name in ('wait/synch/mutex/sql/LOCK_connection_count', + 'wait/synch/mutex/sql/LOCK_uuid_generator', + 'wait/synch/rwlock/sql/LOCK_grant', + 'wait/io/file/sql/query_log') + order by user, host, event_name;"; + +prepare dump_waits_user from + "select user, event_name, count_star + from performance_schema.events_waits_summary_by_user_by_event_name + where user like \'user%\' + and event_name in ('wait/synch/mutex/sql/LOCK_connection_count', + 'wait/synch/mutex/sql/LOCK_uuid_generator', + 'wait/synch/rwlock/sql/LOCK_grant', + 'wait/io/file/sql/query_log') + order by user, event_name;"; + +prepare dump_waits_host from + "select host, event_name, count_star + from performance_schema.events_waits_summary_by_host_by_event_name + where host=\'localhost\' + and event_name in ('wait/synch/mutex/sql/LOCK_connection_count', + 'wait/synch/mutex/sql/LOCK_uuid_generator', + 'wait/synch/rwlock/sql/LOCK_grant', + 'wait/io/file/sql/query_log') + order by host, event_name;"; + +prepare dump_waits_global from + "select event_name, count_star + from performance_schema.events_waits_summary_global_by_event_name + where event_name in ('wait/synch/mutex/sql/LOCK_connection_count', + 'wait/synch/mutex/sql/LOCK_uuid_generator', + 'wait/synch/rwlock/sql/LOCK_grant', + 'wait/io/file/sql/query_log') + order by event_name;"; + +prepare dump_waits_history from + "select event_name, count(event_name) + from performance_schema.events_waits_history_long + where event_name in ('wait/synch/mutex/sql/LOCK_connection_count', + 'wait/synch/mutex/sql/LOCK_uuid_generator', + 'wait/synch/rwlock/sql/LOCK_grant', + 'wait/io/file/sql/query_log') + group by event_name order by event_name;"; + +prepare dump_stages_account from + "select user, host, event_name, count_star + from performance_schema.events_stages_summary_by_account_by_event_name + where user like \'user%\' + and event_name in ('stage/sql/starting', + 'stage/sql/init', + 'stage/sql/checking permissions', + 'stage/sql/Opening tables', + 'stage/sql/closing tables') + order by user, host, event_name;"; + +prepare dump_stages_user from + "select user, event_name, count_star + from performance_schema.events_stages_summary_by_user_by_event_name + where user like \'user%\' + and event_name in ('stage/sql/starting', + 'stage/sql/init', + 'stage/sql/checking permissions', + 'stage/sql/Opening tables', + 'stage/sql/closing tables') + order by user, event_name;"; + +prepare dump_stages_host from + "select host, event_name, count_star + from performance_schema.events_stages_summary_by_host_by_event_name + where host=\'localhost\' + and event_name in ('stage/sql/starting', + 'stage/sql/init', + 'stage/sql/checking permissions', + 'stage/sql/Opening tables', + 'stage/sql/closing tables') + order by host, event_name;"; + +prepare dump_stages_global from + "select event_name, count_star + from performance_schema.events_stages_summary_global_by_event_name + where event_name in ('stage/sql/starting', + 'stage/sql/init', + 'stage/sql/checking permissions', + 'stage/sql/Opening tables', + 'stage/sql/closing tables') + order by event_name;"; + +prepare dump_stages_history from + "select event_name, count(event_name) + from performance_schema.events_stages_history_long + where event_name in ('stage/sql/starting', + 'stage/sql/init', + 'stage/sql/checking permissions', + 'stage/sql/Opening tables', + 'stage/sql/closing tables') + group by event_name order by event_name;"; + +prepare dump_statements_account from + "select user, host, event_name, count_star + from performance_schema.events_statements_summary_by_account_by_event_name + where user like \'user%\' + and event_name in ('statement/sql/select', + 'statement/sql/insert', + 'statement/com/Quit', + 'statement/com/error', + 'statement/sp/freturn') + order by user, host, event_name;"; + +prepare dump_statements_user from + "select user, event_name, count_star + from performance_schema.events_statements_summary_by_user_by_event_name + where user like \'user%\' + and event_name in ('statement/sql/select', + 'statement/sql/insert', + 'statement/com/Quit', + 'statement/com/error', + 'statement/sp/freturn') + order by user, event_name;"; + +prepare dump_statements_host from + "select host, event_name, count_star + from performance_schema.events_statements_summary_by_host_by_event_name + where host=\'localhost\' + and event_name in ('statement/sql/select', + 'statement/sql/insert', + 'statement/com/Quit', + 'statement/com/error', + 'statement/sp/freturn') + order by host, event_name;"; + +prepare dump_statements_global from + "select event_name, count_star + from performance_schema.events_statements_summary_global_by_event_name + where event_name in ('statement/sql/select', + 'statement/sql/insert', + 'statement/com/Quit', + 'statement/com/error', + 'statement/sp/freturn') + order by event_name;"; + +prepare dump_statements_history from + "select event_name, count(event_name) + from performance_schema.events_statements_history_long + where event_name in ('statement/sql/select', + 'statement/sql/insert', + 'statement/com/Quit', + 'statement/com/error', + 'statement/sp/freturn') + group by event_name order by event_name;"; + +prepare dump_transactions_account from + "select user, host, event_name, count_star + from performance_schema.events_transactions_summary_by_account_by_event_name + where user like \'user%\' + and event_name in ('transaction') + order by user, host, event_name;"; + +prepare dump_transactions_user from + "select user, event_name, count_star + from performance_schema.events_transactions_summary_by_user_by_event_name + where user like \'user%\' + and event_name in ('transaction') + order by user, event_name;"; + +prepare dump_transactions_host from + "select host, event_name, count_star + from performance_schema.events_transactions_summary_by_host_by_event_name + where host=\'localhost\' + and event_name in ('transaction') + order by host, event_name;"; + +prepare dump_transactions_global from + "select event_name, count_star + from performance_schema.events_transactions_summary_global_by_event_name + where event_name in ('transaction') + order by event_name;"; + +prepare dump_transactions_history from + "select event_name, count(event_name) + from performance_schema.events_transactions_history_long + where event_name in ('transaction') + group by event_name order by event_name;"; + +prepare dump_users from + "select * from performance_schema.users where user is not null order by user;"; + +prepare dump_hosts from + "select * from performance_schema.hosts where host is not null order by host;"; + +prepare dump_accounts from + "select * from performance_schema.accounts where (user is not null) and (host is not null) order by user, host;"; + +--enable_query_log diff --git a/mysql-test/suite/perfschema/include/have_aligned_memory.inc b/mysql-test/suite/perfschema/include/have_aligned_memory.inc new file mode 100644 index 00000000..d420f0e0 --- /dev/null +++ b/mysql-test/suite/perfschema/include/have_aligned_memory.inc @@ -0,0 +1,10 @@ +# The performance schema internal structures are compiled with PFS_ALIGN, +# and the sizeof() structures is platform dependent. +# +# For tests sensitive to the internal sizes (show engine performance_schema +# status), make sure we use a platform with aligned memory. + +if (`SELECT count(*)=0 from performance_schema.session_connect_attrs where PROCESSLIST_ID = connection_id() and ATTR_NAME = '_os' and ATTR_VALUE in ('Linux', 'Windows')`) +{ + skip Need a platform with aligned memory; +} diff --git a/mysql-test/suite/perfschema/include/have_timer_cycle.inc b/mysql-test/suite/perfschema/include/have_timer_cycle.inc new file mode 100644 index 00000000..b801ea25 --- /dev/null +++ b/mysql-test/suite/perfschema/include/have_timer_cycle.inc @@ -0,0 +1,4 @@ +if (!`SELECT count(*) FROM performance_schema.performance_timers WHERE timer_name='CYCLE' AND timer_frequency IS NOT NULL`) +{ + Skip Need performance timer CYCLE; +} diff --git a/mysql-test/suite/perfschema/include/hostcache_dump.inc b/mysql-test/suite/perfschema/include/hostcache_dump.inc new file mode 100644 index 00000000..1d595ba2 --- /dev/null +++ b/mysql-test/suite/perfschema/include/hostcache_dump.inc @@ -0,0 +1,39 @@ +# Helper for hostcache_*.test + +--echo # Dumping performance_schema.host_cache + +--disable_query_log +--vertical_results +select + IP, HOST, HOST_VALIDATED, SUM_CONNECT_ERRORS, + COUNT_HOST_BLOCKED_ERRORS, + COUNT_NAMEINFO_TRANSIENT_ERRORS, + COUNT_NAMEINFO_PERMANENT_ERRORS, + COUNT_FORMAT_ERRORS, + COUNT_ADDRINFO_TRANSIENT_ERRORS, + COUNT_ADDRINFO_PERMANENT_ERRORS, + COUNT_FCRDNS_ERRORS, + COUNT_HOST_ACL_ERRORS, + COUNT_NO_AUTH_PLUGIN_ERRORS, + COUNT_AUTH_PLUGIN_ERRORS, + COUNT_HANDSHAKE_ERRORS, + COUNT_PROXY_USER_ERRORS, + COUNT_PROXY_USER_ACL_ERRORS, + COUNT_AUTHENTICATION_ERRORS, + COUNT_SSL_ERRORS, + COUNT_MAX_USER_CONNECTIONS_ERRORS, + COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS, + COUNT_DEFAULT_DATABASE_ERRORS, + COUNT_INIT_CONNECT_ERRORS, + COUNT_LOCAL_ERRORS, + COUNT_UNKNOWN_ERRORS, + if (FIRST_ERROR_SEEN is not null, + if (FIRST_ERROR_SEEN > date("2012-01-01"), "set", "wrong epoch"), + "null") as FIRST_ERROR_SEEN, + if (LAST_ERROR_SEEN is not null, + if (FIRST_ERROR_SEEN > date("2012-01-01"), "set", "wrong epoch"), + "null") as LAST_ERROR_SEEN + from performance_schema.host_cache; +--horizontal_results +--enable_query_log + diff --git a/mysql-test/suite/perfschema/include/hostcache_set_state.inc b/mysql-test/suite/perfschema/include/hostcache_set_state.inc new file mode 100644 index 00000000..29f32123 --- /dev/null +++ b/mysql-test/suite/perfschema/include/hostcache_set_state.inc @@ -0,0 +1,22 @@ +# Helper for hostcache_*.test + +# Set a known initial state for the test + +flush status; +flush hosts; +flush user_resources; +flush privileges; + +# Print critical setup + +#select @@global.debug; +#select @@global.max_connect_errors; +#select @@global.max_user_connections; +#select @@global.max_connections; + +# Make sure there are no remaining records that can change the test outcome + +select `User`, `Host` from mysql.`user` where `host` like '%\\%%'; +select `User`, `Host` from mysql.`user` where `user` like '192.%'; +select `User`, `Host` from mysql.`user` where `user` like '2001:%'; +select `User`, `Host` from mysql.`user` where `user` like 'santa.claus.%'; diff --git a/mysql-test/suite/perfschema/include/memory_aggregate_cleanup.inc b/mysql-test/suite/perfschema/include/memory_aggregate_cleanup.inc new file mode 100644 index 00000000..1e2cfa99 --- /dev/null +++ b/mysql-test/suite/perfschema/include/memory_aggregate_cleanup.inc @@ -0,0 +1,45 @@ +# Tests for the performance schema + +# =========================================== +# HELPER include/memory_aggregate_cleanup.inc +# =========================================== + +--disable_query_log +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; + +drop procedure dump_thread; +drop procedure dump_one_thread; + +drop prepare dump_memory_account; +drop prepare dump_memory_user; +drop prepare dump_memory_host; +drop prepare dump_memory_global; + +drop prepare dump_users; +drop prepare dump_hosts; +drop prepare dump_accounts; + +truncate table performance_schema.accounts; +truncate table performance_schema.users; +truncate table performance_schema.hosts; + +truncate table performance_schema.setup_actors; +insert into performance_schema.setup_actors + select * from test.setup_actors; +drop table test.setup_actors; + +set global query_cache_size=0; + +update performance_schema.threads set instrumented='YES'; +update performance_schema.setup_instruments set enabled='YES', timed='YES'; + +--enable_query_log + diff --git a/mysql-test/suite/perfschema/include/memory_aggregate_load.inc b/mysql-test/suite/perfschema/include/memory_aggregate_load.inc new file mode 100644 index 00000000..7a54d252 --- /dev/null +++ b/mysql-test/suite/perfschema/include/memory_aggregate_load.inc @@ -0,0 +1,506 @@ +# Tests for the performance schema + +# ======================================== +# HELPER include/memory_aggregate_load.inc +# ======================================== + +echo "================== Step 1 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +# Notes about this test +# +# get_lock("marker") causes the following memory allocation: +# memory/sql/User_level_lock, 1 malloc, size 16 (size 8 for 32-bit systems). +# release_lock("marker") causes the following memory free: +# memory/sql/User_level_lock, 1 free, size 16 (size 8 for 32-bit systems). +# +# To avoid noise from main, the background threads are disabled. + +connect (con1, localhost, user1, , ); + +echo "================== con1 connected =================="; + +--connection default + +# Wait for the connect to complete +let $wait_condition= + select count(*) = 1 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user1'; +--source include/wait_condition.inc + +echo "================== Step 2 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +--connection con1 + +set GLOBAL query_cache_size=1000*1024; +select get_lock("marker_1", 10); +select release_lock("marker_1"); +set @v1 = repeat("a", 1000); +set @v2 = repeat("b", 2000); +set @v3 = repeat("c", 4000); + +echo "================== con1 marker =================="; + +--connection default + +# Wait for the payload to complete +let $wait_condition= + select count(*) = 1 from performance_schema.events_waits_current + where EVENT_NAME= 'idle'; +--source include/wait_condition.inc + +echo "================== Step 3 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +# Debugging helpers +# select * from performance_schema.events_waits_history_long; +# select PROCESSLIST_USER, PROCESSLIST_HOST, INSTRUMENTED from performance_schema.threads; + +connect (con2, localhost, user2, , ); + +echo "================== con2 connected =================="; + +--connection default + +# Wait for the connect to complete +let $wait_condition= + select count(*) = 1 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user2'; +--source include/wait_condition.inc + +echo "================== Step 4 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +--connection con2 + +set GLOBAL query_cache_size=2000*1024; +select get_lock("marker_2", 10); +select release_lock("marker_2"); +set @v1 = repeat("a", 1000); +set @v2 = repeat("b", 2000); +set @v3 = repeat("c", 4000); + +echo "================== con2 marker =================="; + +--connection default + +# Wait for the payload to complete +let $wait_condition= + select count(*) = 2 from performance_schema.events_waits_current + where EVENT_NAME= 'idle'; +--source include/wait_condition.inc + +echo "================== Step 5 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate table performance_schema.memory_summary_by_thread_by_event_name; + +echo "================== MEMORY_BY_THREAD truncated =================="; + +echo "================== Step 5b =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +connect (con3, localhost, user3, , ); + +echo "================== con3 connected =================="; + +--connection default + +# Wait for the connect to complete +let $wait_condition= + select count(*) = 1 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user3'; +--source include/wait_condition.inc + +echo "================== Step 6 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +--connection con3 + +set GLOBAL query_cache_size=500*1024; +select get_lock("marker_3", 10); +select release_lock("marker_3"); +set @v1 = repeat("a", 1000); +set @v2 = repeat("b", 2000); +set @v3 = repeat("c", 4000); + +echo "================== con3 marker =================="; + +--connection default + +# Wait for the payload to complete +let $wait_condition= + select count(*) = 3 from performance_schema.events_waits_current + where EVENT_NAME= 'idle'; +--source include/wait_condition.inc + +echo "================== Step 7 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +connect (con4, localhost, user4, , ); +connect (con5, localhost, user4, , ); + +echo "================== con4/con5 (both user4) connected =================="; + +--connection default + +# Wait for the connects to complete +let $wait_condition= + select count(*) = 2 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user4'; +--source include/wait_condition.inc + +echo "================== Step 8 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +--connection con4 + +set GLOBAL query_cache_size=4000*1024; +select get_lock("marker_4", 10); +select release_lock("marker_4"); +set @v1 = repeat("a", 1000); +set @v2 = repeat("b", 2000); +set @v3 = repeat("c", 4000); + +--connection con5 +select get_lock("marker_5", 10); +select release_lock("marker_5"); +set @v1 = repeat("a", 1000); +set @v2 = repeat("b", 2000); +set @v3 = repeat("c", 4000); + +echo "================== con4/con5 marker =================="; + +--connection default + +# Wait for the payload to complete +let $wait_condition= + select count(*) = 5 from performance_schema.events_waits_current + where EVENT_NAME= 'idle'; +--source include/wait_condition.inc + +echo "================== Step 9 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +--disconnect con1 +--disconnect con5 + +--connection default + +# Wait for the disconnects to complete +let $wait_condition= + select count(*) = 0 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user1'; +--source include/wait_condition.inc +let $wait_condition= + select count(*) = 1 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user4'; +--source include/wait_condition.inc + +echo "================== con1/con5 disconnected =================="; + +echo "================== Step 10 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +--disconnect con2 + +--connection default + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 0 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user2'; +--source include/wait_condition.inc + +echo "================== con2 disconnected =================="; + +echo "================== Step 11 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +--disconnect con3 + +--connection default + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 0 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user3'; +--source include/wait_condition.inc + +echo "================== con3 disconnected =================="; + +echo "================== Step 12 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +--disconnect con4 + +--connection default + +# Wait for the disconnect to complete +let $wait_condition= + select count(*) = 0 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user4'; +--source include/wait_condition.inc + +echo "================== con4 disconnected =================="; + +echo "================== Step 13 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +--connection default + +truncate performance_schema.memory_summary_by_thread_by_event_name; + +echo "================== MEMORY_BY_THREAD truncated =================="; + +echo "================== Step 14 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.memory_summary_by_account_by_event_name; + +echo "================== MEMORY_BY_ACCOUNT truncated =================="; + +echo "================== Step 15 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.memory_summary_by_user_by_event_name; + +echo "================== MEMORY_BY_USER truncated =================="; + +echo "================== Step 16 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.memory_summary_by_host_by_event_name; + +echo "================== MEMORY_BY_HOST truncated =================="; + +echo "================== Step 17 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.memory_summary_global_by_event_name; + +echo "================== MEMORY_GLOBAL truncated =================="; + +echo "================== Step 18 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.accounts; + +echo "================== ACCOUNTS truncated =================="; + +echo "================== Step 19 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.users; + +echo "================== USERS truncated =================="; + +echo "================== Step 20 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + +truncate performance_schema.hosts; + +echo "================== HOSTS truncated =================="; + +echo "================== Step 21 =================="; +--vertical_results +call dump_thread(); +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +execute dump_memory_global; +--horizontal_results +execute dump_accounts; +execute dump_users; +execute dump_hosts; + diff --git a/mysql-test/suite/perfschema/include/memory_aggregate_setup.inc b/mysql-test/suite/perfschema/include/memory_aggregate_setup.inc new file mode 100644 index 00000000..1272c092 --- /dev/null +++ b/mysql-test/suite/perfschema/include/memory_aggregate_setup.inc @@ -0,0 +1,208 @@ +# Tests for the performance schema + +# ============= +# DOCUMENTATION +# ============= + +# Verify how memory stats are aggregated into various tables +# +# In the thread dimension: +# - memory_summary_by_thread_by_event_name +# - memory_summary_by_account_by_event_name +# - memory_summary_by_user_by_event_name +# - memory_summary_by_host_by_event_name +# +# Globally: +# - memory_summary_global_by_event_name +# +# The tests are written with the following helpers: +# - include/memory_aggregate_setup.inc +# - include/memory_aggregate_load.inc +# - include/memory_aggregate_cleanup.inc +# +# Helpers are intended to be used as follows. +# +# A Typical test t/memory_aggregate_xxx.test will consist of: +# --source ../include/memory_aggregate_setup.inc +# --source ../include/memory_aggregate_load.inc +# --source ../include/memory_aggregate_cleanup.inc +# and a t/memory_aggregate_xxx-master.opt file +# +# Naming conventions for t/memory_aggregate_xxx.test are as follows: +# t/memory_aggregate_ +# +# corresponds to different sizing settings for +# the variable performance-schema-accounts-size +# - (blank): accounts-size sufficient to represent all records +# - no_a: accounts-size set to 0 +# +# corresponds to different sizing settings for +# the variable performance-schema-users-size +# - (blank): users-size sufficient to represent all records +# - no_u: users-size set to 0 +# +# corresponds to different sizing settings for +# the variable performance-schema-hosts-size +# - (blank): hosts-size sufficient to represent all records +# - no_h: hosts-size set to 0 + +# ========================================= +# HELPER include/memory_aggregate_setup.inc +# ========================================= + +--source include/not_embedded.inc +--source include/have_perfschema.inc +--source include/no_protocol.inc +--source ../include/wait_for_pfs_thread_count.inc +--source include/not_windows.inc + +--disable_query_log + +set @orig_sql_mode= @@sql_mode; +set sql_mode= (select replace(@@sql_mode,'NO_AUTO_CREATE_USER','')); +grant ALL on *.* to user1@localhost; +grant ALL on *.* to user2@localhost; +grant ALL on *.* to user3@localhost; +grant ALL on *.* to user4@localhost; +set sql_mode= @orig_sql_mode; + +flush privileges; + +# Purge old users, hosts, user/host from previous tests +truncate table performance_schema.accounts; +truncate table performance_schema.users; +truncate table performance_schema.hosts; + +# Save the setup + +--disable_warnings +drop table if exists test.setup_actors; +--enable_warnings + +create table test.setup_actors as + select * from performance_schema.setup_actors; + +# Only instrument the user connections +truncate table performance_schema.setup_actors; +insert into performance_schema.setup_actors + set host= 'localhost', user= 'user1', role= '%'; +insert into performance_schema.setup_actors + set host= 'localhost', user= 'user2', role= '%'; +insert into performance_schema.setup_actors + set host= 'localhost', user= 'user3', role= '%'; +insert into performance_schema.setup_actors + set host= 'localhost', user= 'user4', role= '%'; + +update performance_schema.threads set instrumented='NO'; + +# Only instrument a few events of each kind +update performance_schema.setup_instruments set enabled='NO', timed='NO'; + +update performance_schema.setup_instruments set enabled='YES', timed='YES' + where name in ('memory/sql/user_var_entry::value', + 'memory/sql/User_level_lock', + 'memory/sql/Query_cache', + 'idle'); + +# Start from a known clean state, to avoid noise from previous tests +flush tables; +flush status; +truncate performance_schema.memory_summary_by_thread_by_event_name; +truncate performance_schema.memory_summary_by_account_by_event_name; +truncate performance_schema.memory_summary_by_user_by_event_name; +truncate performance_schema.memory_summary_by_host_by_event_name; +truncate performance_schema.memory_summary_global_by_event_name; + +--disable_warnings +drop procedure if exists dump_thread; +drop procedure if exists dump_one_thread; +--enable_warnings + +delimiter $$; + +create procedure dump_thread() +begin + call dump_one_thread('user1'); + call dump_one_thread('user2'); + call dump_one_thread('user3'); + call dump_one_thread('user4'); +end +$$ + +create procedure dump_one_thread(in username varchar(64)) +begin + declare my_thread_id int; + + set my_thread_id = (select thread_id from performance_schema.threads + where processlist_user=username LIMIT 1); + + if (my_thread_id is not null) then + select username, + EVENT_NAME, COUNT_ALLOC, COUNT_FREE, + SUM_NUMBER_OF_BYTES_ALLOC, SUM_NUMBER_OF_BYTES_FREE, + LOW_COUNT_USED, CURRENT_COUNT_USED, HIGH_COUNT_USED, + LOW_NUMBER_OF_BYTES_USED, CURRENT_NUMBER_OF_BYTES_USED, HIGH_NUMBER_OF_BYTES_USED + from performance_schema.memory_summary_by_thread_by_event_name + where event_name in ('memory/sql/user_var_entry::value', + 'memory/sql/User_level_lock', + 'memory/sql/Query_cache') + and thread_id = my_thread_id + order by event_name; + else + select username, "not found" as status; + end if; +end +$$ + +delimiter ;$$ + +prepare dump_memory_account from + "select * + from performance_schema.memory_summary_by_account_by_event_name + where user like \'user%\' + and event_name in ('memory/sql/user_var_entry::value', + 'memory/sql/User_level_lock', + 'memory/sql/Query_cache') + order by user, host, event_name;"; + +prepare dump_memory_user from + "select * + from performance_schema.memory_summary_by_user_by_event_name + where user like \'user%\' + and event_name in ('memory/sql/user_var_entry::value', + 'memory/sql/User_level_lock', + 'memory/sql/Query_cache') + order by user, event_name;"; + +prepare dump_memory_host from + "select * + from performance_schema.memory_summary_by_host_by_event_name + where host=\'localhost\' + and event_name in ('memory/sql/user_var_entry::value', + 'memory/sql/User_level_lock', + 'memory/sql/Query_cache') + order by host, event_name;"; + +prepare dump_memory_global from + "select * + from performance_schema.memory_summary_global_by_event_name + where event_name in ('memory/sql/user_var_entry::value', + 'memory/sql/User_level_lock', + 'memory/sql/Query_cache') + order by event_name;"; + +prepare dump_users from + "select * from performance_schema.users where user is not null order by user;"; + +prepare dump_hosts from + "select * from performance_schema.hosts where host is not null order by host;"; + +prepare dump_accounts from + "select * from performance_schema.accounts where (user is not null) and (host is not null) order by user, host;"; + +--enable_query_log + +# Make sure all the instrumentation is present +show global status like "performance_schema_memory_classes_lost"; + + diff --git a/mysql-test/suite/perfschema/include/pfs_no_running_event_scheduler.inc b/mysql-test/suite/perfschema/include/pfs_no_running_event_scheduler.inc new file mode 100644 index 00000000..eff3d7df --- /dev/null +++ b/mysql-test/suite/perfschema/include/pfs_no_running_event_scheduler.inc @@ -0,0 +1,10 @@ +# threads are removed from: +# - information_schema.processlist +# - performance_schema.threads +# at different times, so we may have to wait a little more +# for the event_scheduler to shutdown +# +let $wait_condition= + SELECT COUNT(*) = 0 FROM performance_schema.threads + WHERE name like 'thread/sql/event%'; +--source include/wait_condition.inc diff --git a/mysql-test/suite/perfschema/include/pfs_running_event_scheduler.inc b/mysql-test/suite/perfschema/include/pfs_running_event_scheduler.inc new file mode 100644 index 00000000..219a4105 --- /dev/null +++ b/mysql-test/suite/perfschema/include/pfs_running_event_scheduler.inc @@ -0,0 +1,10 @@ +# threads are removed from: +# - information_schema.processlist +# - performance_schema.threads +# at different times, so we may have to wait a little more +# for the event_scheduler to shutdown +# +let $wait_condition= + SELECT COUNT(*) = 1 FROM performance_schema.threads + WHERE name like 'thread/sql/event%'; +--source include/wait_condition.inc diff --git a/mysql-test/suite/perfschema/include/pfs_upgrade.inc b/mysql-test/suite/perfschema/include/pfs_upgrade.inc new file mode 100644 index 00000000..8d9dca0a --- /dev/null +++ b/mysql-test/suite/perfschema/include/pfs_upgrade.inc @@ -0,0 +1,112 @@ +# Tests for PERFORMANCE_SCHEMA +# Make sure mysql_upgrade does not destroy data in a 'performance_schema' +# database. +# + +# Some initial settings + Preemptive cleanup +let $MYSQLD_DATADIR= `SELECT @@datadir`; +let $err_file= $MYSQLTEST_VARDIR/tmp/pfs_upgrade.err; +let $out_file= $MYSQLTEST_VARDIR/tmp/pfs_upgrade.out; +--error 0,1 +--remove_file $out_file +--error 0,1 +--remove_file $err_file + +--disable_warnings +drop table if exists test.user_table; +drop procedure if exists test.user_proc; +drop function if exists test.user_func; +drop event if exists test.user_event; +--enable_warnings + + +--echo # Testing mysql_upgrade with TABLE performance_schema.user_table + +create table test.user_table(a int); + +--error 0,1 +--remove_file $MYSQLD_DATADIR/performance_schema/user_table.frm +--copy_file $MYSQLD_DATADIR/test/user_table.frm $MYSQLD_DATADIR/performance_schema/user_table.frm + +# Make sure the table is visible +use performance_schema; +show tables like "user_table"; + +--source suite/perfschema/include/upgrade_check.inc + +# Make sure the table is still visible +show tables like "user_table"; + +use test; + +--remove_file $MYSQLD_DATADIR/performance_schema/user_table.frm +drop table test.user_table; + + +--echo # Testing mysql_upgrade with VIEW performance_schema.user_view + +create view test.user_view as select "Not supposed to be here"; + +--error 0,1 +--remove_file $MYSQLD_DATADIR/performance_schema/user_view.frm +--copy_file $MYSQLD_DATADIR/test/user_view.frm $MYSQLD_DATADIR/performance_schema/user_view.frm + +# Make sure the view is visible +use performance_schema; +show tables like "user_view"; + +--source suite/perfschema/include/upgrade_check.inc + +# Make sure the view is still visible +show tables like "user_view"; + +use test; + +--remove_file $MYSQLD_DATADIR/performance_schema/user_view.frm +drop view test.user_view; + + +--echo # Testing mysql_upgrade with PROCEDURE performance_schema.user_proc + +create procedure test.user_proc() + select "Not supposed to be here"; + +update mysql.proc set db='performance_schema' where name='user_proc'; + +--source suite/perfschema/include/upgrade_check.inc + +select name from mysql.proc where db='performance_schema'; + +update mysql.proc set db='test' where name='user_proc'; +drop procedure test.user_proc; + + +--echo # Testing mysql_upgrade with FUNCTION performance_schema.user_func + +create function test.user_func() returns integer + return 0; + +update mysql.proc set db='performance_schema' where name='user_func'; + +--source suite/perfschema/include/upgrade_check.inc + +select name from mysql.proc where db='performance_schema'; + +update mysql.proc set db='test' where name='user_func'; +drop function test.user_func; + + +--echo # Testing mysql_upgrade with EVENT performance_schema.user_event + +create event test.user_event on schedule every 1 day do + select "not supposed to be here"; + +update mysql.event set db='performance_schema' where name='user_event'; + +--source suite/perfschema/include/upgrade_check.inc + +select name from mysql.event where db='performance_schema'; + +update mysql.event set db='test' where name='user_event'; +drop event test.user_event; + diff --git a/mysql-test/suite/perfschema/include/prepared_stmts_deallocation.inc b/mysql-test/suite/perfschema/include/prepared_stmts_deallocation.inc new file mode 100644 index 00000000..1601c027 --- /dev/null +++ b/mysql-test/suite/perfschema/include/prepared_stmts_deallocation.inc @@ -0,0 +1,11 @@ +# +# Deallocates all the prepared statements +# created in prepares_stmts_setup.inc +# + +DEALLOCATE PREPARE st1; +DEALLOCATE PREPARE st2; +DEALLOCATE PREPARE st3; +DEALLOCATE PREPARE st4; + +DROP TABLE t1; diff --git a/mysql-test/suite/perfschema/include/prepared_stmts_execution.inc b/mysql-test/suite/perfschema/include/prepared_stmts_execution.inc new file mode 100644 index 00000000..dbb0696f --- /dev/null +++ b/mysql-test/suite/perfschema/include/prepared_stmts_execution.inc @@ -0,0 +1,18 @@ +# +# Execution of all the prepared statements created in +# prepared_statements_setup.inc. +# + +SET @a = 3; +SET @b = 4; +EXECUTE st1 USING @a, @b; + +#SET @table = 't1'; +EXECUTE st2; + +SET @c=3; +EXECUTE st3 using @c; + +EXECUTE st4; + + diff --git a/mysql-test/suite/perfschema/include/prepared_stmts_setup.inc b/mysql-test/suite/perfschema/include/prepared_stmts_setup.inc new file mode 100644 index 00000000..0fb14a36 --- /dev/null +++ b/mysql-test/suite/perfschema/include/prepared_stmts_setup.inc @@ -0,0 +1,20 @@ +# +# Creating various prepared statements. +# HELPER include/prepared_stmts_setup.inc +# + +CREATE TABLE t1 (a INT NOT NULL); +INSERT INTO t1 VALUES (4), (8), (11), (32), (80); + +# Prepared statments + +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'; diff --git a/mysql-test/suite/perfschema/include/privilege.inc b/mysql-test/suite/perfschema/include/privilege.inc new file mode 100644 index 00000000..f01511b6 --- /dev/null +++ b/mysql-test/suite/perfschema/include/privilege.inc @@ -0,0 +1,164 @@ +# Tests for PERFORMANCE_SCHEMA + +--disable_warnings +drop table if exists test.t1; +--enable_warnings + +## The result of show grants is not consistent across platforms ... +## show grants; + +## Not enforced yet: deny CREATE_ACL and DROP_ACL +## Waiting to remove .FRM files first +## +## --error ER_DBACCESS_DENIED_ERROR +## create table performance_schema.t1(a int); +## +## --error ER_DBACCESS_DENIED_ERROR +## drop table performance_schema.t1; +## +## --error ER_DBACCESS_DENIED_ERROR +## create table performance_schema.setup_instruments(a int); +## +## --error ER_DBACCESS_DENIED_ERROR +## create table performance_schema.events_waits_current(a int); +## +## --error ER_DBACCESS_DENIED_ERROR +## create table performance_schema.file_instances(a int); +## +## --error ER_DBACCESS_DENIED_ERROR +## drop table performance_schema.setup_instruments; +## +## --error ER_DBACCESS_DENIED_ERROR +## drop table performance_schema.events_waits_current; +## +## --error ER_DBACCESS_DENIED_ERROR +## drop table performance_schema.file_instances; + +--error ER_DBACCESS_DENIED_ERROR +rename table performance_schema.setup_instruments to test.t1; + +--error ER_DBACCESS_DENIED_ERROR +rename table performance_schema.events_waits_current to test.t1; + +--error ER_DBACCESS_DENIED_ERROR +rename table performance_schema.file_instances to test.t1; + +--error ER_DBACCESS_DENIED_ERROR +rename table performance_schema.setup_instruments to performance_schema.t1; + +--error ER_DBACCESS_DENIED_ERROR +rename table performance_schema.events_waits_current to performance_schema.t1; + +--error ER_DBACCESS_DENIED_ERROR +rename table performance_schema.file_instances to performance_schema.t1; + +--error ER_DBACCESS_DENIED_ERROR +rename table performance_schema.setup_instruments + to performance_schema.events_waits_current; + +--error ER_DBACCESS_DENIED_ERROR +rename table performance_schema.events_waits_current + to performance_schema.setup_instruments; + +--error ER_DBACCESS_DENIED_ERROR +create procedure performance_schema.my_proc() begin end; + +--error ER_DBACCESS_DENIED_ERROR +create function performance_schema.my_func() returns int return 0; + +--error ER_DBACCESS_DENIED_ERROR +create event performance_schema.my_event on schedule every 15 minute +do begin end; + +--error ER_DBACCESS_DENIED_ERROR +create trigger performance_schema.bi_setup_instruments + before insert on performance_schema.setup_instruments + for each row begin end; + +--error ER_DBACCESS_DENIED_ERROR +create trigger performance_schema.bi_events_waits_current + before insert on performance_schema.events_waits_current + for each row begin end; + +--error ER_DBACCESS_DENIED_ERROR +create trigger performance_schema.bi_file_instances + before insert on performance_schema.file_instances + for each row begin end; + +--error ER_CANT_CREATE_TABLE +create table test.t1(a int) engine=PERFORMANCE_SCHEMA; + +--error ER_CANT_CREATE_TABLE +create table test.t1 like performance_schema.setup_instruments; + +--error ER_CANT_CREATE_TABLE +create table test.t1 like performance_schema.events_waits_current; + +--error ER_CANT_CREATE_TABLE +create table test.t1 like performance_schema.file_instances; + +--error ER_TABLEACCESS_DENIED_ERROR +insert into performance_schema.setup_instruments + set name="foo"; + +--error ER_TABLEACCESS_DENIED_ERROR +insert into performance_schema.events_waits_current + set name="foo"; + +--error ER_TABLEACCESS_DENIED_ERROR +insert into performance_schema.file_instances + set name="foo"; + +--error ER_TABLEACCESS_DENIED_ERROR +delete from performance_schema.setup_instruments; + +--error ER_TABLEACCESS_DENIED_ERROR +delete from performance_schema.events_waits_current; + +--error ER_TABLEACCESS_DENIED_ERROR +delete from performance_schema.file_instances; + +lock table performance_schema.setup_instruments read; +unlock tables; + +lock table performance_schema.setup_instruments write; +unlock tables; + +--error ER_TABLEACCESS_DENIED_ERROR +lock table performance_schema.events_waits_current read; +unlock tables; + +--error ER_TABLEACCESS_DENIED_ERROR +lock table performance_schema.events_waits_current write; +unlock tables; + +--error ER_TABLEACCESS_DENIED_ERROR +lock table performance_schema.file_instances read; +unlock tables; + +--error ER_TABLEACCESS_DENIED_ERROR +lock table performance_schema.file_instances write; +unlock tables; + +--echo # +--echo # WL#4818, NFS2: Can use grants to give normal user access +--echo # to view data from _current and _history tables +--echo # +--echo # Should work as pfs_user_1 and pfs_user_2, but not as pfs_user_3. +--echo # (Except for events_waits_current, which is granted.) + +# Errors here will be caught by the diff afterwards +--disable_abort_on_error + +SELECT "can select" FROM performance_schema.events_waits_history LIMIT 1; + +SELECT "can select" FROM performance_schema.events_waits_history_long LIMIT 1; + +SELECT "can select" FROM performance_schema.events_waits_current LIMIT 1; + +SELECT "can select" FROM performance_schema.events_waits_summary_by_instance LIMIT 1; + +SELECT "can select" FROM performance_schema.file_summary_by_instance LIMIT 1; + +--enable_abort_on_error + diff --git a/mysql-test/suite/perfschema/include/processlist_load.inc b/mysql-test/suite/perfschema/include/processlist_load.inc new file mode 100644 index 00000000..5a14ea17 --- /dev/null +++ b/mysql-test/suite/perfschema/include/processlist_load.inc @@ -0,0 +1,39 @@ +# ../include/processlist_load.inc +# +# SUMMARY +# +# Execute PROCESSLIST queries, sorted by user +# +# USAGE +# +# Example: Using processlist_set.inc to set @@global.performance_schema_show_processlist +# +# let $pfs_spl = on/off +# --source ../include/processlist_set.inc +# --source ../include/processlist_load.inc +# +# Columns +# 1 2 3 4 5 6