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 | 5073048549888 | 5446402 | 5073048549888 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 5048009472 | 0 | 0 | 0 | 5 | 37432560 | |
sakila | film | 2750685782064 | 5088354 | 2750685782064 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 6295211472 | 0 | 0 | 0 | 5 | 34248192 | |
sakila | film_actor | 1004842510320 | 5451676 | 1004842510320 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 6532429200 | 0 | 0 | 0 | 5 | 33722304 | |
sakila | actor | 495660975744 | 7356 | 495660975744 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 3948247248 | 0 | 0 | 0 | 5 | 488478040512 | |
sakila | category | 95703936240 | 169638 | 95703936240 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1285435536 | 0 | 0 | 0 | 5 | 36899280 | |
sakila | address | 57737564544 | 369 | 57737564544 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2784447072 | 0 | 0 | 0 | 5 | 48069120 | |
sakila | staff | 36425901072 | 45 | 36425901072 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 1561318176 | 0 | 0 | 0 | 5 | 52351200 | |
sakila | country | 35201715120 | 344 | 35201715120 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1523617920 | 0 | 0 | 0 | 5 | 40602672 | |
sakila | city | 25333507056 | 374 | 25333507056 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1797050112 | 0 | 0 | 0 | 5 | 100364880 | |
sakila | customer | 7844949552 | 192 | 7844949552 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 2685249600 | 0 | 0 | 0 | 5 | 88992288 | |
sakila | store | 4105685232 | 25 | 4105685232 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 5755778160 | 0 | 0 | 0 | 5 | 40955376 | |
test19 | voiture | 3801159648 | 9 | 3801159648 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 5206992912 | 0 | 0 | 0 | 5 | 52364400 | |
world | Country | 3588843984 | 94 | 3588843984 | 0 | 0 | 0 | 0 | 0 | 0 | 77 | 20037 | 1888543008 | 0 | 0 | 0 | 13 | 109964448 | |
vedettfak | fa | 3001474608 | 4 | 3001474608 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 3225557808 | 0 | 0 | 0 | 5 | 66838992 | |
Stefano | vulcano | 2547512352 | 5 | 2547512352 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2523888576 | 0 | 0 | 0 | 5 | 356438544 | |
sakila | language | 2427584544 | 331 | 2427584544 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 962961120 | 0 | 0 | 0 | 5 | 55876656 | |
sakila | film_text | 2404030464 | 15 | 2404030464 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 565 | 2642898720 | 0 | 0 | 0 | 13 | 77949168 | |
sakila | rental | 1794987744 | 15 | 1794987744 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 7704980448 | 0 | 0 | 0 | 5 | 49141488 | |
sakila | payment | 1359812256 | 9 | 1359812256 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 5867028816 | 0 | 0 | 0 | 5 | 50569200 | |
test19 | pilote | 1254740784 | 13 | 1254740784 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1134972960 | 0 | 0 | 0 | 5 | 101077152 | |
sys | sys_config | 983169792 | 21 | 983169792 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1806205632 | 0 | 0 | 0 | 5 | 204936336 | |
test19 | ecurie | 886096464 | 13 | 886096464 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1330088496 | 0 | 0 | 0 | 5 | 70932048 | |
vedettfak | megye | 770019888 | 20 | 770019888 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2026349424 | 0 | 0 | 0 | 5 | 268536048 | |
sku | Attore | 702967056 | 4 | 702967056 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 935733744 | 0 | 0 | 0 | 5 | 46940256 | |
world | City | 374024640 | 2 | 374024640 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 633825456 | 0 | 0 | 0 | 4 | 23782704 |
|