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 | language | 14120502000 | 157 | 14120502000 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 13074381936 | 0 | 0 | 0 | 5 | 61721616 | |
sakila | country | 5257843008 | 305 | 5257843008 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4139238576 | 0 | 0 | 0 | 5 | 46418592 | |
sakila | film_actor | 4965701136 | 3 | 4965701136 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 5071475904 | 0 | 0 | 0 | 5 | 41048832 | |
Table_insertion | ecurie | 4390496880 | 25 | 4390496880 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4342142112 | 0 | 0 | 0 | 5 | 37420416 | |
sakila | store | 3932165952 | 3 | 3932165952 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4025068608 | 0 | 0 | 0 | 5 | 43011408 | |
sakila | inventory | 2737272384 | 52 | 2737272384 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3948012816 | 0 | 0 | 0 | 5 | 52438848 | |
Stefano | vulcano | 2270115408 | 2 | 2270115408 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2528775744 | 0 | 0 | 0 | 5 | 48222768 | |
sakila | city | 2144477808 | 284 | 2144477808 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1243393008 | 0 | 0 | 0 | 5 | 41567328 | |
sakila | film | 1753388736 | 406 | 1753388736 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1769755152 | 0 | 0 | 0 | 5 | 32598192 | |
sakila | actor | 1710057888 | 200 | 1710057888 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1657432656 | 0 | 0 | 0 | 5 | 106732032 | |
sakila | address | 1341842832 | 108 | 1341842832 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1733615136 | 0 | 0 | 0 | 5 | 38567760 | |
sakila | staff | 1146255264 | 5 | 1146255264 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1159536048 | 0 | 0 | 0 | 5 | 31923408 | |
vedettfak | fa | 1095117408 | 4 | 1095117408 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1508622192 | 0 | 0 | 0 | 5 | 40310160 | |
Table_insertion | pilote | 1053531072 | 66 | 1053531072 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1081871472 | 0 | 0 | 0 | 5 | 34585584 | |
vedettfak | megye | 690028416 | 8 | 690028416 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 857909712 | 0 | 0 | 0 | 5 | 68348544 | |
world | City | 59338224 | 4 | 59338224 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 272962800 | 0 | 0 | 0 | 5 | 28967664 | |
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 |
|