1 |
SIMPLE |
cat |
|
index |
PRIMARY |
name |
194 |
|
1 |
100 |
Using index; Using temporary; Using filesort |
1 |
SIMPLE |
cat |
|
index |
PRIMARY |
name |
194 |
|
1 |
100 |
Using index; Using join buffer (hash join) |
1 |
SIMPLE |
sch |
|
eq_ref |
PRIMARY, catalog_id |
catalog_id |
202 |
mysql.cat.id, const |
1 |
100 |
Using index |
1 |
SIMPLE |
sch |
|
eq_ref |
PRIMARY, catalog_id |
catalog_id |
202 |
mysql.cat.id, const |
1 |
100 |
Using index |
1 |
SIMPLE |
tbl |
|
eq_ref |
PRIMARY, schema_id |
schema_id |
202 |
mysql.sch.id, const |
1 |
100 |
Using where |
1 |
SIMPLE |
tbl |
|
eq_ref |
schema_id, type, type_2 |
schema_id |
202 |
mysql.sch.id, const |
1 |
50.13 |
Using where |
1 |
SIMPLE |
col |
|
eq_ref |
PRIMARY |
PRIMARY |
8 |
mysql.tbl.collation_id |
1 |
100 |
Using index |
1 |
SIMPLE |
ts |
|
eq_ref |
PRIMARY |
PRIMARY |
8 |
mysql.tbl.tablespace_id |
1 |
100 |
Using index |
1 |
SIMPLE |
stat |
|
const |
PRIMARY |
PRIMARY |
388 |
const, const |
1 |
100 |
Using index |
1 |
SIMPLE |
col |
|
ref |
table_id, table_id_2, collation_id |
table_id |
8 |
mysql.tbl.id |
10 |
100 |
Using where |
1 |
SIMPLE |
coll |
|
eq_ref |
PRIMARY, character_set_id |
PRIMARY |
8 |
mysql.col.collation_id |
1 |
100 |
|
1 |
SIMPLE |
cs |
|
eq_ref |
PRIMARY |
PRIMARY |
8 |
mysql.coll.character_set_id |
1 |
100 |
|