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 | payment | 72418708560 | 32088 | 72418708560 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 1114112 | 13604206176 | 0 | 0 | 0 | 5 | 25620144 | |
sakila | rental | 19046706624 | 41250 | 19046706624 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 376832 | 5801505600 | 0 | 0 | 0 | 5 | 39524496 | |
sakila | film | 10649422608 | 1397 | 10649422608 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 9264179760 | 0 | 0 | 0 | 5 | 38988048 | |
sakila | store | 4090345776 | 6 | 4090345776 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4225997952 | 0 | 0 | 0 | 5 | 49246560 | |
sakila | inventory | 4073452944 | 9166 | 4073452944 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 2991546096 | 0 | 0 | 0 | 5 | 38307984 | |
sakila | actor | 2633258496 | 200 | 2633258496 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2604273936 | 0 | 0 | 0 | 5 | 119552400 | |
sakila | language | 2401866720 | 779 | 2401866720 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 822757056 | 0 | 0 | 0 | 5 | 49634112 | |
sakila | customer | 1770483264 | 28 | 1770483264 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2642708640 | 0 | 0 | 0 | 5 | 56267376 | |
sakila | address | 1413669840 | 29 | 1413669840 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1398768624 | 0 | 0 | 0 | 5 | 39568320 | |
sakila | film_actor | 1355375472 | 3 | 1355375472 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1487489520 | 0 | 0 | 0 | 5 | 34910832 | |
test19 | ecurie | 1231956528 | 16 | 1231956528 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1422312144 | 0 | 0 | 0 | 5 | 70690224 | |
sakila | city | 1116848304 | 30 | 1116848304 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1211899392 | 0 | 0 | 0 | 5 | 41360880 | |
sakila | staff | 1047210384 | 4 | 1047210384 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1177747824 | 0 | 0 | 0 | 5 | 40017648 | |
sakila | country | 870550560 | 55 | 870550560 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 853610736 | 0 | 0 | 0 | 5 | 50869104 | |
test19 | voiture | 683010240 | 8 | 683010240 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2393375952 | 0 | 0 | 0 | 5 | 31965648 | |
world | Country | 26323440 | 2 | 26323440 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 380259792 | 0 | 0 | 0 | 5 | 26604336 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 17102448 | 1 | 17102448 | 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 | |
performance_schema | global_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_waits_summary_by_user_by_event_name | 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 | |
test19 | rallye | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1406376576 | 0 | 0 | 0 | 5 | 44033088 | |
performance_schema | file_summary_by_event_name | 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 |
|