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 | 292520784336 | 330000 | 292520784336 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 976654272 | 0 | 0 | 0 | 5 | 23103696 | |
sakila | payment | 177200451120 | 96267 | 177200451120 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 15801461280 | 0 | 0 | 0 | 5 | 42516144 | |
sakila | film | 151601936640 | 308234 | 151601936640 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 5313580800 | 0 | 0 | 0 | 5 | 33733920 | |
sakila | film_actor | 60256705344 | 330428 | 60256705344 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 3604152816 | 0 | 0 | 0 | 5 | 38720880 | |
sakila | rental | 42205757616 | 123754 | 42205757616 | 0 | 0 | 0 | 0 | 0 | 0 | 22 | 409600 | 6225198144 | 0 | 0 | 0 | 5 | 38714544 | |
test19 | ecurie | 18603871968 | 4 | 18603871968 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2053216176 | 0 | 0 | 0 | 5 | 41408400 | |
sakila | inventory | 8947962144 | 27524 | 8947962144 | 0 | 0 | 0 | 0 | 0 | 0 | 23 | 425984 | 8541554208 | 0 | 0 | 0 | 5 | 44692032 | |
sakila | category | 6417111360 | 10275 | 6417111360 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1486079760 | 0 | 0 | 0 | 5 | 38011776 | |
sakila | staff | 4951477872 | 28 | 4951477872 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 4790376096 | 0 | 0 | 0 | 5 | 36161664 | |
sakila | actor | 4824272640 | 914 | 4824272640 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4431473904 | 0 | 0 | 0 | 5 | 39355536 | |
sakila | language | 4148475936 | 54 | 4148475936 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4031819616 | 0 | 0 | 0 | 5 | 38378736 | |
TlapaleriaMalfoy | Registro | 3539959104 | 2 | 3539959104 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3063991392 | 0 | 0 | 0 | 5 | 88535040 | |
sakila | address | 2565380400 | 269 | 2565380400 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3588354000 | 0 | 0 | 0 | 5 | 38517072 | |
sakila | city | 1579698384 | 98 | 1579698384 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1305734496 | 0 | 0 | 0 | 5 | 41164992 | |
vedettfak | megye | 1355625744 | 43 | 1355625744 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 902899536 | 0 | 0 | 0 | 5 | 36202848 | |
sakila | customer | 1250349408 | 31 | 1250349408 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1645456560 | 0 | 0 | 0 | 5 | 54224544 | |
vedettfak | fa | 1238841120 | 10 | 1238841120 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 4482475536 | 0 | 0 | 0 | 5 | 50028000 | |
sakila | store | 1019046336 | 30 | 1019046336 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 921500976 | 0 | 0 | 0 | 5 | 31832064 | |
sakila | country | 996794832 | 194 | 996794832 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 698987520 | 0 | 0 | 0 | 5 | 38806944 | |
world | CountryLanguage | 949878336 | 58 | 949878336 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 2357 | 1198338240 | 0 | 0 | 0 | 10 | 88313808 | |
sys | sys_config | 807342624 | 1 | 807342624 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1090861728 | 0 | 0 | 0 | 5 | 52448352 | |
Stefano | vulcano | 800922672 | 1 | 800922672 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1115327664 | 0 | 0 | 0 | 5 | 38067216 | |
test19 | voiture | 699999696 | 3 | 699999696 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 909156864 | 0 | 0 | 0 | 5 | 37012272 | |
test19 | pilote | 651047232 | 4 | 651047232 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 868288608 | 0 | 0 | 0 | 5 | 35377584 | |
world | Country | 61127088 | 5 | 61127088 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 723304032 | 0 | 0 | 0 | 7 | 44104368 |
|