Debian Codegraph @

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

raw
1 select OBJECT_INSTANCE_BEGIN, NAME from performance_schema.cond_instances
2 limit 1
3 into @oib, @name;
4
5 ====================================================================
6 Testing index for columns OBJECT_INSTANCE_BEGIN
7 ====================================================================
8 ############ Explain for Query ####################################
9 explain select count(*)
10 from performance_schema.cond_instances
11 where OBJECT_INSTANCE_BEGIN = "impossible";
12 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
13 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
14 ############ Explain for Query ####################################
15 explain select count(*)
16 from performance_schema.cond_instances
17 where OBJECT_INSTANCE_BEGIN > "impossible";
18 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
19 1 SIMPLE cond_instances NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
20 ############ Explain for Query ####################################
21 explain select count(*)
22 from performance_schema.cond_instances
23 where OBJECT_INSTANCE_BEGIN < "2";
24 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
25 1 SIMPLE cond_instances NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
26 ############ Explain for Query ####################################
27 explain select count(*)
28 from performance_schema.cond_instances
29 where OBJECT_INSTANCE_BEGIN = @oib;
30 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
31 1 SIMPLE cond_instances NULL const PRIMARY PRIMARY 8 const # 100.00 NULL
32 ############# Explain End #########################################
33 flush status;
34 select count(*)
35 from performance_schema.cond_instances
36 where OBJECT_INSTANCE_BEGIN = @oib;
37 count(*)
38 #
39 OK: handler_read_key incremented
40
41 ====================================================================
42 Testing index for columns NAME
43 ====================================================================
44 ############ Explain for Query ####################################
45 explain select count(*)
46 from performance_schema.cond_instances
47 where NAME = "impossible";
48 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
49 1 SIMPLE cond_instances NULL ref NAME NAME 514 const # 100.00 NULL
50 ############ Explain for Query ####################################
51 explain select count(*)
52 from performance_schema.cond_instances
53 where NAME > "impossible";
54 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
55 1 SIMPLE cond_instances NULL ALL NAME NULL NULL NULL # 33.33 Using where
56 ############ Explain for Query ####################################
57 explain select count(*)
58 from performance_schema.cond_instances
59 where NAME < "2";
60 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
61 1 SIMPLE cond_instances NULL ALL NAME NULL NULL NULL # 33.33 Using where
62 ############ Explain for Query ####################################
63 explain select count(*)
64 from performance_schema.cond_instances
65 where NAME = @name;
66 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
67 1 SIMPLE cond_instances NULL ref NAME NAME 514 const # 100.00 NULL
68 ############# Explain End #########################################
69 flush status;
70 select count(*)
71 from performance_schema.cond_instances
72 where NAME = @name;
73 count(*)
74 #
75 OK: handler_read_key incremented