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 | payment | 177200451120 | 96267 | 177200451120 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 15801461280 | 0 | 0 | 0 | 5 | 42516144 | |
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 | 6091002192 | 27498 | 6091002192 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 2796676080 | 0 | 0 | 0 | 5 | 44692032 | |
sakila | actor | 4488060720 | 482 | 4488060720 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4431473904 | 0 | 0 | 0 | 5 | 39355536 | |
sakila | language | 4087641888 | 30 | 4087641888 | 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 | film | 3383814720 | 28 | 3383814720 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 5313580800 | 0 | 0 | 0 | 5 | 33733920 | |
sakila | staff | 2571880080 | 22 | 2571880080 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2473773984 | 0 | 0 | 0 | 5 | 36161664 | |
sakila | address | 2551704672 | 266 | 2551704672 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3588354000 | 0 | 0 | 0 | 5 | 38517072 | |
sakila | city | 1467222768 | 65 | 1467222768 | 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 | category | 1276773168 | 5 | 1276773168 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1486079760 | 0 | 0 | 0 | 5 | 38011776 | |
sakila | customer | 1250349408 | 31 | 1250349408 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1645456560 | 0 | 0 | 0 | 5 | 54224544 | |
vedettfak | fa | 1151921760 | 6 | 1151921760 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 4482475536 | 0 | 0 | 0 | 5 | 50028000 | |
sakila | store | 969866832 | 28 | 969866832 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 921500976 | 0 | 0 | 0 | 5 | 31832064 | |
world | CountryLanguage | 949878336 | 58 | 949878336 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 2357 | 1198338240 | 0 | 0 | 0 | 10 | 88313808 | |
Stefano | vulcano | 800922672 | 1 | 800922672 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1115327664 | 0 | 0 | 0 | 5 | 38067216 | |
sakila | country | 765063552 | 40 | 765063552 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 698987520 | 0 | 0 | 0 | 5 | 38806944 | |
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 | 33644160 | 2 | 33644160 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 723304032 | 0 | 0 | 0 | 4 | 22617408 | |
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 |
|