Debian Codegraph @

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

raw
1 include/have_replication_observers_example_plugin.inc
2 include/group_replication.inc
3 Warnings:
4 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
5 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.
6 [connection server1]
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 SET @@GLOBAL.DEBUG= '+d,group_replication_message_service_dispatcher_before_pop';
13 include/start_and_bootstrap_group_replication.inc
14 SELECT * FROM performance_schema.setup_instruments WHERE NAME LIKE 'memory/group_rpl/message_service_queue';
15 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
16 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.
17 include/assert.inc ['There should be 1 entry corresponding to the message_service_queue in the setup_instruments table after starting GR']
18 SELECT EVENT_NAME FROM performance_schema.memory_summary_global_by_event_name WHERE EVENT_NAME LIKE 'memory/group_rpl/message_service_queue';
19 EVENT_NAME
20 memory/group_rpl/message_service_queue
21 include/assert.inc ['There should be 1 entry corresponding to the message_service_queue in the memory_summary_global_by_event_name table after starting GR']
22
23 ############################################################
24 # 2. Load plugin replication observers example on server1
25 include/install_replication_observers_example.inc
26
27 ############################################################
28 # 3. Verify that the sum of bytes allocated is greater than
29 # zero for the transmitted tag and message over GR send
30 # service.
31 SELECT group_replication_service_message_send("TAG", repeat('a',1024*1024));
32 group_replication_service_message_send("TAG", repeat('a',1024*1024))
33 The tag and message was sent to the group.
34 [connection server_1]
35 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_message_service_dispatcher_before_pop_reached";
36 include/assert.inc ['The sum bytes allocated must be greater than 0']
37 SET @@GLOBAL.DEBUG= '-d,group_replication_message_service_dispatcher_before_pop';
38 SET DEBUG_SYNC= "now SIGNAL signal.group_replication_message_service_dispatcher_before_pop_continue";
39
40 ############################################################
41 # 4. Assert server1 received messages transmitted by GR message
42 # delivery
43
44 ##############################################################
45 # 5. Verify that the entries corresponding to the instrumented
46 # message_service_queue remain in the tables after stopping GR.
47 include/stop_group_replication.inc
48 SELECT * FROM performance_schema.setup_instruments WHERE NAME LIKE 'memory/group_rpl/message_service_queue';
49 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
50 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.
51 include/assert.inc ['There should be 1 entry corresponding to the message_service_queue in the setup_instruments table after stopping GR']
52 SELECT EVENT_NAME, CURRENT_NUMBER_OF_BYTES_USED FROM performance_schema.memory_summary_global_by_event_name WHERE EVENT_NAME LIKE 'memory/group_rpl/message_service_queue';
53 EVENT_NAME CURRENT_NUMBER_OF_BYTES_USED
54 memory/group_rpl/message_service_queue 0
55 include/assert.inc ['There should be 1 entry corresponding to the message_service_queue in the memory_summary_global_by_event_name table after stopping GR']
56
57 #################################################################
58 # 6. Assert that the number of bytes allocated for
59 # message_service_queue event must be 0.
60 include/assert.inc ['The sum of bytes allocated must be zero after stopping GR']
61
62 #################################################################
63 # 7. Cleanup
64 include/uninstall_replication_observers_example.inc
65 include/group_replication_end.inc