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