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 | 21401573952 | 16049 | 21401573952 | 0 | 0 | 0 | 0 | 0 | 0 | 48 | 835584 | 6963446160 | 0 | 0 | 0 | 5 | 59306544 | |
sakila | rental | 17596656000 | 16044 | 17596656000 | 0 | 0 | 0 | 0 | 0 | 0 | 51 | 884736 | 6406355472 | 0 | 0 | 0 | 5 | 32835792 | |
sakila | film | 7370708400 | 1302 | 7370708400 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2599279584 | 0 | 0 | 0 | 5 | 35797344 | |
vedettfak | fa | 7345217616 | 1258 | 7345217616 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 3850700832 | 0 | 0 | 0 | 5 | 719930640 | |
sakila | inventory | 5253962208 | 4581 | 5253962208 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 278528 | 2930190384 | 0 | 0 | 0 | 5 | 44234256 | |
sakila | film_actor | 5138830224 | 5462 | 5138830224 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1495931184 | 0 | 0 | 0 | 5 | 33410256 | |
world | City | 4512828672 | 4079 | 4512828672 | 0 | 0 | 0 | 0 | 0 | 0 | 4081 | 273685 | 2473241760 | 0 | 0 | 0 | 4 | 26992416 | |
sakila | film_category | 4103971872 | 1003 | 4103971872 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 3905299728 | 0 | 0 | 0 | 5 | 53494320 | |
sakila | customer | 4027413456 | 599 | 4027413456 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 3079194624 | 0 | 0 | 0 | 5 | 33279312 | |
sku | Attore | 3978308400 | 1 | 3978308400 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2681618016 | 0 | 0 | 0 | 5 | 881466432 | |
sakila | address | 2774599872 | 629 | 2774599872 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1373020704 | 0 | 0 | 0 | 5 | 41628048 | |
TlapaleriaMalfoy | Registro | 2556520032 | 2 | 2556520032 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2023605408 | 0 | 0 | 0 | 5 | 739377408 | |
sakila | actor | 2414431536 | 888 | 2414431536 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1507069872 | 0 | 0 | 0 | 5 | 106435824 | |
Stefano | vulcano | 2089791792 | 11 | 2089791792 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 907748160 | 0 | 0 | 0 | 5 | 2224306656 | |
sakila | city | 2002569360 | 651 | 2002569360 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1075448880 | 0 | 0 | 0 | 5 | 72793248 | |
sakila | film_text | 1741199328 | 1000 | 1741199328 | 0 | 0 | 0 | 0 | 0 | 0 | 2002 | 119290 | 1445904768 | 0 | 0 | 0 | 1004 | 157853520 | |
sakila | language | 1533524256 | 465 | 1533524256 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 721696272 | 0 | 0 | 0 | 5 | 34889712 | |
sakila | staff | 1161434736 | 2 | 1161434736 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1209805872 | 0 | 0 | 0 | 5 | 32555424 | |
world | Country | 1125156912 | 239 | 1125156912 | 0 | 0 | 0 | 0 | 0 | 0 | 241 | 62841 | 933756912 | 0 | 0 | 0 | 4 | 22519728 | |
world | CountryLanguage | 1091804736 | 984 | 1091804736 | 0 | 0 | 0 | 0 | 0 | 0 | 986 | 38783 | 932076816 | 0 | 0 | 0 | 4 | 24654960 | |
test19 | ecurie | 1086858432 | 4 | 1086858432 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 946814880 | 0 | 0 | 0 | 5 | 422010336 | |
vedettfak | megye | 1074953088 | 19 | 1074953088 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1213461216 | 0 | 0 | 0 | 5 | 70061376 | |
sakila | country | 959325840 | 135 | 959325840 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 929127936 | 0 | 0 | 0 | 5 | 38328048 | |
sakila | category | 883328688 | 80 | 883328688 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1022463552 | 0 | 0 | 0 | 5 | 50832144 | |
test19 | pilote | 880610016 | 30 | 880610016 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1079115312 | 0 | 0 | 0 | 5 | 47276592 |
|