Debian Codegraph @

mysql-test/suite/group_replication/r/gr_psi_keys_mysql.result

raw
1 include/group_replication.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6
7 ############################################################
8 # 1. verify that performance schema keys are available in instrument
9 # table immediately after plugin installation
10 # (before starting the GR).
11 SELECT * FROM performance_schema.setup_instruments WHERE NAME LIKE '%group_rpl%' AND NAME NOT LIKE 'wait/synch/%/group_rpl/GCS_%' AND NAME NOT LIKE 'memory/group_rpl/gcs_%';
12 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
13 wait/synch/mutex/group_rpl/LOCK_applier_module_run YES YES singleton NULL 0 NULL
14 wait/synch/mutex/group_rpl/LOCK_applier_module_suspend YES YES singleton NULL 0 NULL
15 wait/synch/mutex/group_rpl/LOCK_autorejoin_module YES YES singleton NULL 0 NULL
16 wait/synch/mutex/group_rpl/LOCK_certifier_broadcast_run YES YES singleton NULL 0 NULL
17 wait/synch/mutex/group_rpl/LOCK_certifier_broadcast_dispatcher_run YES YES singleton NULL 0 NULL
18 wait/synch/mutex/group_rpl/LOCK_certification_info YES YES singleton NULL 0 NULL
19 wait/synch/mutex/group_rpl/LOCK_certification_members YES YES singleton NULL 0 NULL
20 wait/synch/mutex/group_rpl/LOCK_channel_observation_list YES YES singleton NULL 0 NULL
21 wait/synch/mutex/group_rpl/LOCK_channel_observation_removal YES YES singleton NULL 0 NULL
22 wait/synch/mutex/group_rpl/LOCK_clone_donor_list YES YES singleton NULL 0 NULL
23 wait/synch/mutex/group_rpl/LOCK_clone_handler_run YES YES singleton NULL 0 NULL
24 wait/synch/mutex/group_rpl/LOCK_clone_query YES YES singleton NULL 0 NULL
25 wait/synch/mutex/group_rpl/LOCK_clone_read_mode YES YES singleton NULL 0 NULL
26 wait/synch/mutex/group_rpl/LOCK_count_down_latch YES YES singleton NULL 0 NULL
27 wait/synch/mutex/group_rpl/LOCK_delayed_init_run YES YES singleton NULL 0 NULL
28 wait/synch/mutex/group_rpl/LOCK_delayed_init_server_ready YES YES singleton NULL 0 NULL
29 wait/synch/mutex/group_rpl/LOCK_force_members_running YES YES singleton NULL 0 NULL
30 wait/synch/mutex/group_rpl/key_GR_LOCK_group_action_coordinator_process YES YES singleton NULL 0 NULL
31 wait/synch/mutex/group_rpl/key_GR_LOCK_group_action_coordinator_thread YES YES singleton NULL 0 NULL
32 wait/synch/mutex/group_rpl/key_GR_LOCK_group_action_coordinator_thread_end YES YES singleton NULL 0 NULL
33 wait/synch/mutex/group_rpl/LOCK_group_info_manager YES YES singleton NULL 0 NULL
34 wait/synch/mutex/group_rpl/key_GR_LOCK_group_part_handler_abort YES YES singleton NULL 0 NULL
35 wait/synch/mutex/group_rpl/key_GR_LOCK_group_part_handler_run YES YES singleton NULL 0 NULL
36 wait/synch/mutex/group_rpl/LOCK_multi_primary_action_notification YES YES singleton NULL 0 NULL
37 wait/synch/mutex/group_rpl/LOCK_pipeline_continuation YES YES singleton NULL 0 NULL
38 wait/synch/mutex/group_rpl/LOCK_pipeline_stats_flow_control YES YES singleton NULL 0 NULL
39 wait/synch/mutex/group_rpl/LOCK_pipeline_stats_transactions_waiting_apply YES YES singleton NULL 0 NULL
40 wait/synch/mutex/group_rpl/LOCK_plugin_modules_termination YES YES singleton NULL 0 NULL
41 wait/synch/mutex/group_rpl/LOCK_plugin_applier_module_initialize_terminate YES YES singleton NULL 0 NULL
42 wait/synch/mutex/group_rpl/LOCK_plugin_online YES YES singleton NULL 0 NULL
43 wait/synch/mutex/group_rpl/LOCK_primary_election_action_phase YES YES singleton NULL 0 NULL
44 wait/synch/mutex/group_rpl/LOCK_primary_election_action_notification YES YES singleton NULL 0 NULL
45 wait/synch/mutex/group_rpl/LOCK_primary_election_primary_process_run YES YES singleton NULL 0 NULL
46 wait/synch/mutex/group_rpl/LOCK_primary_election_running_flag YES YES singleton NULL 0 NULL
47 wait/synch/mutex/group_rpl/LOCK_primary_election_secondary_process_run YES YES singleton NULL 0 NULL
48 wait/synch/mutex/group_rpl/LOCK_primary_election_validation_notification YES YES singleton NULL 0 NULL
49 wait/synch/mutex/group_rpl/LOCK_primary_promotion_policy YES YES singleton NULL 0 NULL
50 wait/synch/mutex/group_rpl/LOCK_recovery YES YES singleton NULL 0 NULL
51 wait/synch/mutex/group_rpl/LOCK_recovery_donor_selection YES YES singleton NULL 0 NULL
52 wait/synch/mutex/group_rpl/LOCK_recovery_module_run YES YES singleton NULL 0 NULL
53 wait/synch/mutex/group_rpl/LOCK_server_ongoing_transaction_handler YES YES singleton NULL 0 NULL
54 wait/synch/mutex/group_rpl/LOCK_message_service_run YES YES singleton NULL 0 NULL
55 wait/synch/mutex/group_rpl/LOCK_session_thread_method_exec YES YES singleton NULL 0 NULL
56 wait/synch/mutex/group_rpl/LOCK_session_thread_run YES YES singleton NULL 0 NULL
57 wait/synch/mutex/group_rpl/LOCK_stage_monitor_handler YES YES singleton NULL 0 NULL
58 wait/synch/mutex/group_rpl/LOCK_synchronized_queue YES YES singleton NULL 0 NULL
59 wait/synch/mutex/group_rpl/LOCK_transaction_monitoring YES YES singleton NULL 0 NULL
60 wait/synch/mutex/group_rpl/LOCK_transaction_unblocking YES YES singleton NULL 0 NULL
61 wait/synch/mutex/group_rpl/LOCK_group_member_info_manager_update_lock YES YES singleton NULL 0 NULL
62 wait/synch/mutex/group_rpl/LOCK_group_member_info_update_lock YES YES singleton NULL 0 NULL
63 wait/synch/mutex/group_rpl/LOCK_view_modification_wait YES YES singleton NULL 0 NULL
64 wait/synch/mutex/group_rpl/LOCK_wait_ticket YES YES singleton NULL 0 NULL
65 wait/synch/mutex/group_rpl/LOCK_write_lock_protection YES YES singleton NULL 0 NULL
66 wait/synch/mutex/group_rpl/LOCK_mysql_thread_run YES YES singleton NULL 0 NULL
67 wait/synch/mutex/group_rpl/LOCK_mysql_thread_dispatcher_run YES YES singleton NULL 0 NULL
68 wait/synch/mutex/group_rpl/LOCK_connection_map YES YES singleton NULL 0 NULL
69 wait/synch/mutex/group_rpl/LOCK_mysql_handler_thread_run YES YES singleton NULL 0 NULL
70 wait/synch/mutex/group_rpl/LOCK_mysql_thread_handler_dispatcher_run YES YES singleton NULL 0 NULL
71 wait/synch/mutex/group_rpl/LOCK_mysql_handler_thread_read_only_mode_run YES YES singleton NULL 0 NULL
72 wait/synch/mutex/group_rpl/LOCK_mysql_thread_handler_read_only_mode_dispatcher_run YES YES singleton NULL 0 NULL
73 wait/synch/rwlock/group_rpl/RWLOCK_certifier_stable_gtid_set YES YES singleton NULL 0 NULL
74 wait/synch/rwlock/group_rpl/RWLOCK_channel_observation_list YES YES singleton NULL 0 NULL
75 wait/synch/rwlock/group_rpl/RWLOCK_gcs_operations YES YES singleton NULL 0 NULL
76 wait/synch/rwlock/group_rpl/RWLOCK_gcs_operations_view_change_observers YES YES singleton NULL 0 NULL
77 wait/synch/rwlock/group_rpl/RWLOCK_group_event_observation_list YES YES singleton NULL 0 NULL
78 wait/synch/rwlock/group_rpl/RWLOCK_io_cache_unused_list YES YES singleton NULL 0 NULL
79 wait/synch/rwlock/group_rpl/RWLOCK_plugin_running YES YES singleton NULL 0 NULL
80 wait/synch/rwlock/group_rpl/RWLOCK_plugin_stop YES YES singleton NULL 0 NULL
81 wait/synch/rwlock/group_rpl/RWLOCK_transaction_observation_list YES YES singleton NULL 0 NULL
82 wait/synch/rwlock/group_rpl/RWLOCK_transaction_consistency_manager_map YES YES singleton NULL 0 NULL
83 wait/synch/rwlock/group_rpl/RWLOCK_transaction_consistency_manager_prepared_transactions_on_my_applier YES YES singleton NULL 0 NULL
84 wait/synch/rwlock/group_rpl/RWLOCK_flow_control_module_info YES YES singleton NULL 0 NULL
85 wait/synch/rwlock/group_rpl/RWLOCK_transaction_consistency_info_members_that_must_prepare_the_transaction YES YES singleton NULL 0 NULL
86 wait/synch/cond/group_rpl/COND_applier_module_run YES YES singleton NULL 0 NULL
87 wait/synch/cond/group_rpl/COND_applier_module_suspend YES YES singleton NULL 0 NULL
88 wait/synch/cond/group_rpl/COND_applier_module_wait YES YES singleton NULL 0 NULL
89 wait/synch/cond/group_rpl/COND_certifier_broadcast_run YES YES singleton NULL 0 NULL
90 wait/synch/cond/group_rpl/COND_certifier_broadcast_dispatcher_run YES YES singleton NULL 0 NULL
91 wait/synch/cond/group_rpl/COND_clone_handler_run YES YES singleton NULL 0 NULL
92 wait/synch/cond/group_rpl/COND_delayed_init_run YES YES singleton NULL 0 NULL
93 wait/synch/cond/group_rpl/COND_delayed_init_server_ready YES YES singleton NULL 0 NULL
94 wait/synch/cond/group_rpl/COND_group_action_coordinator_process YES YES singleton NULL 0 NULL
95 wait/synch/cond/group_rpl/COND_group_action_coordinator_thread YES YES singleton NULL 0 NULL
96 wait/synch/cond/group_rpl/COND_group_action_coordinator_thread_end YES YES singleton NULL 0 NULL
97 wait/synch/cond/group_rpl/COND_group_part_handler_run YES YES singleton NULL 0 NULL
98 wait/synch/cond/group_rpl/COND_group_part_handler_abort YES YES singleton NULL 0 NULL
99 wait/synch/cond/group_rpl/COND_message_service_run YES YES singleton NULL 0 NULL
100 wait/synch/cond/group_rpl/COND_multi_primary_action_notification YES YES singleton NULL 0 NULL
101 wait/synch/cond/group_rpl/COND_transaction_monitoring_wait YES YES singleton NULL 0 NULL
102 wait/synch/cond/group_rpl/COND_view_modification_wait YES YES singleton NULL 0 NULL
103 wait/synch/cond/group_rpl/COND_pipeline_continuation YES YES singleton NULL 0 NULL
104 wait/synch/cond/group_rpl/COND_synchronized_queue YES YES singleton NULL 0 NULL
105 wait/synch/cond/group_rpl/COND_count_down_latch YES YES singleton NULL 0 NULL
106 wait/synch/cond/group_rpl/COND_wait_ticket YES YES singleton NULL 0 NULL
107 wait/synch/cond/group_rpl/COND_recovery_module_run YES YES singleton NULL 0 NULL
108 wait/synch/cond/group_rpl/COND_recovery YES YES singleton NULL 0 NULL
109 wait/synch/cond/group_rpl/COND_session_thread_method_exec YES YES singleton NULL 0 NULL
110 wait/synch/cond/group_rpl/COND_session_thread_run YES YES singleton NULL 0 NULL
111 wait/synch/cond/group_rpl/COND_pipeline_stats_flow_control YES YES singleton NULL 0 NULL
112 wait/synch/cond/group_rpl/COND_primary_election_action_notification YES YES singleton NULL 0 NULL
113 wait/synch/cond/group_rpl/COND_primary_election_primary_process_run YES YES singleton NULL 0 NULL
114 wait/synch/cond/group_rpl/COND_primary_election_secondary_process_run YES YES singleton NULL 0 NULL
115 wait/synch/cond/group_rpl/COND_primary_election_validation_notification YES YES singleton NULL 0 NULL
116 wait/synch/cond/group_rpl/COND_write_lock_protection YES YES singleton NULL 0 NULL
117 wait/synch/cond/group_rpl/COND_plugin_online YES YES singleton NULL 0 NULL
118 wait/synch/cond/group_rpl/COND_primary_promotion_policy YES YES singleton NULL 0 NULL
119 wait/synch/cond/group_rpl/COND_autorejoin_module YES YES singleton NULL 0 NULL
120 wait/synch/cond/group_rpl/COND_mysql_thread_run YES YES singleton NULL 0 NULL
121 wait/synch/cond/group_rpl/COND_mysql_thread_dispatcher_run YES YES singleton NULL 0 NULL
122 wait/synch/cond/group_rpl/COND_mysql_thread_handler_run YES YES singleton NULL 0 NULL
123 wait/synch/cond/group_rpl/COND_mysql_thread_handler_dispatcher_run YES YES singleton NULL 0 NULL
124 wait/synch/cond/group_rpl/COND_mysql_thread_handler_read_only_mode_run YES YES singleton NULL 0 NULL
125 wait/synch/cond/group_rpl/COND_mysql_thread_handler_read_only_mode_dispatcher_run YES YES singleton NULL 0 NULL
126 stage/group_rpl/Undergoing auto-rejoin procedure YES YES progress NULL 0 NULL
127 stage/group_rpl/Multi-primary Switch: waiting for pending transactions to finish YES YES progress NULL 0 NULL
128 stage/group_rpl/Multi-primary Switch: waiting on another member step completion YES YES progress NULL 0 NULL
129 stage/group_rpl/Multi-primary Switch: applying buffered transactions YES YES progress NULL 0 NULL
130 stage/group_rpl/Multi-primary Switch: waiting for operation to complete on all members YES YES progress NULL 0 NULL
131 stage/group_rpl/Primary Election: applying buffered transactions YES YES progress NULL 0 NULL
132 stage/group_rpl/Primary Election: waiting on current primary transaction execution YES YES progress NULL 0 NULL
133 stage/group_rpl/Primary Election: waiting for members to enable super_read_only YES YES progress NULL 0 NULL
134 stage/group_rpl/Primary Election: stabilizing transactions from former primaries YES YES progress NULL 0 NULL
135 stage/group_rpl/Primary Switch: checking current primary pre-conditions YES YES progress NULL 0 NULL
136 stage/group_rpl/Primary Switch: waiting for pending transactions to finish YES YES progress NULL 0 NULL
137 stage/group_rpl/Primary Switch: executing Primary election YES YES progress NULL 0 NULL
138 stage/group_rpl/Primary Switch: waiting on another member step completion YES YES progress NULL 0 NULL
139 stage/group_rpl/Primary Switch: waiting for operation to complete on all members YES YES progress NULL 0 NULL
140 stage/group_rpl/Single-primary Switch: checking group pre-conditions YES YES progress NULL 0 NULL
141 stage/group_rpl/Single-primary Switch: executing Primary election YES YES progress NULL 0 NULL
142 stage/group_rpl/Single-primary Switch: waiting for operation to complete on all members YES YES progress NULL 0 NULL
143 stage/group_rpl/Group Replication Module: Executing YES YES NULL 0 NULL
144 stage/group_rpl/Group Replication Module: Suspending YES YES NULL 0 NULL
145 stage/group_rpl/Group Replication Recovery: Connecting to donor YES YES NULL 0 NULL
146 stage/group_rpl/Group Replication Recovery: Transferring state from donor YES YES NULL 0 NULL
147 stage/group_rpl/Group Replication Cloning process: Preparing YES YES progress NULL 0 NULL
148 stage/group_rpl/Group Replication Cloning process: Executing YES YES progress NULL 0 NULL
149 memory/group_rpl/write_set_encoded YES NULL global_statistics 0 Memory used to encode write set before getting broadcasted to group members.
150 memory/group_rpl/certification_data YES NULL global_statistics 0 Memory gets allocated for this Event name when new incoming transaction is received for certification.
151 memory/group_rpl/certification_data_gc YES NULL global_statistics 0 Memory used to hold the GTID_EXECUTED sent by each member for garbage collection.
152 memory/group_rpl/certification_info YES NULL global_statistics 0 Memory used to store certification information which is used to handle conflict resolution between transactions that execute concurrently.
153 memory/group_rpl/transaction_data YES NULL global_statistics 0 Memory gets allocated for this Event name when the incoming transaction is queued to be handled by the plugin pipeline.
154 memory/group_rpl/sql_service_command_data YES NULL global_statistics 0 Memory gets allocated when internal sql service commands is added to queue to process in orderly manner.
155 memory/group_rpl/mysql_thread_queued_task YES NULL global_statistics 0 Memory gets allocated when a Mysql_thread dependent task is added to queue to process in orderly manner.
156 memory/group_rpl/message_service_queue YES NULL global_statistics 0 Memory gets allocated when messages of Group Replication: delivery message service are added to deliver them in orderly manner.
157 memory/group_rpl/message_service_received_message YES NULL global_statistics 0 Memory used to receive messages for Group Replication: delivery message service.
158 memory/group_rpl/group_member_info YES NULL global_statistics 0 Memory used to hold properties of a group member like hostname, port, member weight, member role (primary/secondary)
159 memory/group_rpl/consistent_members_that_must_prepare_transaction YES NULL global_statistics 0 Memory used to hold list of members that must prepare the transaction for the Group Replication Transaction Consistency Guarantees.
160 memory/group_rpl/consistent_transactions YES NULL global_statistics 0 Memory used to hold transaction and list of members that must prepare that transaction for the Group Replication Transaction Consistency Guarantees.
161 memory/group_rpl/consistent_transactions_prepared YES NULL global_statistics 0 Memory used to hold list of transaction info which are prepared for the Group Replication Transaction Consistency Guarantees.
162 memory/group_rpl/consistent_transactions_waiting YES NULL global_statistics 0 Memory used to hold list of transaction info if there are precedent prepared transactions with consistency AFTER and BEFORE_AND_AFTER to hold the transaction until the prepared are committed.
163 memory/group_rpl/consistent_transactions_delayed_view_change YES NULL global_statistics 0 Memory used to hold list of View_change_log_event which are delayed after the prepared consistent transactions waiting for the prepare acknowledge.
164
165 ############################################################
166 # 2. Start the GR
167 include/start_and_bootstrap_group_replication.inc
168
169 ############################################################
170 # 3. Verify that there are no extra psi keys that were added
171 # after starting the GR
172 include/assert.inc ['There should be no extra psi keys added after starting the GR']
173
174 ############################################################
175 # 4. Verify that performance_schema.threads list the usual
176 # threads after member is ONLINE.
177 SELECT NAME, TYPE, INSTRUMENTED FROM performance_schema.threads WHERE NAME LIKE '%group_rpl%' ORDER BY NAME;
178 NAME TYPE INSTRUMENTED
179 thread/group_rpl/THD_applier_module_receiver FOREGROUND YES
180 thread/group_rpl/THD_certifier_broadcast BACKGROUND YES
181 thread/group_rpl/THD_Gcs_ext_logger_impl::m_consumer BACKGROUND YES
182 thread/group_rpl/THD_Gcs_xcom_control::m_suspicions_processing_thread BACKGROUND YES
183 thread/group_rpl/THD_Gcs_xcom_control::m_xcom_thread BACKGROUND YES
184 thread/group_rpl/THD_Gcs_xcom_engine::m_engine_thread BACKGROUND YES
185 thread/group_rpl/THD_message_service_handler BACKGROUND YES
186 thread/group_rpl/THD_mysql_thread BACKGROUND YES
187 thread/group_rpl/THD_mysql_thread_handler BACKGROUND YES
188 thread/group_rpl/THD_mysql_thread_handler_read_only_mode BACKGROUND YES
189
190 ############################################################
191 # 5. Test end.
192 include/group_replication_end.inc