Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 include/stop_slave.inc
4 RESET SLAVE ALL;
5 include/start_slave.inc
6 select THREAD_ID from performance_schema.replication_connection_status
7 where CHANNEL_NAME = "channel_1"
8 into @tid;
9
10 ====================================================================
11 Testing index for columns CHANNEL_NAME
12 ====================================================================
13 ############ Explain for Query ####################################
14 explain select SERVICE_STATE
15 from performance_schema.replication_connection_status
16 where CHANNEL_NAME = "impossible";
17 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
18 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
19 ############ Explain for Query ####################################
20 explain select SERVICE_STATE
21 from performance_schema.replication_connection_status
22 where CHANNEL_NAME > "impossible";
23 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
24 1 SIMPLE replication_connection_status NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
25 ############ Explain for Query ####################################
26 explain select SERVICE_STATE
27 from performance_schema.replication_connection_status
28 where CHANNEL_NAME < "2";
29 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
30 1 SIMPLE replication_connection_status NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
31 ############ Explain for Query ####################################
32 explain select SERVICE_STATE
33 from performance_schema.replication_connection_status
34 where CHANNEL_NAME = "channel_1";
35 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
36 1 SIMPLE replication_connection_status NULL const PRIMARY PRIMARY 256 const # 100.00 NULL
37 ############# Explain End #########################################
38 flush status;
39 select SERVICE_STATE
40 from performance_schema.replication_connection_status
41 where CHANNEL_NAME = "channel_1";
42 SERVICE_STATE
43 #
44 OK: handler_read_key incremented
45
46 ====================================================================
47 Testing index for columns THREAD_ID
48 ====================================================================
49 ############ Explain for Query ####################################
50 explain select SERVICE_STATE
51 from performance_schema.replication_connection_status
52 where THREAD_ID = "impossible";
53 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
54 1 SIMPLE replication_connection_status NULL ref THREAD_ID THREAD_ID 9 const # 100.00 Using where
55 ############ Explain for Query ####################################
56 explain select SERVICE_STATE
57 from performance_schema.replication_connection_status
58 where THREAD_ID > "impossible";
59 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
60 1 SIMPLE replication_connection_status NULL ALL THREAD_ID NULL NULL NULL # 33.33 Using where
61 ############ Explain for Query ####################################
62 explain select SERVICE_STATE
63 from performance_schema.replication_connection_status
64 where THREAD_ID < "2";
65 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
66 1 SIMPLE replication_connection_status NULL ALL THREAD_ID NULL NULL NULL # 33.33 Using where
67 ############ Explain for Query ####################################
68 explain select SERVICE_STATE
69 from performance_schema.replication_connection_status
70 where THREAD_ID = @tid;
71 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
72 1 SIMPLE replication_connection_status NULL ref THREAD_ID THREAD_ID 9 const # 100.00 NULL
73 ############# Explain End #########################################
74 flush status;
75 select SERVICE_STATE
76 from performance_schema.replication_connection_status
77 where THREAD_ID = @tid;
78 SERVICE_STATE
79 #
80 OK: handler_read_key incremented
81 include/stop_slave.inc
82 RESET SLAVE ALL;
83 Warnings:
84 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
85 include/start_slave.inc
86 include/rpl_end.inc