| 1 |
# Tests for PERFORMANCE_SCHEMA |
| 2 |
# Show existing objects and information about their structure |
| 3 |
|
| 4 |
# List of indexes |
| 5 |
select TABLE_NAME, NON_UNIQUE, INDEX_SCHEMA, INDEX_NAME, INDEX_TYPE, INDEX_COMMENT |
| 6 |
from INFORMATION_SCHEMA.STATISTICS |
| 7 |
where TABLE_SCHEMA = "performance_schema" and SEQ_IN_INDEX = 1 |
| 8 |
order by TABLE_NAME collate utf8_general_ci, INDEX_NAME; |
| 9 |
|
| 10 |
# List of index columns |
| 11 |
select TABLE_NAME, NON_UNIQUE, INDEX_SCHEMA, INDEX_NAME, SEQ_IN_INDEX, |
| 12 |
COLUMN_NAME, CARDINALITY, NULLABLE |
| 13 |
from INFORMATION_SCHEMA.STATISTICS |
| 14 |
where TABLE_SCHEMA = "performance_schema" |
| 15 |
order by TABLE_NAME collate utf8_general_ci, INDEX_NAME, SEQ_IN_INDEX; |