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_category | 166033697808 | 165000 | 166033697808 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 991677984 | 0 | 0 | 0 | 5 | 56390400 | |
sakila | film | 90891920592 | 154232 | 90891920592 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 6720301632 | 0 | 0 | 0 | 5 | 38522352 | |
sakila | language | 56597369136 | 150 | 56597369136 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 653571600 | 0 | 0 | 0 | 5 | 70057680 | |
sakila | film_actor | 38924457792 | 165204 | 38924457792 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 5436936912 | 0 | 0 | 0 | 5 | 50627808 | |
sakila | category | 3695104512 | 5135 | 3695104512 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 781418352 | 0 | 0 | 0 | 5 | 25344528 | |
sakila | rental | 3135280896 | 26 | 3135280896 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 8010505536 | 0 | 0 | 0 | 5 | 262231200 | |
sakila | city | 2527332192 | 79 | 2527332192 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 2281636368 | 0 | 0 | 0 | 5 | 52384464 | |
world | CountryLanguage | 2281206576 | 30 | 2281206576 | 0 | 0 | 0 | 0 | 0 | 0 | 27 | 1382 | 2511329040 | 0 | 0 | 0 | 8 | 50502144 | |
Stefano | vulcano | 2135002320 | 3 | 2135002320 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2067727728 | 0 | 0 | 0 | 5 | 370219344 | |
sakila | customer | 1770806400 | 53 | 1770806400 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1590932112 | 0 | 0 | 0 | 5 | 45194688 | |
sakila | address | 1728310848 | 51 | 1728310848 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2833423824 | 0 | 0 | 0 | 5 | 41460672 | |
sakila | actor | 1599831024 | 204 | 1599831024 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1638486960 | 0 | 0 | 0 | 5 | 58940640 | |
sakila | country | 1175616288 | 76 | 1175616288 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 912188640 | 0 | 0 | 0 | 5 | 37268880 | |
sku | Attore | 1015199328 | 1 | 1015199328 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 903846768 | 0 | 0 | 0 | 5 | 40069392 | |
sakila | staff | 934026192 | 25 | 934026192 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 930386688 | 0 | 0 | 0 | 5 | 34758768 | |
sys | sys_config | 723895920 | 1 | 723895920 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 801082656 | 0 | 0 | 0 | 5 | 205543536 | |
Table_insertion | voiture | 679227648 | 2 | 679227648 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 985043136 | 0 | 0 | 0 | 5 | 45140832 | |
world | City | 33240768 | 1 | 33240768 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 409711104 | 0 | 0 | 0 | 5 | 36546048 | |
TlapaleriaMalfoy | Registro | 30672048 | 2 | 30672048 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1410773760 | 0 | 0 | 0 | 5 | 468761568 | |
Table_insertion | ecurie | 19798416 | 2 | 19798416 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1237799376 | 0 | 0 | 0 | 5 | 35243472 | |
world | Country | 19225536 | 2 | 19225536 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 554005584 | 0 | 0 | 0 | 5 | 27184080 | |
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 |
|