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 | 118482788160 | 32114 | 118482788160 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 16154539632 | 0 | 0 | 0 | 5 | 33043296 | |
sakila | rental | 25124120736 | 41250 | 25124120736 | 0 | 0 | 0 | 0 | 0 | 0 | 68 | 1163264 | 24580750656 | 0 | 0 | 0 | 5 | 9118539936 | |
sakila | inventory | 7270670880 | 11188 | 7270670880 | 0 | 0 | 0 | 0 | 0 | 0 | 19 | 360448 | 3493076928 | 0 | 0 | 0 | 5 | 51673248 | |
sakila | film | 3749806368 | 2209 | 3749806368 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1624946928 | 0 | 0 | 0 | 5 | 54521280 | |
sakila | customer | 2344111440 | 51 | 2344111440 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3495355248 | 0 | 0 | 0 | 5 | 165812592 | |
sakila | address | 2191013616 | 133 | 2191013616 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3190465872 | 0 | 0 | 0 | 5 | 466662768 | |
sakila | city | 1190770416 | 126 | 1190770416 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1617337392 | 0 | 0 | 0 | 5 | 483495408 | |
sakila | language | 1061576736 | 157 | 1061576736 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 762550272 | 0 | 0 | 0 | 5 | 56578368 | |
sakila | film_text | 1041962064 | 26 | 1041962064 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 3415 | 620546256 | 0 | 0 | 0 | 34 | 59565264 | |
sakila | film_category | 923183712 | 2058 | 923183712 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1806368256 | 0 | 0 | 0 | 5 | 52212336 | |
sakila | actor | 826989504 | 135 | 826989504 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1310143296 | 0 | 0 | 0 | 5 | 430247136 | |
sakila | category | 293517312 | 59 | 293517312 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 829736160 | 0 | 0 | 0 | 5 | 53670672 | |
sakila | store | 292325616 | 3 | 292325616 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1424721936 | 0 | 0 | 0 | 5 | 38874000 | |
sakila | staff | 200143680 | 27 | 200143680 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2347322736 | 0 | 0 | 0 | 5 | 49565472 | |
sakila | country | 189999744 | 25 | 189999744 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 982131744 | 0 | 0 | 0 | 5 | 68706528 | |
students | teacher | 66738144 | 2 | 33182688 | 1 | 33555456 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 133155792 | 6 | 51580782000 | |
world | Country | 20344368 | 2 | 20344368 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 217346976 | 0 | 0 | 0 | 5 | 26752176 | |
world | City | 13663056 | 1 | 13663056 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 339488160 | 0 | 0 | 0 | 4 | 22226688 | |
performance_schema | global_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | film_actor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1794672528 | 0 | 0 | 0 | 5 | 32545920 | |
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 | routines | 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 | table_stats | 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 |
|