SELECT * FROM `x$schema_table_statistics`
|
table_schema | table_name | total_latency | rows_fetched | fetch_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency | io_read_requests | io_read | io_read_latency | io_write_requests | io_write | io_write_latency | io_misc_requests | io_misc_latency | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sakila | inventory | 4748472432 | 28 | 4748472432 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 5904867408 | 0 | 0 | 0 | 5 | 36132096 | |
sakila | city | 4660170768 | 128 | 4660170768 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4275929328 | 0 | 0 | 0 | 5 | 36612576 | |
sakila | actor | 4068664512 | 28 | 4068664512 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4225636272 | 0 | 0 | 0 | 5 | 40257360 | |
sakila | country | 2974677552 | 153 | 2974677552 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2474387520 | 0 | 0 | 0 | 5 | 43504560 | |
sakila | address | 2425952496 | 1868 | 2425952496 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1704789504 | 0 | 0 | 0 | 5 | 40170240 | |
Table_insertion | voiture | 2219482320 | 2 | 2219482320 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2495638992 | 0 | 0 | 0 | 5 | 37193904 | |
sakila | film | 2165247216 | 1129 | 2165247216 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1786415136 | 0 | 0 | 0 | 5 | 47116608 | |
sakila | staff | 1971146496 | 3 | 1971146496 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1994109744 | 0 | 0 | 0 | 5 | 35799456 | |
sakila | language | 1328443776 | 100 | 1328443776 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 798269472 | 0 | 0 | 0 | 5 | 40672368 | |
vedettfak | fa | 1182195168 | 3 | 1182195168 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1269224352 | 0 | 0 | 0 | 5 | 40541424 | |
sys | sys_config | 526701120 | 2 | 526701120 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 791042208 | 0 | 0 | 0 | 5 | 56633280 | |
pw | usuario | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1499912832 | 0 | 0 | 0 | 5 | 507564288 | |
pw | estudio | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 740750736 | 0 | 0 | 0 | 5 | 39308016 | |
performance_schema | events_transactions_current | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | session_connect_attrs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
аа | Поставщик | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | global_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | memory_summary_by_thread_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | session_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_stages_current | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_waits_current | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | threads | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_statements_current | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | table_io_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|