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 | actor | 3802161792 | 4 | 3802161792 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3954419040 | 0 | 0 | 0 | 5 | 35371776 | |
sakila | staff | 2040910608 | 5 | 2040910608 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1345989216 | 0 | 0 | 0 | 5 | 43051008 | |
sakila | inventory | 1618550736 | 26 | 1618550736 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2181272544 | 0 | 0 | 0 | 5 | 50386512 | |
sakila | city | 1511733696 | 276 | 1511733696 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1233268608 | 0 | 0 | 0 | 5 | 35670624 | |
sakila | film | 1493524560 | 51 | 1493524560 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1821844464 | 0 | 0 | 0 | 5 | 37986432 | |
sakila | language | 1299865248 | 25 | 1299865248 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 713616816 | 0 | 0 | 0 | 5 | 46238016 | |
sakila | address | 1280795472 | 59 | 1280795472 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1964166336 | 0 | 0 | 0 | 5 | 42586368 | |
sakila | country | 840933456 | 51 | 840933456 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 811113600 | 0 | 0 | 0 | 5 | 38922048 | |
sakila | store | 678550224 | 3 | 678550224 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 801185088 | 0 | 0 | 0 | 5 | 40538784 | |
course | users | 512847984 | 34 | 422329248 | 2 | 55274208 | 1 | 35244528 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 224235264 | 8 | 71682129552 | |
performance_schema | variables_by_thread | 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 | |
performance_schema | global_status | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
base | base | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 155990208 | 6 | 54763642560 | |
ecom_store | cart | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 215790960 | 7 | 69720270048 | |
performance_schema | accounts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
ecom_store | about_us | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 152257776 | 6 | 60299553072 | |
performance_schema | global_variables | 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 | |
ecom_store | bundle_product_relation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 152098320 | 6 | 51883672896 | |
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 | events_statements_current | 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 | |
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 |
|