Debian Codegraph @

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

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