Debian Codegraph @

mysql-test/suite/group_replication/r/gr_group_member_info_psi_memory.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 include/start_and_bootstrap_group_replication.inc
7
8 ############################################################
9 # 1. Verify that the entries corresponding to the
10 # instrumented memory are in the setup instruments
11 # table and the memory summary tables.
12 SELECT * FROM performance_schema.setup_instruments WHERE NAME LIKE 'memory/group_rpl/group_member_info';
13 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
14 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)
15 include/assert.inc ['There should be 1 entry corresponding to the group_member_info in the setup_instruments table after starting GR']
16 SELECT EVENT_NAME FROM performance_schema.memory_summary_global_by_event_name WHERE EVENT_NAME LIKE 'memory/group_rpl/group_member_info';
17 EVENT_NAME
18 memory/group_rpl/group_member_info
19 include/assert.inc ['There should be 1 entry corresponding to the group_member_info in the memory_summary_global_by_event_name table after starting GR']
20
21 ############################################################
22 # 2. Verify that the sum of bytes allocated is greater than
23 # zero.
24 include/assert.inc ['The sum bytes allocated must be greater than 0']
25
26 ############################################################
27 # 3. Stop GR
28 include/stop_group_replication.inc
29 include/uninstall_group_replication_plugin.inc
30
31 ##############################################################
32 # 4. Verify that the entries corresponding to the instrumented
33 # group_member_info remain in the tables after uninstalling GR.
34 SELECT * FROM performance_schema.setup_instruments WHERE NAME LIKE 'memory/group_rpl/group_member_info';
35 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
36 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)
37 include/assert.inc ['There should be 1 entry corresponding to the group_member_info in the setup_instruments table after uninstalling GR']
38 SELECT EVENT_NAME, CURRENT_NUMBER_OF_BYTES_USED FROM performance_schema.memory_summary_global_by_event_name WHERE EVENT_NAME LIKE 'memory/group_rpl/group_member_info';
39 EVENT_NAME CURRENT_NUMBER_OF_BYTES_USED
40 memory/group_rpl/group_member_info 0
41 include/assert.inc ['There should be 1 entry corresponding to the group_member_info in the memory_summary_global_by_event_name table after uninstalling GR']
42
43 #################################################################
44 # 5. Assert that the number of bytes allocated for
45 # group_member_info event must be 0.
46 include/assert.inc ['The sum of bytes allocated must be zero after uninstalling GR']
47
48 #################################################################
49 # 6. Clean up.
50 include/install_group_replication_plugin.inc
51 include/group_replication_end.inc