Debian Codegraph @

mysql-test/suite/perfschema/r/idx_replication_connection_configuration.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
7 ====================================================================
8 Testing index for columns CHANNEL_NAME
9 ====================================================================
10 ############ Explain for Query ####################################
11 explain select HOST
12 from performance_schema.replication_connection_configuration
13 where CHANNEL_NAME = "impossible";
14 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
15 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
16 ############ Explain for Query ####################################
17 explain select HOST
18 from performance_schema.replication_connection_configuration
19 where CHANNEL_NAME > "impossible";
20 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
21 1 SIMPLE replication_connection_configuration NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
22 ############ Explain for Query ####################################
23 explain select HOST
24 from performance_schema.replication_connection_configuration
25 where CHANNEL_NAME < "2";
26 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
27 1 SIMPLE replication_connection_configuration NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
28 ############ Explain for Query ####################################
29 explain select HOST
30 from performance_schema.replication_connection_configuration
31 where CHANNEL_NAME = "channel_1";
32 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
33 1 SIMPLE replication_connection_configuration NULL const PRIMARY PRIMARY 256 const # 100.00 NULL
34 ############# Explain End #########################################
35 flush status;
36 select HOST
37 from performance_schema.replication_connection_configuration
38 where CHANNEL_NAME = "channel_1";
39 HOST
40 #
41 OK: handler_read_key incremented
42 include/stop_slave.inc
43 RESET SLAVE ALL;
44 Warnings:
45 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
46 include/start_slave.inc
47 include/rpl_end.inc