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 | 138843566400 | 48132 | 138843566400 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 1114112 | 10649344464 | 0 | 0 | 0 | 5 | 17164224 | |
sakila | rental | 38928869232 | 61877 | 38928869232 | 0 | 0 | 0 | 0 | 0 | 0 | 22 | 409600 | 16049222640 | 0 | 0 | 0 | 5 | 45170400 | |
sakila | inventory | 8541985056 | 16743 | 8541985056 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1548986208 | 0 | 0 | 0 | 5 | 19258800 | |
sakila | film | 3963684384 | 3002 | 3963684384 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1417197408 | 0 | 0 | 0 | 5 | 29486688 | |
sakila | address | 1660604880 | 78 | 1660604880 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1391645904 | 0 | 0 | 0 | 5 | 41906832 | |
sakila | customer | 1443348192 | 52 | 1443348192 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 2782526736 | 0 | 0 | 0 | 5 | 52636320 | |
test19 | ecurie | 1280067360 | 8 | 1280067360 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1456589376 | 0 | 0 | 0 | 5 | 56906256 | |
sakila | film_category | 1134910656 | 3048 | 1134910656 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 814685520 | 0 | 0 | 0 | 5 | 18952560 | |
sakila | city | 760676400 | 35 | 760676400 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 867302832 | 0 | 0 | 0 | 5 | 21871344 | |
sakila | category | 756970368 | 51 | 756970368 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 840209040 | 0 | 0 | 0 | 5 | 38271552 | |
sakila | country | 756541104 | 65 | 756541104 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 772962960 | 0 | 0 | 0 | 5 | 37396128 | |
performance_schema | events_waits_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 | |
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_statements_current | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_transactions_current | 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 | |
mysql | func | 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 | session_variables | 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 | |
mysql | catalogs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | events | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | slave_worker_info | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | slave_relay_log_info | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|