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 | film | 19923305952 | 4305 | 19923305952 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4660170768 | 0 | 0 | 0 | 5 | 41812320 | |
sakila | inventory | 4955548224 | 52 | 4955548224 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 5924856432 | 0 | 0 | 0 | 5 | 38433120 | |
sakila | customer | 4437287712 | 26 | 4437287712 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 6357327504 | 0 | 0 | 0 | 5 | 40790640 | |
sakila | country | 4223117712 | 103 | 4223117712 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3831944160 | 0 | 0 | 0 | 5 | 36709728 | |
sakila | actor | 3988528368 | 26 | 3988528368 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4095643200 | 0 | 0 | 0 | 5 | 41534592 | |
test19 | voiture | 3295705248 | 17 | 3295705248 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2614697184 | 0 | 0 | 0 | 5 | 943582992 | |
sakila | address | 1643519328 | 53 | 1643519328 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1651909248 | 0 | 0 | 0 | 5 | 32693232 | |
sakila | language | 1243942128 | 107 | 1243942128 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 730850208 | 0 | 0 | 0 | 5 | 43748496 | |
sakila | city | 1170385392 | 103 | 1170385392 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 966454368 | 0 | 0 | 0 | 5 | 37358112 | |
test19 | ecurie | 1151401152 | 14 | 1151401152 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1243578336 | 0 | 0 | 0 | 5 | 75311808 | |
sys | sys_config | 1017469200 | 15 | 1017469200 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 738198912 | 0 | 0 | 0 | 5 | 471667680 | |
sakila | category | 855096000 | 17 | 855096000 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 990617760 | 0 | 0 | 0 | 5 | 44293392 | |
sakila | payment | 89334432 | 2 | 89334432 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 5507230608 | 0 | 0 | 0 | 5 | 22616352 | |
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 |
|