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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
world | Country | 3825368448 | 27 | 3825368448 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 3855 | 5879646432 | 0 | 0 | 0 | 12 | 150791520 | |
vedettfak | fa | 3614528016 | 13 | 3614528016 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 3378181488 | 0 | 0 | 0 | 5 | 134278320 | |
sakila | store | 3496205328 | 3 | 3496205328 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 3580714896 | 0 | 0 | 0 | 5 | 54648528 | |
sakila | customer | 3054092448 | 78 | 3054092448 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3954037296 | 0 | 0 | 0 | 5 | 41535648 | |
sys | sys_config | 2469171408 | 149 | 2469171408 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1635180624 | 0 | 0 | 0 | 5 | 117001632 | |
sakila | address | 2009969280 | 77 | 2009969280 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 2234786400 | 0 | 0 | 0 | 5 | 47317248 | |
test19 | ecurie | 2004777456 | 7 | 2004777456 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2249333328 | 0 | 0 | 0 | 5 | 32670000 | |
test19 | pilote | 1500600816 | 5 | 1500600816 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1727517264 | 0 | 0 | 0 | 5 | 36584592 | |
world | City | 1443799104 | 8 | 1443799104 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 660 | 1615835760 | 0 | 0 | 0 | 8 | 103010688 | |
sku | Attore | 1194691344 | 13 | 1194691344 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 916181376 | 0 | 0 | 0 | 5 | 320289552 | |
sakila | staff | 1013646480 | 2 | 1013646480 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1135455552 | 0 | 0 | 0 | 5 | 34312608 | |
test19 | voiture | 945822240 | 5 | 945822240 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1130412096 | 0 | 0 | 0 | 5 | 33140976 | |
vedettfak | megye | 921832560 | 5 | 921832560 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 780569856 | 0 | 0 | 0 | 5 | 385611600 | |
sakila | city | 493617696 | 52 | 493617696 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1915156320 | 0 | 0 | 0 | 5 | 28978752 | |
sakila | film | 475069584 | 26 | 475069584 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2154267984 | 0 | 0 | 0 | 5 | 26150784 | |
sakila | country | 389087952 | 50 | 389087952 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1072073376 | 0 | 0 | 0 | 5 | 26762208 | |
sakila | actor | 381390768 | 26 | 381390768 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1578705744 | 0 | 0 | 0 | 5 | 47242272 | |
Ristorante | Personale | 219977472 | 0 | 0 | 4 | 219977472 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 399720288 | 6 | 71451351840 | |
Ristorante | Cliente | 194534208 | 0 | 0 | 5 | 194534208 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 5355675072 | 7 | 93509273616 | |
sakila | language | 186597312 | 25 | 186597312 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 730814832 | 0 | 0 | 0 | 5 | 23474352 | |
Ristorante | Ordinazione | 162879024 | 0 | 0 | 4 | 162879024 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 396853248 | 6 | 50016171216 | |
Ristorante | Portata | 151357536 | 24 | 151357536 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 295504176 | 9 | 83257191600 | |
Ristorante | IngredientiPortata | 110017248 | 0 | 0 | 16 | 110017248 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 306622272 | 6 | 64493992992 | |
TlapaleriaMalfoy | Registro | 46076976 | 3 | 46076976 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1111565664 | 0 | 0 | 0 | 5 | 270063552 | |
Ristorante | Portata_Ordinazione | 42012432 | 0 | 0 | 2 | 42012432 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 173464368 | 6 | 52304402832 |
|