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 | 998379469824 | 1155087 | 998379469824 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1095351840 | 0 | 0 | 0 | 5 | 18775152 | |
sakila | film | 538572655104 | 1079495 | 538572655104 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3123067728 | 0 | 0 | 0 | 5 | 38448960 | |
sakila | payment | 200591627280 | 96269 | 200591627280 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 17495564064 | 0 | 0 | 0 | 5 | 44349360 | |
sakila | film_actor | 197378478000 | 1156436 | 197378478000 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 1781776656 | 0 | 0 | 0 | 5 | 31459824 | |
sakila | rental | 55016378208 | 123755 | 55016378208 | 0 | 0 | 0 | 0 | 0 | 0 | 22 | 409600 | 13474255344 | 0 | 0 | 0 | 5 | 52621536 | |
sakila | category | 18908441904 | 36088 | 18908441904 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 959832192 | 0 | 0 | 0 | 5 | 44006688 | |
sakila | inventory | 15154840272 | 27524 | 15154840272 | 0 | 0 | 0 | 0 | 0 | 0 | 23 | 425984 | 12487613424 | 0 | 0 | 0 | 5 | 50657904 | |
sakila | customer | 6857092704 | 84 | 6857092704 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 6752874480 | 0 | 0 | 0 | 5 | 39146448 | |
sakila | staff | 6712960320 | 35 | 6712960320 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 6425582592 | 0 | 0 | 0 | 5 | 56394624 | |
test19 | pilote | 4757491728 | 9 | 4757491728 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4751543808 | 0 | 0 | 0 | 5 | 111680448 | |
vedettfak | fa | 4616952912 | 10 | 4616952912 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 5633179728 | 0 | 0 | 0 | 5 | 60641856 | |
sku | Attore | 4394456352 | 2 | 4394456352 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3772319232 | 0 | 0 | 0 | 5 | 108243696 | |
sakila | actor | 3299759760 | 1935 | 3299759760 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2185309104 | 0 | 0 | 0 | 5 | 91452240 | |
sakila | city | 2732304432 | 236 | 2732304432 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1823986032 | 0 | 0 | 0 | 5 | 107448528 | |
vedettfak | megye | 2569084848 | 62 | 2569084848 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1678237968 | 0 | 0 | 0 | 5 | 138808032 | |
Stefano | vulcano | 2514019728 | 4 | 2514019728 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2680108464 | 0 | 0 | 0 | 5 | 46851552 | |
Table_insertion | pilote | 2426211744 | 59 | 2426211744 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2429081424 | 0 | 0 | 0 | 5 | 36022800 | |
sakila | language | 1943744352 | 153 | 1943744352 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1103541648 | 0 | 0 | 0 | 5 | 74678208 | |
test19 | ecurie | 1694980320 | 9 | 1694980320 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1560751104 | 0 | 0 | 0 | 5 | 108388368 | |
sakila | country | 1509735216 | 306 | 1509735216 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 867002400 | 0 | 0 | 0 | 5 | 59068416 | |
sakila | address | 1259282112 | 357 | 1259282112 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1315399008 | 0 | 0 | 0 | 5 | 34948320 | |
sakila | store | 1036727472 | 32 | 1036727472 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 925336896 | 0 | 0 | 0 | 5 | 44228976 | |
Table_insertion | ecurie | 985806096 | 14 | 985806096 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1074229200 | 0 | 0 | 0 | 5 | 46045824 | |
test19 | voiture | 965084208 | 5 | 965084208 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1179669216 | 0 | 0 | 0 | 5 | 38483808 | |
world | CountryLanguage | 745120464 | 56 | 745120464 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 2357 | 1259148000 | 0 | 0 | 0 | 8 | 53895600 |
|