SELECT * FROM `x$schema_index_statistics`
|
table_schema | table_name | index_name | rows_selected | select_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency | |
---|---|---|---|---|---|---|---|---|---|---|---|
sakila | film_category | PRIMARY | 165000 | 151535617200 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | PRIMARY | 154076 | 91532516592 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film_actor | PRIMARY | 165200 | 38630925696 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | category | PRIMARY | 5135 | 4249577376 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | PRIMARY | 674 | 881054592 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film_actor | idx_fk_film_id | 1 | 846324336 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | inventory | idx_fk_film_id | 2 | 764997552 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | actor | idx_actor_last_name | 3 | 462044352 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | PRIMARY | 601 | 455440656 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | staff | idx_fk_store_id | 1 | 423791280 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | language | PRIMARY | 50 | 298926672 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | country | PRIMARY | 576 | 253451088 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | idx_fk_language_id | 6 | 140259504 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | idx_fk_city_id | 6 | 128310864 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | idx_fk_address_id | 600 | 110075856 | 0 | 0 | 0 | 0 | 0 | 0 | |
world | Country | PRIMARY | 2 | 61837248 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | store | idx_unique_manager | 2 | 56472768 | 0 | 0 | 0 | 0 | 0 | 0 | |
test19 | voiture | Id_ecurie | 1 | 43025136 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | actor | PRIMARY | 1 | 12684144 | 0 | 0 | 0 | 0 | 0 | 0 | |
Table_insertion | ecurie | PRIMARY | 1 | 12196800 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | columns | PRIMARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | columns | table_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
performance_schema | table_io_waits_summary_by_index_usage | OBJECT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | tablespaces | PRIMARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | foreign_keys | referenced_table_catalog | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|