Debian Codegraph @

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

raw
1 create database explain_test_db;
2 create table explain_test_db.explain_test_table(a int, b int, PRIMARY KEY(a));
3 truncate table performance_schema.table_io_waits_summary_by_index_usage;
4 insert into explain_test_db.explain_test_table values('1', '2');
5 select * from explain_test_db.explain_test_table where a='1';
6 a b
7 1 2
8
9 ====================================================================
10 Testing index for columns OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
11 ====================================================================
12 ############ Explain for Query ####################################
13 explain select COUNT_STAR
14 from performance_schema.table_io_waits_summary_by_index_usage
15 where OBJECT_TYPE = "impossible";
16 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
17 1 SIMPLE table_io_waits_summary_by_index_usage NULL ref OBJECT OBJECT 259 const # 100.00 NULL
18 ############ Explain for Query ####################################
19 explain select COUNT_STAR
20 from performance_schema.table_io_waits_summary_by_index_usage
21 where OBJECT_TYPE > "impossible";
22 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
23 1 SIMPLE table_io_waits_summary_by_index_usage NULL ALL OBJECT NULL NULL NULL # 33.33 Using where
24 ############ Explain for Query ####################################
25 explain select COUNT_STAR
26 from performance_schema.table_io_waits_summary_by_index_usage
27 where OBJECT_TYPE < "2";
28 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
29 1 SIMPLE table_io_waits_summary_by_index_usage NULL ALL OBJECT NULL NULL NULL # 33.33 Using where
30 ############ Explain for Query ####################################
31 explain select COUNT_STAR
32 from performance_schema.table_io_waits_summary_by_index_usage
33 where OBJECT_TYPE = "TABLE";
34 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
35 1 SIMPLE table_io_waits_summary_by_index_usage NULL ref OBJECT OBJECT 259 const # 100.00 NULL
36 ############ Explain for Query ####################################
37 explain select COUNT_STAR
38 from performance_schema.table_io_waits_summary_by_index_usage
39 where OBJECT_TYPE = "impossible"
40 and OBJECT_SCHEMA = "impossible";
41 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
42 1 SIMPLE table_io_waits_summary_by_index_usage NULL ref OBJECT OBJECT 518 const,const # 100.00 NULL
43 ############ Explain for Query ####################################
44 explain select COUNT_STAR
45 from performance_schema.table_io_waits_summary_by_index_usage
46 where OBJECT_TYPE = "TABLE"
47 and OBJECT_SCHEMA = "impossible";
48 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
49 1 SIMPLE table_io_waits_summary_by_index_usage NULL ref OBJECT OBJECT 518 const,const # 100.00 NULL
50 ############ Explain for Query ####################################
51 explain select COUNT_STAR
52 from performance_schema.table_io_waits_summary_by_index_usage
53 where OBJECT_TYPE = "TABLE"
54 and OBJECT_SCHEMA > "impossible";
55 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
56 1 SIMPLE table_io_waits_summary_by_index_usage NULL ref OBJECT OBJECT 259 const # 33.33 Using where
57 ############ Explain for Query ####################################
58 explain select COUNT_STAR
59 from performance_schema.table_io_waits_summary_by_index_usage
60 where OBJECT_TYPE = "TABLE"
61 and OBJECT_SCHEMA < "2";
62 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
63 1 SIMPLE table_io_waits_summary_by_index_usage NULL ref OBJECT OBJECT 259 const # 33.33 Using where
64 ############ Explain for Query ####################################
65 explain select COUNT_STAR
66 from performance_schema.table_io_waits_summary_by_index_usage
67 where OBJECT_TYPE = "TABLE"
68 and OBJECT_SCHEMA = "explain_test_db";
69 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
70 1 SIMPLE table_io_waits_summary_by_index_usage NULL ref OBJECT OBJECT 518 const,const # 100.00 NULL
71 ############ Explain for Query ####################################
72 explain select COUNT_STAR
73 from performance_schema.table_io_waits_summary_by_index_usage
74 where OBJECT_TYPE = "impossible"
75 and OBJECT_SCHEMA = "impossible"
76 and OBJECT_NAME = "impossible";
77 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
78 1 SIMPLE table_io_waits_summary_by_index_usage NULL ref OBJECT OBJECT 777 const,const,const # 100.00 NULL
79 ############ Explain for Query ####################################
80 explain select COUNT_STAR
81 from performance_schema.table_io_waits_summary_by_index_usage
82 where OBJECT_TYPE = "TABLE"
83 and OBJECT_SCHEMA = "explain_test_db"
84 and OBJECT_NAME = "impossible";
85 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
86 1 SIMPLE table_io_waits_summary_by_index_usage NULL ref OBJECT OBJECT 777 const,const,const # 100.00 NULL
87 ############ Explain for Query ####################################
88 explain select COUNT_STAR
89 from performance_schema.table_io_waits_summary_by_index_usage
90 where OBJECT_TYPE = "TABLE"
91 and OBJECT_SCHEMA = "explain_test_db"
92 and OBJECT_NAME > "impossible";
93 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
94 1 SIMPLE table_io_waits_summary_by_index_usage NULL ref OBJECT OBJECT 518 const,const # 33.33 Using where
95 ############ Explain for Query ####################################
96 explain select COUNT_STAR
97 from performance_schema.table_io_waits_summary_by_index_usage
98 where OBJECT_TYPE = "TABLE"
99 and OBJECT_SCHEMA = "explain_test_db"
100 and OBJECT_NAME < "2";
101 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
102 1 SIMPLE table_io_waits_summary_by_index_usage NULL ref OBJECT OBJECT 518 const,const # 33.33 Using where
103 ############ Explain for Query ####################################
104 explain select COUNT_STAR
105 from performance_schema.table_io_waits_summary_by_index_usage
106 where OBJECT_TYPE = "TABLE"
107 and OBJECT_SCHEMA = "explain_test_db"
108 and OBJECT_NAME = "explain_test_table";
109 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
110 1 SIMPLE table_io_waits_summary_by_index_usage NULL ref OBJECT OBJECT 777 const,const,const # 100.00 NULL
111 ############ Explain for Query ####################################
112 explain select COUNT_STAR
113 from performance_schema.table_io_waits_summary_by_index_usage
114 where OBJECT_TYPE = "impossible"
115 and OBJECT_SCHEMA = "impossible"
116 and OBJECT_NAME = "impossible"
117 and INDEX_NAME = "impossible";
118 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
119 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
120 ############ Explain for Query ####################################
121 explain select COUNT_STAR
122 from performance_schema.table_io_waits_summary_by_index_usage
123 where OBJECT_TYPE = "TABLE"
124 and OBJECT_SCHEMA = "explain_test_db"
125 and OBJECT_NAME = "explain_test_table"
126 and INDEX_NAME = "impossible";
127 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
128 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
129 ############ Explain for Query ####################################
130 explain select COUNT_STAR
131 from performance_schema.table_io_waits_summary_by_index_usage
132 where OBJECT_TYPE = "TABLE"
133 and OBJECT_SCHEMA = "explain_test_db"
134 and OBJECT_NAME = "explain_test_table"
135 and INDEX_NAME > "impossible";
136 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
137 1 SIMPLE table_io_waits_summary_by_index_usage NULL ref OBJECT OBJECT 777 const,const,const # 33.33 Using where
138 ############ Explain for Query ####################################
139 explain select COUNT_STAR
140 from performance_schema.table_io_waits_summary_by_index_usage
141 where OBJECT_TYPE = "TABLE"
142 and OBJECT_SCHEMA = "explain_test_db"
143 and OBJECT_NAME = "explain_test_table"
144 and INDEX_NAME < "impossible";
145 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
146 1 SIMPLE table_io_waits_summary_by_index_usage NULL ref OBJECT OBJECT 777 const,const,const # 33.33 Using where
147 ############ Explain for Query ####################################
148 explain select COUNT_STAR
149 from performance_schema.table_io_waits_summary_by_index_usage
150 where OBJECT_TYPE = "TABLE"
151 and OBJECT_SCHEMA = "explain_test_db"
152 and OBJECT_NAME = "explain_test_table"
153 and INDEX_NAME = "PRIMARY";
154 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
155 1 SIMPLE table_io_waits_summary_by_index_usage NULL const OBJECT OBJECT 1036 const,const,const,const # 100.00 NULL
156 ############# Explain End #########################################
157 flush status;
158 select COUNT_STAR
159 from performance_schema.table_io_waits_summary_by_index_usage
160 where OBJECT_TYPE = "TABLE"
161 and OBJECT_SCHEMA = "explain_test_db"
162 and OBJECT_NAME = "explain_test_table"
163 and INDEX_NAME = "PRIMARY";
164 COUNT_STAR
165 #
166 OK: handler_read_key incremented
167 drop table explain_test_db.explain_test_table;
168 drop database explain_test_db;