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 | customer | 8733799536 | 52 | 8733799536 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4290425040 | 0 | 0 | 0 | 5 | 66679536 | |
sakila | city | 4380846624 | 78 | 4380846624 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4397718864 | 0 | 0 | 0 | 5 | 44792880 | |
sakila | language | 1861673088 | 82 | 1861673088 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 812869200 | 0 | 0 | 0 | 5 | 49606656 | |
sakila | staff | 1703413536 | 5 | 1703413536 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1474040832 | 0 | 0 | 0 | 5 | 42596400 | |
sakila | film | 1372577712 | 78 | 1372577712 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1778438640 | 0 | 0 | 0 | 5 | 64851072 | |
sakila | address | 1306816896 | 54 | 1306816896 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1125946800 | 0 | 0 | 0 | 5 | 36293136 | |
sakila | country | 1222855920 | 101 | 1222855920 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 958929840 | 0 | 0 | 0 | 5 | 42346656 | |
sakila | store | 862163808 | 3 | 862163808 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 970738560 | 0 | 0 | 0 | 5 | 38940528 | |
test_db_ayoo | item_foods | 624253872 | 38 | 542856864 | 2 | 81397008 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 255595824 | 8 | 75852841152 | |
donate | chat | 344411232 | 123 | 344411232 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 4766791392 | 11 | 125342789088 | |
stud | stud | 111440736 | 2 | 82495248 | 1 | 28945488 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 225004560 | 7 | 49288829568 | |
world | CountryLanguage | 31495728 | 2 | 31495728 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 407 | 510856896 | 0 | 0 | 0 | 6 | 36782592 | |
hotel | admin | 22492800 | 2 | 22492800 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 255768480 | 6 | 58545665376 | |
mysql | dd_properties | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | schemata | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespace_files | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespaces | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | check_constraints | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | column_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | foreign_key_column_usage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | foreign_keys | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_column_usage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_partitions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | indexes | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|