Debian Codegraph @

mysql-test/suite/perfschema/r/idx_compare_replication_applier_status_by_worker.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 include/stop_slave.inc
7 SET @old_replica_parallel_workers= @@global.replica_parallel_workers;
8 SET GLOBAL replica_parallel_workers= 4;
9 include/start_slave.inc
10 select THREAD_ID
11 into @worker_thread_id
12 from performance_schema.replication_applier_status_by_worker
13 where WORKER_ID = 1
14 limit 1;
15 select NAME from performance_schema.threads
16 where THREAD_ID = @worker_thread_id;
17 NAME
18 thread/sql/replica_worker
19
20 ## Create index_test() procedure
21 DROP PROCEDURE IF EXISTS index_test;
22 SET @pfs_columns = "CHANNEL_NAME, WORKER_ID, THREAD_ID";
23 TABLE: "replication_applier_status_by_worker"
24 INDEXES: PK (CHANNEL_NAME)
25
26 ===== BEGIN TEST =====
27 ========
28 SELECT CHANNEL_NAME, WORKER_ID, THREAD_ID FROM performance_schema.replication_applier_status_by_worker WHERE CHANNEL_NAME is null
29
30 OK: Handler_read_key
31
32 OK: Result set: Empty Expected: Empty
33
34 OK: Extra rows: 0 Missing rows: 0
35 ========
36 SELECT CHANNEL_NAME, WORKER_ID, THREAD_ID FROM performance_schema.replication_applier_status_by_worker WHERE CHANNEL_NAME is not null
37
38 OK: Handler_read_key
39
40 OK: Result set: Non-empty Expected: Non-empty
41
42 OK: Extra rows: 0 Missing rows: 0
43 ========
44 SELECT CHANNEL_NAME, WORKER_ID, THREAD_ID FROM performance_schema.replication_applier_status_by_worker WHERE CHANNEL_NAME = ''
45
46 OK: Handler_read_key
47
48 OK: Result set: Non-empty Expected: Non-empty
49
50 OK: Extra rows: 0 Missing rows: 0
51 ========
52 SELECT CHANNEL_NAME, WORKER_ID, THREAD_ID FROM performance_schema.replication_applier_status_by_worker WHERE CHANNEL_NAME != ''
53
54 OK: Handler_read_key
55
56 OK: Result set: Empty Expected: Empty
57
58 OK: Extra rows: 0 Missing rows: 0
59 ========
60 SELECT CHANNEL_NAME, WORKER_ID, THREAD_ID FROM performance_schema.replication_applier_status_by_worker WHERE CHANNEL_NAME = 'impossible'
61
62 OK: Handler_read_key
63
64 OK: Result set: Empty Expected: Empty
65
66 OK: Extra rows: 0 Missing rows: 0
67 ========
68 SELECT CHANNEL_NAME, WORKER_ID, THREAD_ID FROM performance_schema.replication_applier_status_by_worker WHERE CHANNEL_NAME != 'impossible' ORDER BY CHANNEL_NAME DESC
69
70 OK: Handler_read_key
71
72 OK: Result set: Non-empty Expected: Non-empty
73
74 OK: Extra rows: 0 Missing rows: 0
75 ========
76 SELECT CHANNEL_NAME, WORKER_ID, THREAD_ID FROM performance_schema.replication_applier_status_by_worker WHERE CHANNEL_NAME = '' AND WORKER_ID is null
77
78 OK: Handler_read_key
79
80 OK: Result set: Empty Expected: Empty
81
82 OK: Extra rows: 0 Missing rows: 0
83 ========
84 SELECT CHANNEL_NAME, WORKER_ID, THREAD_ID FROM performance_schema.replication_applier_status_by_worker WHERE CHANNEL_NAME = '' AND WORKER_ID is not null
85
86 OK: Handler_read_key
87
88 OK: Result set: Non-empty Expected: Non-empty
89
90 OK: Extra rows: 0 Missing rows: 0
91 ========
92 SELECT CHANNEL_NAME, WORKER_ID, THREAD_ID FROM performance_schema.replication_applier_status_by_worker WHERE CHANNEL_NAME = '' AND WORKER_ID = 4
93
94 OK: Handler_read_key
95
96 OK: Result set: Non-empty Expected: Non-empty
97
98 OK: Extra rows: 0 Missing rows: 0
99 ========
100 SELECT CHANNEL_NAME, WORKER_ID, THREAD_ID FROM performance_schema.replication_applier_status_by_worker WHERE CHANNEL_NAME = '' AND WORKER_ID != 4
101
102 OK: Handler_read_key
103
104 OK: Result set: Non-empty Expected: Non-empty
105
106 OK: Extra rows: 0 Missing rows: 0
107 ========
108 SELECT CHANNEL_NAME, WORKER_ID, THREAD_ID FROM performance_schema.replication_applier_status_by_worker WHERE CHANNEL_NAME = '' AND WORKER_ID = 9999
109
110 OK: Handler_read_key
111
112 OK: Result set: Empty Expected: Empty
113
114 OK: Extra rows: 0 Missing rows: 0
115 SET @target_id = @worker_thread_id;
116 TABLE: "replication_applier_status_by_worker"
117 INDEXES: THREAD_ID
118
119 ===== BEGIN TEST =====
120 ========
121 SELECT CHANNEL_NAME, WORKER_ID, THREAD_ID FROM performance_schema.replication_applier_status_by_worker WHERE THREAD_ID is null
122
123 OK: Handler_read_key
124
125 OK: Result set: Empty Expected: Empty
126
127 OK: Extra rows: 0 Missing rows: 0
128 ========
129 SELECT CHANNEL_NAME, WORKER_ID, THREAD_ID FROM performance_schema.replication_applier_status_by_worker WHERE THREAD_ID is not null
130
131 OK: Handler_read_key
132
133 OK: Result set: Non-empty Expected: Non-empty
134
135 OK: Extra rows: 0 Missing rows: 0
136 ========
137 SELECT CHANNEL_NAME, WORKER_ID, THREAD_ID FROM performance_schema.replication_applier_status_by_worker WHERE THREAD_ID = @target_id
138
139 OK: Handler_read_key
140
141 OK: Result set: Non-empty Expected: Non-empty
142
143 OK: Extra rows: 0 Missing rows: 0
144 ========
145 SELECT CHANNEL_NAME, WORKER_ID, THREAD_ID FROM performance_schema.replication_applier_status_by_worker WHERE THREAD_ID = @target_id ORDER BY THREAD_ID
146
147 OK: Handler_read_key
148
149 OK: Result set: Non-empty Expected: Non-empty
150
151 OK: Extra rows: 0 Missing rows: 0
152 ========
153 SELECT CHANNEL_NAME, WORKER_ID, THREAD_ID FROM performance_schema.replication_applier_status_by_worker WHERE THREAD_ID = @target_id ORDER BY THREAD_ID DESC
154
155 OK: Handler_read_key
156
157 OK: Result set: Non-empty Expected: Non-empty
158
159 OK: Extra rows: 0 Missing rows: 0
160 ========
161 SELECT CHANNEL_NAME, WORKER_ID, THREAD_ID FROM performance_schema.replication_applier_status_by_worker WHERE THREAD_ID = 9999999 ORDER BY THREAD_ID
162
163 OK: Handler_read_key
164
165 OK: Result set: Empty Expected: Empty
166
167 OK: Extra rows: 0 Missing rows: 0
168
169 ===== CLEAN UP =====
170 DROP PROCEDURE index_test;
171 DROP TABLE IF EXISTS test.indexes_off;
172 DROP TABLE IF EXISTS test.indexes_on;
173 include/stop_slave.inc
174 SET GLOBAL replica_parallel_workers= @old_replica_parallel_workers;
175 include/start_slave.inc
176 include/rpl_end.inc