SELECT * FROM `schema_unused_indexes`
|
object_schema | object_name | index_name | |
---|---|---|---|
performance_schema | cond_instances | NAME | |
performance_schema | data_lock_waits | BLOCKING_THREAD_ID | |
performance_schema | data_lock_waits | REQUESTING_THREAD_ID | |
performance_schema | data_lock_waits | REQUESTING_ENGINE_LOCK_ID | |
performance_schema | data_lock_waits | BLOCKING_ENGINE_LOCK_ID | |
performance_schema | data_lock_waits | REQUESTING_ENGINE_TRANSACTION_ID | |
performance_schema | data_lock_waits | BLOCKING_ENGINE_TRANSACTION_ID | |
performance_schema | data_locks | OBJECT_SCHEMA | |
performance_schema | data_locks | THREAD_ID | |
performance_schema | data_locks | ENGINE_TRANSACTION_ID | |
performance_schema | events_waits_summary_by_instance | EVENT_NAME | |
performance_schema | file_instances | EVENT_NAME | |
performance_schema | file_summary_by_instance | FILE_NAME | |
performance_schema | file_summary_by_instance | EVENT_NAME | |
performance_schema | host_cache | HOST | |
performance_schema | metadata_locks | OWNER_THREAD_ID | |
performance_schema | metadata_locks | OBJECT_TYPE | |
performance_schema | mutex_instances | LOCKED_BY_THREAD_ID | |
performance_schema | mutex_instances | NAME | |
performance_schema | prepared_statements_instances | STATEMENT_ID | |
performance_schema | prepared_statements_instances | OWNER_OBJECT_TYPE | |
performance_schema | prepared_statements_instances | STATEMENT_NAME | |
performance_schema | replication_applier_status_by_coordinator | THREAD_ID | |
performance_schema | replication_applier_status_by_worker | THREAD_ID | |
performance_schema | replication_connection_status | THREAD_ID |
|