Debian Codegraph @

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

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