Debian Codegraph @

mysql-test/suite/group_replication/r/gr_gcs_message_data_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
7 ############################################################
8 # 1. Verify that the entries corresponding to the
9 # instrumented memory are in the setup instruments
10 # table and the memory summary tables.
11 SELECT * FROM performance_schema.setup_instruments WHERE NAME LIKE 'memory/group_rpl/Gcs_message_data::m_buffer';
12 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
13 memory/group_rpl/Gcs_message_data::m_buffer YES NULL global_statistics 0 Memory used for the transaction data payload which is send to the network.
14 include/assert.inc ['There should be 1 entry corresponding to the Gcs_message_data::m_buffer in the setup_instruments table after starting GR']
15 SELECT EVENT_NAME FROM performance_schema.memory_summary_global_by_event_name WHERE EVENT_NAME LIKE 'memory/group_rpl/Gcs_message_data::m_buffer';
16 EVENT_NAME
17 memory/group_rpl/Gcs_message_data::m_buffer
18 include/assert.inc ['There should be 1 entry corresponding to the Gcs_message_data::m_buffer in the memory_summary_global_by_event_name table after starting GR']
19
20 ############################################################
21 # 2. Verify that the sum of bytes allocated is greater than
22 # zero for a transaction and zero after transaction is
23 # finished.
24 [connection server1]
25 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY, c2 LONGBLOB) ENGINE=innodb;
26 include/rpl_sync.inc
27 [connection server_1]
28 SET @@GLOBAL.DEBUG= '+d,group_replication_before_message_broadcast';
29 BEGIN;
30 INSERT INTO t1 VALUES (1, repeat('a',1024*1024));
31 COMMIT;
32 [connection server1]
33 include/assert.inc ['The sum of bytes allocated must be greater than 1MB']
34 SET @@GLOBAL.DEBUG= '+d,group_replication_after_before_commit_hook';
35 SET @@GLOBAL.DEBUG= '-d,group_replication_before_message_broadcast';
36 SET DEBUG_SYNC= "now SIGNAL waiting";
37 include/assert.inc ['The sum of bytes allocated must be 0']
38 SET @@GLOBAL.DEBUG= '-d,group_replication_after_before_commit_hook';
39 SET DEBUG_SYNC= "now SIGNAL signal.group_replication_after_before_commit_hook_continue";
40 [connection server_1]
41 DROP TABLE t1;
42
43 ############################################################
44 # 3. Stop GR
45 include/stop_group_replication.inc
46
47 ##############################################################
48 # 4. Verify that the entries corresponding to the instrumented
49 # Gcs_message_data::m_buffer remain in the tables after stopping GR.
50 SELECT * FROM performance_schema.setup_instruments WHERE NAME LIKE 'memory/group_rpl/Gcs_message_data::m_buffer';
51 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
52 memory/group_rpl/Gcs_message_data::m_buffer YES NULL global_statistics 0 Memory used for the transaction data payload which is send to the network.
53 include/assert.inc ['There should be 1 entry corresponding to the Gcs_message_data::m_buffer in the setup_instruments table after stopping GR']
54 SELECT EVENT_NAME, CURRENT_NUMBER_OF_BYTES_USED FROM performance_schema.memory_summary_global_by_event_name WHERE EVENT_NAME LIKE 'memory/group_rpl/Gcs_message_data::m_buffer';
55 EVENT_NAME CURRENT_NUMBER_OF_BYTES_USED
56 memory/group_rpl/Gcs_message_data::m_buffer 0
57 include/assert.inc ['There should be 1 entry corresponding to the Gcs_message_data::m_buffer in the memory_summary_global_by_event_name table after stopping GR']
58
59 #################################################################
60 # 5. Assert that the number of bytes allocated for
61 # Gcs_message_data::m_buffer event must be 0.
62 include/assert.inc ['The sum of bytes allocated must be zero after stopping GR']
63
64 #################################################################
65 # 6. Cleanup
66 include/group_replication_end.inc