Debian Codegraph @

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

raw
1 SELECT logged INTO @startup
2 FROM performance_schema.error_log
3 WHERE error_code="MY-010116" ORDER BY logged DESC LIMIT 1;
4
5 ====================================================================
6 Testing index for columns LOGGED
7 ====================================================================
8 ############ Explain for Query ####################################
9 EXPLAIN SELECT ERROR_CODE
10 FROM performance_schema.error_log
11 WHERE LOGGED = @startup;
12 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
13 1 SIMPLE error_log NULL const PRIMARY PRIMARY 7 const # 100.00 NULL
14 ############ Explain for Query ####################################
15 EXPLAIN SELECT ERROR_CODE
16 FROM performance_schema.error_log
17 WHERE LOGGED > @startup;
18 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
19 1 SIMPLE error_log NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
20 ############ Explain for Query ####################################
21 EXPLAIN SELECT ERROR_CODE
22 FROM performance_schema.error_log
23 WHERE LOGGED < @startup;
24 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
25 1 SIMPLE error_log NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
26 ############ Explain for Query ####################################
27 EXPLAIN SELECT ERROR_CODE
28 FROM performance_schema.error_log
29 WHERE LOGGED != @startup;
30 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
31 1 SIMPLE error_log NULL ALL PRIMARY NULL NULL NULL # 90.00 Using where
32 ############# Explain End #########################################
33
34 ====================================================================
35 Testing index for columns THREAD_ID
36 ====================================================================
37 ############ Explain for Query ####################################
38 EXPLAIN SELECT ERROR_CODE
39 FROM performance_schema.error_log
40 WHERE THREAD_ID = "0";
41 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
42 1 SIMPLE error_log NULL ref THREAD_ID THREAD_ID 9 const # 100.00 Using where
43 ############ Explain for Query ####################################
44 EXPLAIN SELECT ERROR_CODE
45 FROM performance_schema.error_log
46 WHERE THREAD_ID > "0";
47 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
48 1 SIMPLE error_log NULL ALL THREAD_ID NULL NULL NULL # 33.33 Using where
49 ############ Explain for Query ####################################
50 EXPLAIN SELECT ERROR_CODE
51 FROM performance_schema.error_log
52 WHERE THREAD_ID < "0";
53 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
54 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL Impossible WHERE
55 ############ Explain for Query ####################################
56 EXPLAIN SELECT ERROR_CODE
57 FROM performance_schema.error_log
58 WHERE THREAD_ID != "0";
59 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
60 1 SIMPLE error_log NULL ALL THREAD_ID NULL NULL NULL # 90.00 Using where
61 ############# Explain End #########################################
62
63 ====================================================================
64 Testing index for columns PRIO
65 ====================================================================
66 ############ Explain for Query ####################################
67 EXPLAIN SELECT ERROR_CODE
68 FROM performance_schema.error_log
69 WHERE PRIO = "System";
70 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
71 1 SIMPLE error_log NULL ref PRIO PRIO 1 const # 100.00 Using where
72 ############ Explain for Query ####################################
73 EXPLAIN SELECT ERROR_CODE
74 FROM performance_schema.error_log
75 WHERE PRIO > "System";
76 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
77 1 SIMPLE error_log NULL ALL PRIO NULL NULL NULL # 33.33 Using where
78 ############ Explain for Query ####################################
79 EXPLAIN SELECT ERROR_CODE
80 FROM performance_schema.error_log
81 WHERE PRIO < "System";
82 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
83 1 SIMPLE error_log NULL ALL PRIO NULL NULL NULL # 33.33 Using where
84 ############ Explain for Query ####################################
85 EXPLAIN SELECT ERROR_CODE
86 FROM performance_schema.error_log
87 WHERE PRIO != "System";
88 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
89 1 SIMPLE error_log NULL ALL PRIO NULL NULL NULL # 75.00 Using where
90 ############# Explain End #########################################
91
92 ====================================================================
93 Testing index for columns ERROR_CODE
94 ====================================================================
95 ############ Explain for Query ####################################
96 EXPLAIN SELECT ERROR_CODE
97 FROM performance_schema.error_log
98 WHERE ERROR_CODE = "MY-010116";
99 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
100 1 SIMPLE error_log NULL ref ERROR_CODE ERROR_CODE 43 const # 100.00 NULL
101 ############ Explain for Query ####################################
102 EXPLAIN SELECT ERROR_CODE
103 FROM performance_schema.error_log
104 WHERE ERROR_CODE > "MY-010116";
105 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
106 1 SIMPLE error_log NULL ALL ERROR_CODE NULL NULL NULL # 33.33 Using where
107 ############ Explain for Query ####################################
108 EXPLAIN SELECT ERROR_CODE
109 FROM performance_schema.error_log
110 WHERE ERROR_CODE < "MY-010116";
111 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
112 1 SIMPLE error_log NULL ALL ERROR_CODE NULL NULL NULL # 33.33 Using where
113 ############ Explain for Query ####################################
114 EXPLAIN SELECT ERROR_CODE
115 FROM performance_schema.error_log
116 WHERE ERROR_CODE != "MY-010116";
117 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
118 1 SIMPLE error_log NULL ALL ERROR_CODE NULL NULL NULL # 90.00 Using where
119 ############# Explain End #########################################
120
121 ====================================================================
122 Testing index for columns SUBSYSTEM
123 ====================================================================
124 ############ Explain for Query ####################################
125 EXPLAIN SELECT ERROR_CODE
126 FROM performance_schema.error_log
127 WHERE SUBSYSTEM = "Server";
128 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
129 1 SIMPLE error_log NULL ref SUBSYSTEM SUBSYSTEM 31 const # 100.00 NULL
130 ############ Explain for Query ####################################
131 EXPLAIN SELECT ERROR_CODE
132 FROM performance_schema.error_log
133 WHERE SUBSYSTEM > "Server";
134 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
135 1 SIMPLE error_log NULL ALL SUBSYSTEM NULL NULL NULL # 33.33 Using where
136 ############ Explain for Query ####################################
137 EXPLAIN SELECT ERROR_CODE
138 FROM performance_schema.error_log
139 WHERE SUBSYSTEM < "Server";
140 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
141 1 SIMPLE error_log NULL ALL SUBSYSTEM NULL NULL NULL # 33.33 Using where
142 ############ Explain for Query ####################################
143 EXPLAIN SELECT ERROR_CODE
144 FROM performance_schema.error_log
145 WHERE SUBSYSTEM != "Server";
146 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
147 1 SIMPLE error_log NULL ALL SUBSYSTEM NULL NULL NULL # 90.00 Using where
148 ############# Explain End #########################################
149
150 #
151 # read key
152 #
153 FLUSH STATUS;
154 SELECT COUNT(ERROR_CODE) FROM performance_schema.error_log WHERE LOGGED = @startup;
155 OK: handler_read_key incremented