Debian Codegraph @

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

raw
1 select OBJECT_INSTANCE_BEGIN from performance_schema.file_summary_by_instance limit 1
2 into @oib;
3 select FILE_NAME from performance_schema.file_summary_by_instance limit 1
4 into @fname;
5 select EVENT_NAME from performance_schema.file_summary_by_instance limit 1
6 into @ename;
7
8 ====================================================================
9 Testing index for columns OBJECT_INSTANCE_BEGIN
10 ====================================================================
11 ############ Explain for Query ####################################
12 explain select COUNT(*)
13 from performance_schema.file_summary_by_instance
14 where OBJECT_INSTANCE_BEGIN = "impossible";
15 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
16 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
17 ############ Explain for Query ####################################
18 explain select COUNT(*)
19 from performance_schema.file_summary_by_instance
20 where OBJECT_INSTANCE_BEGIN > "impossible";
21 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
22 1 SIMPLE file_summary_by_instance NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
23 ############ Explain for Query ####################################
24 explain select COUNT(*)
25 from performance_schema.file_summary_by_instance
26 where OBJECT_INSTANCE_BEGIN < "2";
27 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
28 1 SIMPLE file_summary_by_instance NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
29 ############ Explain for Query ####################################
30 explain select COUNT(*)
31 from performance_schema.file_summary_by_instance
32 where OBJECT_INSTANCE_BEGIN = @oib;
33 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
34 1 SIMPLE file_summary_by_instance NULL const PRIMARY PRIMARY 8 const # 100.00 NULL
35 ############# Explain End #########################################
36 flush status;
37 select COUNT(*)
38 from performance_schema.file_summary_by_instance
39 where OBJECT_INSTANCE_BEGIN = @oib;
40 COUNT(*)
41 #
42 OK: handler_read_key incremented
43
44 ====================================================================
45 Testing index for columns FILE_NAME
46 ====================================================================
47 ############ Explain for Query ####################################
48 explain select COUNT(*)
49 from performance_schema.file_summary_by_instance
50 where FILE_NAME = "impossible";
51 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
52 1 SIMPLE file_summary_by_instance NULL ref FILE_NAME FILE_NAME 2050 const # 100.00 NULL
53 ############ Explain for Query ####################################
54 explain select COUNT(*)
55 from performance_schema.file_summary_by_instance
56 where FILE_NAME > "impossible";
57 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
58 1 SIMPLE file_summary_by_instance NULL ALL FILE_NAME NULL NULL NULL # 33.33 Using where
59 ############ Explain for Query ####################################
60 explain select COUNT(*)
61 from performance_schema.file_summary_by_instance
62 where FILE_NAME < "2";
63 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
64 1 SIMPLE file_summary_by_instance NULL ALL FILE_NAME NULL NULL NULL # 33.33 Using where
65 ############ Explain for Query ####################################
66 explain select COUNT(*)
67 from performance_schema.file_summary_by_instance
68 where FILE_NAME = @fname;
69 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
70 1 SIMPLE file_summary_by_instance NULL ref FILE_NAME FILE_NAME 2050 const # 100.00 NULL
71 ############# Explain End #########################################
72 flush status;
73 select COUNT(*)
74 from performance_schema.file_summary_by_instance
75 where FILE_NAME = @fname;
76 COUNT(*)
77 #
78 OK: handler_read_key incremented
79
80 ====================================================================
81 Testing index for columns EVENT_NAME
82 ====================================================================
83 ############ Explain for Query ####################################
84 explain select COUNT(*)
85 from performance_schema.file_summary_by_instance
86 where EVENT_NAME = "impossible";
87 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
88 1 SIMPLE file_summary_by_instance NULL ref EVENT_NAME EVENT_NAME 514 const # 100.00 NULL
89 ############ Explain for Query ####################################
90 explain select COUNT(*)
91 from performance_schema.file_summary_by_instance
92 where EVENT_NAME > "impossible";
93 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
94 1 SIMPLE file_summary_by_instance NULL ALL EVENT_NAME NULL NULL NULL # 33.33 Using where
95 ############ Explain for Query ####################################
96 explain select COUNT(*)
97 from performance_schema.file_summary_by_instance
98 where EVENT_NAME < "2";
99 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
100 1 SIMPLE file_summary_by_instance NULL ALL EVENT_NAME NULL NULL NULL # 33.33 Using where
101 ############ Explain for Query ####################################
102 explain select COUNT(*)
103 from performance_schema.file_summary_by_instance
104 where EVENT_NAME = @ename;
105 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
106 1 SIMPLE file_summary_by_instance NULL ref EVENT_NAME EVENT_NAME 514 const # 100.00 NULL
107 ############# Explain End #########################################
108 flush status;
109 select COUNT(*)
110 from performance_schema.file_summary_by_instance
111 where EVENT_NAME = @ename;
112 COUNT(*)
113 #
114 OK: handler_read_key incremented