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 | city | 116882689968 | 77 | 116882689968 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4932044832 | 0 | 0 | 0 | 5 | 64111344 | |
sakila | film_actor | 4211829072 | 26 | 4211829072 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 4876987632 | 0 | 0 | 0 | 5 | 34612512 | |
world | CountryLanguage | 3752434224 | 35 | 3752434224 | 0 | 0 | 0 | 0 | 0 | 0 | 31 | 1538 | 1826791296 | 0 | 0 | 0 | 10 | 85745616 | |
sakila | language | 2683092720 | 50 | 2683092720 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2555591280 | 0 | 0 | 0 | 5 | 38334384 | |
Table_insertion | ecurie | 1857053088 | 7 | 1857053088 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1801991664 | 0 | 0 | 0 | 5 | 110788128 | |
sakila | customer | 1735329552 | 25 | 1735329552 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1631208480 | 0 | 0 | 0 | 5 | 36927792 | |
sakila | film | 1693815024 | 77 | 1693815024 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2033885040 | 0 | 0 | 0 | 5 | 34691184 | |
sakila | rental | 1333704768 | 26 | 1333704768 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 12959350800 | 0 | 0 | 0 | 5 | 44942304 | |
sakila | actor | 1236153072 | 25 | 1236153072 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1176422544 | 0 | 0 | 0 | 5 | 76978704 | |
sakila | address | 1136565936 | 26 | 1136565936 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1678039440 | 0 | 0 | 0 | 5 | 35558160 | |
sakila | staff | 1088223840 | 25 | 1088223840 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1073800992 | 0 | 0 | 0 | 5 | 31584432 | |
sku | Attore | 905421264 | 2 | 905421264 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 861632112 | 0 | 0 | 0 | 5 | 38402496 | |
sakila | country | 894423024 | 50 | 894423024 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 833753712 | 0 | 0 | 0 | 5 | 37659072 | |
test19 | pilote | 782415744 | 2 | 782415744 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1024207536 | 0 | 0 | 0 | 5 | 44443872 | |
test19 | voiture | 714960576 | 2 | 714960576 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 971013120 | 0 | 0 | 0 | 5 | 34277232 | |
Table_insertion | pilote | 593024784 | 5 | 593024784 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 684195600 | 0 | 0 | 0 | 5 | 32951952 | |
Ristorante | Cliente | 551955888 | 0 | 0 | 5 | 551955888 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 432802656 | 6 | 74296442880 | |
world | Country | 486487056 | 4 | 486487056 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 984 | 742600848 | 0 | 0 | 0 | 6 | 36016992 | |
Ristorante | Menu | 298328448 | 0 | 0 | 9 | 298328448 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 773989920 | 6 | 69041050848 | |
Ristorante | Ordinazione | 167197536 | 0 | 0 | 4 | 167197536 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 527325216 | 6 | 64188659040 | |
Ristorante | IngredientiPortata | 162926544 | 0 | 0 | 16 | 162926544 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 456974496 | 6 | 68453729520 | |
Ristorante | Personale | 157451184 | 0 | 0 | 4 | 157451184 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 623211072 | 6 | 64255346496 | |
Ristorante | Portata_Ordinazione | 142716816 | 0 | 0 | 2 | 142716816 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 491637696 | 6 | 78664802304 | |
Ristorante | Portata | 71273664 | 0 | 0 | 9 | 71273664 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 174592704 | 6 | 99109237392 | |
mysql | dd_properties | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|