Debian Codegraph @

mysql-test/suite/perfschema/t/rpl_gtid_func.test

raw
1 # Test requires: sp-protocol/ps-protocol/view-protocol/cursor-protocol disabled
2 --source include/no_protocol.inc
3
4 -- source include/master-slave.inc
5
6 connection master;
7 --echo **** On Master ****
8
9 --disable_warnings
10 drop table if exists test.marker;
11 --enable_warnings
12
13 create table test.marker(a int) engine=innodb;
14 insert into test.marker values (1);
15 select * from test.marker;
16
17 truncate table performance_schema.events_waits_history_long;
18 truncate table performance_schema.events_statements_summary_by_digest;
19
20 update performance_schema.setup_instruments
21 set enabled='YES', timed='YES';
22
23 sync_slave_with_master;
24 --echo **** On Slave ****
25
26 truncate table performance_schema.events_waits_history_long;
27 truncate table performance_schema.events_statements_summary_by_digest;
28
29 update performance_schema.setup_instruments
30 set enabled='YES', timed='NO';
31
32 connection master;
33 --echo **** On Master ****
34
35 select * from performance_schema.setup_instruments
36 where timed='NO' and name not like "memory/%";
37
38 select "This better be in the master" as in_master_digest;
39
40 insert into performance_schema.setup_objects
41 values ('TABLE', 'master', 'foo', 'YES', 'YES');
42
43 select * from performance_schema.setup_objects
44 order by object_type, object_schema, object_name;
45
46 select digest, digest_text, count_star
47 from performance_schema.events_statements_summary_by_digest
48 where digest_text like "%in_%_digest%";
49
50 insert into test.marker values (2);
51
52 sync_slave_with_master;
53 --echo **** On Slave ****
54
55 select * from test.marker;
56
57 select * from performance_schema.setup_instruments
58 where timed='YES';
59
60 select "This better be in the slave" as in_slave_digest;
61
62 insert into performance_schema.setup_objects
63 values ('TABLE', 'slave', 'foo', 'YES', 'YES');
64
65 select * from performance_schema.setup_objects
66 order by object_type, object_schema, object_name;
67
68 select digest, digest_text, count_star
69 from performance_schema.events_statements_summary_by_digest
70 where digest_text like "%in_%_digest%";
71
72 connection master;
73 --echo **** On Master ****
74 delete from performance_schema.setup_objects
75 where object_schema='master';
76 sync_slave_with_master;
77 --echo **** On Slave ****
78
79 delete from performance_schema.setup_objects
80 where object_schema='slave';
81 select * from performance_schema.setup_objects;
82
83 --disable_query_log
84 --disable_warnings
85 connection master;
86 drop table test.marker;
87 sync_slave_with_master;
88 --enable_warnings
89 --enable_query_log
90 --source include/rpl_end.inc