Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 include/stop_slave.inc
4 RESET SLAVE ALL;
5 SET @old_replica_parallel_workers= @@global.replica_parallel_workers;
6 SET GLOBAL replica_parallel_workers = 4;
7 include/start_slave.inc
8 include/sync_slave_sql_with_master.inc [FOR CHANNEL 'channel_1']
9 select CHANNEL_NAME, WORKER_ID, THREAD_ID
10 from performance_schema.replication_applier_status_by_worker
11 where WORKER_ID = 1
12 into @c_name, @w_id, @t_id;
13 select @c_name, @w_id, @t_id is not null;
14 @c_name @w_id @t_id is not null
15 channel_1 1 1
16
17 ====================================================================
18 Testing index for columns CHANNEL_NAME, WORKER_ID
19 ====================================================================
20 ############ Explain for Query ####################################
21 explain select SERVICE_STATE
22 from performance_schema.replication_applier_status_by_worker
23 where CHANNEL_NAME = "impossible";
24 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
25 1 SIMPLE replication_applier_status_by_worker NULL ref PRIMARY PRIMARY 256 const # 100.00 Using where
26 ############ Explain for Query ####################################
27 explain select SERVICE_STATE
28 from performance_schema.replication_applier_status_by_worker
29 where CHANNEL_NAME > "impossible";
30 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
31 1 SIMPLE replication_applier_status_by_worker NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
32 ############ Explain for Query ####################################
33 explain select SERVICE_STATE
34 from performance_schema.replication_applier_status_by_worker
35 where CHANNEL_NAME < "2";
36 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
37 1 SIMPLE replication_applier_status_by_worker NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
38 ############ Explain for Query ####################################
39 explain select SERVICE_STATE
40 from performance_schema.replication_applier_status_by_worker
41 where CHANNEL_NAME = @c_name;
42 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
43 1 SIMPLE replication_applier_status_by_worker NULL ref PRIMARY PRIMARY 256 const # 100.00 Using where
44 ############ Explain for Query ####################################
45 explain select SERVICE_STATE
46 from performance_schema.replication_applier_status_by_worker
47 where CHANNEL_NAME = "impossible"
48 and WORKER_ID = "impossible";
49 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
50 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
51 ############ Explain for Query ####################################
52 explain select SERVICE_STATE
53 from performance_schema.replication_applier_status_by_worker
54 where CHANNEL_NAME = @c_name
55 and WORKER_ID = "impossible";
56 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
57 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
58 ############ Explain for Query ####################################
59 explain select SERVICE_STATE
60 from performance_schema.replication_applier_status_by_worker
61 where CHANNEL_NAME = @c_name
62 and WORKER_ID > "impossible";
63 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
64 1 SIMPLE replication_applier_status_by_worker NULL ref PRIMARY PRIMARY 256 const # 33.33 Using where
65 ############ Explain for Query ####################################
66 explain select SERVICE_STATE
67 from performance_schema.replication_applier_status_by_worker
68 where CHANNEL_NAME = @c_name
69 and WORKER_ID < "2";
70 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
71 1 SIMPLE replication_applier_status_by_worker NULL ref PRIMARY PRIMARY 256 const # 33.33 Using where
72 ############ Explain for Query ####################################
73 explain select SERVICE_STATE
74 from performance_schema.replication_applier_status_by_worker
75 where CHANNEL_NAME = @c_name
76 and WORKER_ID = @w_id;
77 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
78 1 SIMPLE replication_applier_status_by_worker NULL const PRIMARY PRIMARY 264 const,const # 100.00 NULL
79 ############# Explain End #########################################
80 flush status;
81 select SERVICE_STATE
82 from performance_schema.replication_applier_status_by_worker
83 where CHANNEL_NAME = @c_name
84 and WORKER_ID = @w_id;
85 SERVICE_STATE
86 #
87 OK: handler_read_key incremented
88
89 ====================================================================
90 Testing index for columns THREAD_ID
91 ====================================================================
92 ############ Explain for Query ####################################
93 explain select SERVICE_STATE
94 from performance_schema.replication_applier_status_by_worker
95 where THREAD_ID = "impossible";
96 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
97 1 SIMPLE replication_applier_status_by_worker NULL ref THREAD_ID THREAD_ID 9 const # 100.00 Using where
98 ############ Explain for Query ####################################
99 explain select SERVICE_STATE
100 from performance_schema.replication_applier_status_by_worker
101 where THREAD_ID > "impossible";
102 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
103 1 SIMPLE replication_applier_status_by_worker NULL ALL THREAD_ID NULL NULL NULL # 33.33 Using where
104 ############ Explain for Query ####################################
105 explain select SERVICE_STATE
106 from performance_schema.replication_applier_status_by_worker
107 where THREAD_ID < "2";
108 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
109 1 SIMPLE replication_applier_status_by_worker NULL ALL THREAD_ID NULL NULL NULL # 33.33 Using where
110 ############ Explain for Query ####################################
111 explain select SERVICE_STATE
112 from performance_schema.replication_applier_status_by_worker
113 where THREAD_ID = @t_id;
114 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
115 1 SIMPLE replication_applier_status_by_worker NULL ref THREAD_ID THREAD_ID 9 const # 100.00 NULL
116 ############# Explain End #########################################
117 flush status;
118 select SERVICE_STATE
119 from performance_schema.replication_applier_status_by_worker
120 where THREAD_ID = @t_id;
121 SERVICE_STATE
122 #
123 OK: handler_read_key incremented
124 include/stop_slave.inc [FOR CHANNEL 'channel_1']
125 RESET SLAVE ALL;
126 Warnings:
127 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
128 SET GLOBAL replica_parallel_workers= @old_replica_parallel_workers;
129 include/start_slave.inc
130 include/rpl_end.inc