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 | inventory | 4677720432 | 26 | 4677720432 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 6663385344 | 0 | 0 | 0 | 5 | 38082528 | |
sakila | film_category | 4043042256 | 2 | 4043042256 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4123069104 | 0 | 0 | 0 | 5 | 47621376 | |
sakila | country | 3753535632 | 26 | 3753535632 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3857728512 | 0 | 0 | 0 | 5 | 43494528 | |
sakila | address | 2684241120 | 52 | 2684241120 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3175888848 | 0 | 0 | 0 | 5 | 35578752 | |
sakila | film | 1928819376 | 77 | 1928819376 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2383468560 | 0 | 0 | 0 | 5 | 453117456 | |
sakila | city | 1810040496 | 50 | 1810040496 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 1405861248 | 0 | 0 | 0 | 5 | 85694928 | |
sakila | language | 1072780368 | 50 | 1072780368 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 859837968 | 0 | 0 | 0 | 5 | 69424080 | |
sakila | actor | 1026666960 | 78 | 1026666960 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 776031168 | 0 | 0 | 0 | 5 | 367212384 | |
htmlfile | students | 127061088 | 16 | 127061088 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 127185696 | 6 | 42486133008 | |
htmlfile | users | 67586640 | 6 | 67586640 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 126884208 | 9 | 71675918160 | |
htmlfile | fees_received | 36785232 | 4 | 36785232 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 145046352 | 9 | 60045986352 | |
htmlfile | partial_payments | 35721312 | 3 | 35721312 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 392535792 | 9 | 98708102592 | |
htmlfile | student_fees | 35424048 | 6 | 35424048 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 289618032 | 9 | 115226074656 | |
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 | column_statistics | 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 | time_zone_transition_type | 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 | 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 | |
mysql | slave_master_info | 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 | |
mysql | servers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | time_zone_transition | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|