SELECT * FROM `schema_unused_indexes`
|
object_schema | object_name | index_name | |
---|---|---|---|
ParkVerleihDB | Fahrzeuge | StandortID | |
ParkVerleihDB | VerleihVorgänge | FahrzeugID | |
ParkVerleihDB | VerleihVorgänge | KundenID | |
performance_schema | data_lock_waits | BLOCKING_THREAD_ID | |
performance_schema | data_lock_waits | BLOCKING_ENGINE_LOCK_ID | |
performance_schema | data_lock_waits | REQUESTING_THREAD_ID | |
performance_schema | data_lock_waits | REQUESTING_ENGINE_TRANSACTION_ID | |
performance_schema | data_lock_waits | BLOCKING_ENGINE_TRANSACTION_ID | |
performance_schema | data_lock_waits | REQUESTING_ENGINE_LOCK_ID | |
performance_schema | data_locks | OBJECT_SCHEMA | |
performance_schema | data_locks | THREAD_ID | |
performance_schema | data_locks | ENGINE_TRANSACTION_ID | |
performance_schema | file_summary_by_instance | EVENT_NAME | |
performance_schema | file_summary_by_instance | FILE_NAME | |
performance_schema | threads | RESOURCE_GROUP | |
performance_schema | threads | THREAD_OS_ID | |
performance_schema | threads | PROCESSLIST_ID | |
performance_schema | threads | PROCESSLIST_ACCOUNT | |
performance_schema | threads | PROCESSLIST_HOST | |
performance_schema | threads | NAME | |
sakila | actor | idx_actor_last_name | |
sakila | address | idx_fk_city_id | |
sakila | city | idx_fk_country_id | |
sakila | customer | idx_last_name | |
sakila | customer | idx_fk_address_id |
|