Debian Codegraph @

mysql-test/suite/group_replication/t/gr_assert_psi_memory_instruments_disabled.test

raw
1 ###############################################################################
2 # This test verifies that for every memory instrument associated to a Group
3 # Replication Event Names:
4 # - memory instrument is disabled on mysql server start.
5 # - can be enabled by updating ENABLED column of setup_instruments table.
6 #
7 # Test:
8 # 0. The test requires one Server: M1
9 # 1. Restart the server with start on boot enabled
10 # 2. Verify following for all Group Replication Event Names:
11 # i. Event name is disabled on mysql server start.
12 # ii. Event name can be enabled by updating ENABLED column
13 # of setup_instruments table.
14 # 3. Cleanup
15 ###############################################################################
16
17 --source include/have_group_replication_plugin.inc
18 --source include/group_replication.inc
19
20 --echo
21 --echo ############################################################
22 --echo # 1. Restart the server with start on boot enabled
23
24 --let $allow_rpl_inited=1
25 --let $_group_replication_local_address= `SELECT @@GLOBAL.group_replication_local_address`
26 --let $_group_replication_group_seeds= `SELECT @@GLOBAL.group_replication_group_seeds`
27 --let $restart_parameters=restart:--group_replication_local_address=$_group_replication_local_address --group_replication_group_seeds=$_group_replication_group_seeds --group_replication_start_on_boot=1 --group-replication-group-name=$group_replication_group_name --performance-schema-instrument='memory/group_rpl/%=OFF'
28 --replace_result $_group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS $_group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
29 --source include/restart_mysqld.inc
30
31 --let $rpl_server_number= 1
32 --source include/rpl_reconnect.inc
33
34 --let $group_replication_member_state= ONLINE
35 --source include/gr_wait_for_member_state.inc
36
37
38 --echo
39 --echo ############################################################
40 --echo # 2. Verify following for all Group Replication Event Names:
41 --echo # i. Event name is disabled on mysql server start.
42 --echo # ii. Event name can be enabled by updating ENABLED column
43 --echo # of setup_instruments table.
44
45 # Event name: write_set_encoded
46 --let $ps_event_name= memory/group_rpl/write_set_encoded
47 --let $ps_event_name_status= 0
48 --source include/assert_psi_memory_instrument.inc
49
50 # Event name: Gcs_message_data::m_buffer
51 --let $ps_event_name= memory/group_rpl/Gcs_message_data::m_buffer
52 --source include/assert_psi_memory_instrument.inc
53
54 # Event name: certification_data
55 --let $ps_event_name= memory/group_rpl/certification_data
56 --let $ps_event_name_status= 0
57 --source include/assert_psi_memory_instrument.inc
58
59 # Event name: certification_data_gc
60 --let $ps_event_name= memory/group_rpl/certification_data_gc
61 --let $ps_event_name_status= 0
62 --source include/assert_psi_memory_instrument.inc
63
64 # Event name: certification_info
65 --let $ps_event_name= memory/group_rpl/certification_info
66 --let $ps_event_name_status= 0
67 --source include/assert_psi_memory_instrument.inc
68
69 # Event name: transaction_data
70 --let $ps_event_name= memory/group_rpl/transaction_data
71 --let $ps_event_name_status= 0
72 --source include/assert_psi_memory_instrument.inc
73
74 # Event name: message_service_received_message
75 --let $ps_event_name= memory/group_rpl/message_service_received_message
76 --let $ps_event_name_status= 0
77 --source include/assert_psi_memory_instrument.inc
78
79 # Event name: sql_service_command_data
80 --let $ps_event_name= memory/group_rpl/sql_service_command_data
81 --let $ps_event_name_status= 0
82 --source include/assert_psi_memory_instrument.inc
83
84 # Event name: mysql_thread_queued_task
85 --let $ps_event_name= memory/group_rpl/mysql_thread_queued_task
86 --let $ps_event_name_status= 0
87 --source include/assert_psi_memory_instrument.inc
88
89 # Event name: message_service_queue
90 --let $ps_event_name= memory/group_rpl/message_service_queue
91 --let $ps_event_name_status= 0
92 --source include/assert_psi_memory_instrument.inc
93
94 # Event name: consistent_members_that_must_prepare_transaction
95 --let $ps_event_name= memory/group_rpl/consistent_members_that_must_prepare_transaction
96 --let $ps_event_name_status= 0
97 --source include/assert_psi_memory_instrument.inc
98
99 # Event name: consistent_transactions
100 --let $ps_event_name= memory/group_rpl/consistent_transactions
101 --let $ps_event_name_status= 0
102 --source include/assert_psi_memory_instrument.inc
103
104 # Event name: consistent_transactions_prepared
105 --let $ps_event_name= memory/group_rpl/consistent_transactions_prepared
106 --let $ps_event_name_status= 0
107 --source include/assert_psi_memory_instrument.inc
108
109 # Event name: consistent_transactions_waiting
110 --let $ps_event_name= memory/group_rpl/consistent_transactions_waiting
111 --let $ps_event_name_status= 0
112 --source include/assert_psi_memory_instrument.inc
113
114 # Event name: consistent_transactions_delayed_view_change
115 --let $ps_event_name= memory/group_rpl/consistent_transactions_delayed_view_change
116 --let $ps_event_name_status= 0
117 --source include/assert_psi_memory_instrument.inc
118
119
120 --echo
121 --echo ############################################################
122 --echo # 3. Cleanup
123 --source include/group_replication_end.inc