Debian Codegraph @

mysql-test/suite/perfschema/r/rpl_gtid_func.result

raw
1 include/master-slave.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 master]
6 **** On Master ****
7 drop table if exists test.marker;
8 create table test.marker(a int) engine=innodb;
9 insert into test.marker values (1);
10 select * from test.marker;
11 a
12 1
13 truncate table performance_schema.events_waits_history_long;
14 truncate table performance_schema.events_statements_summary_by_digest;
15 update performance_schema.setup_instruments
16 set enabled='YES', timed='YES';
17 **** On Slave ****
18 truncate table performance_schema.events_waits_history_long;
19 truncate table performance_schema.events_statements_summary_by_digest;
20 update performance_schema.setup_instruments
21 set enabled='YES', timed='NO';
22 **** On Master ****
23 select * from performance_schema.setup_instruments
24 where timed='NO' and name not like "memory/%";
25 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
26 select "This better be in the master" as in_master_digest;
27 in_master_digest
28 This better be in the master
29 insert into performance_schema.setup_objects
30 values ('TABLE', 'master', 'foo', 'YES', 'YES');
31 select * from performance_schema.setup_objects
32 order by object_type, object_schema, object_name;
33 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
34 EVENT % % YES YES
35 EVENT information_schema % NO NO
36 EVENT mysql % NO NO
37 EVENT performance_schema % NO NO
38 FUNCTION % % YES YES
39 FUNCTION information_schema % NO NO
40 FUNCTION mysql % NO NO
41 FUNCTION performance_schema % NO NO
42 PROCEDURE % % YES YES
43 PROCEDURE information_schema % NO NO
44 PROCEDURE mysql % NO NO
45 PROCEDURE performance_schema % NO NO
46 TABLE % % YES YES
47 TABLE information_schema % NO NO
48 TABLE master foo YES YES
49 TABLE mysql % NO NO
50 TABLE performance_schema % NO NO
51 TRIGGER % % YES YES
52 TRIGGER information_schema % NO NO
53 TRIGGER mysql % NO NO
54 TRIGGER performance_schema % NO NO
55 select digest, digest_text, count_star
56 from performance_schema.events_statements_summary_by_digest
57 where digest_text like "%in_%_digest%";
58 digest digest_text count_star
59 1113135720bfa2871d2698503ecb3343bf5bda7f4cd97ac60f81c9a19cd384ea SELECT ? AS `in_master_digest` 1
60 insert into test.marker values (2);
61 **** On Slave ****
62 select * from test.marker;
63 a
64 1
65 2
66 select * from performance_schema.setup_instruments
67 where timed='YES';
68 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
69 select "This better be in the slave" as in_slave_digest;
70 in_slave_digest
71 This better be in the slave
72 insert into performance_schema.setup_objects
73 values ('TABLE', 'slave', 'foo', 'YES', 'YES');
74 select * from performance_schema.setup_objects
75 order by object_type, object_schema, object_name;
76 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
77 EVENT % % YES YES
78 EVENT information_schema % NO NO
79 EVENT mysql % NO NO
80 EVENT performance_schema % NO NO
81 FUNCTION % % YES YES
82 FUNCTION information_schema % NO NO
83 FUNCTION mysql % NO NO
84 FUNCTION performance_schema % NO NO
85 PROCEDURE % % YES YES
86 PROCEDURE information_schema % NO NO
87 PROCEDURE mysql % NO NO
88 PROCEDURE performance_schema % NO NO
89 TABLE % % YES YES
90 TABLE information_schema % NO NO
91 TABLE mysql % NO NO
92 TABLE performance_schema % NO NO
93 TABLE slave foo YES YES
94 TRIGGER % % YES YES
95 TRIGGER information_schema % NO NO
96 TRIGGER mysql % NO NO
97 TRIGGER performance_schema % NO NO
98 select digest, digest_text, count_star
99 from performance_schema.events_statements_summary_by_digest
100 where digest_text like "%in_%_digest%";
101 digest digest_text count_star
102 8a5ac97f0db99a2f19b8a07d18fe5a06bd0247f9cd61ee6b16ae1dc1ee3e0a6d SELECT ? AS `in_slave_digest` 1
103 **** On Master ****
104 delete from performance_schema.setup_objects
105 where object_schema='master';
106 **** On Slave ****
107 delete from performance_schema.setup_objects
108 where object_schema='slave';
109 select * from performance_schema.setup_objects;
110 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
111 EVENT mysql % NO NO
112 EVENT performance_schema % NO NO
113 EVENT information_schema % NO NO
114 EVENT % % YES YES
115 FUNCTION mysql % NO NO
116 FUNCTION performance_schema % NO NO
117 FUNCTION information_schema % NO NO
118 FUNCTION % % YES YES
119 PROCEDURE mysql % NO NO
120 PROCEDURE performance_schema % NO NO
121 PROCEDURE information_schema % NO NO
122 PROCEDURE % % YES YES
123 TABLE mysql % NO NO
124 TABLE performance_schema % NO NO
125 TABLE information_schema % NO NO
126 TABLE % % YES YES
127 TRIGGER mysql % NO NO
128 TRIGGER performance_schema % NO NO
129 TRIGGER information_schema % NO NO
130 TRIGGER % % YES YES
131 include/rpl_end.inc