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 | city | 25643783616 | 136 | 25643783616 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 6349692096 | 0 | 0 | 0 | 5 | 91280112 | |
sakila | inventory | 5215002672 | 28 | 5215002672 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 6187486800 | 0 | 0 | 0 | 5 | 61324032 | |
sakila | address | 3382375920 | 156 | 3382375920 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2820819408 | 0 | 0 | 0 | 5 | 93194112 | |
sakila | language | 1839151776 | 50 | 1839151776 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1561410576 | 0 | 0 | 0 | 5 | 71253072 | |
sakila | film | 1429138128 | 77 | 1429138128 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1699846896 | 0 | 0 | 0 | 5 | 36713952 | |
sku | Attore | 1292781072 | 1 | 1292781072 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1023937728 | 0 | 0 | 0 | 5 | 39139056 | |
sakila | customer | 1260312240 | 52 | 1260312240 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 1910197344 | 0 | 0 | 0 | 5 | 41307024 | |
sakila | country | 836298144 | 35 | 836298144 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 836186736 | 0 | 0 | 0 | 5 | 50198544 | |
sys | sys_config | 680197056 | 1 | 680197056 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 894875520 | 0 | 0 | 0 | 5 | 50574480 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 606329328 | 5 | 606329328 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | film_text | 248381760 | 2 | 248381760 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 442 | 572853072 | 0 | 0 | 0 | 7 | 47703216 | |
mysql | help_keyword | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | mutex_instances | 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 | |
mysql | help_category | 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 | |
performance_schema | global_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_transactions_summary_by_user_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | routines | 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 | |
mysql | table_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | catalogs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | table_lock_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | column_statistics | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | log_status | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|