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 | 24869464752 | 16049 | 24869464752 | 0 | 0 | 0 | 0 | 0 | 0 | 48 | 835584 | 4888615248 | 0 | 0 | 0 | 5 | 21030768 | |
sakila | rental | 21801517584 | 16044 | 21801517584 | 0 | 0 | 0 | 0 | 0 | 0 | 51 | 884736 | 8337165408 | 0 | 0 | 0 | 5 | 29491968 | |
sakila | film | 7217373504 | 1303 | 7217373504 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2130501120 | 0 | 0 | 0 | 5 | 29840448 | |
sakila | city | 6822136992 | 761 | 6822136992 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 5748721440 | 0 | 0 | 0 | 5 | 55615296 | |
sakila | film_actor | 6820173888 | 5519 | 6820173888 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 3000695808 | 0 | 0 | 0 | 5 | 35912448 | |
sakila | inventory | 3730846944 | 4607 | 3730846944 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2839518528 | 0 | 0 | 0 | 5 | 21843360 | |
vedettfak | fa | 3703946400 | 1287 | 3703946400 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 2848656624 | 0 | 0 | 0 | 5 | 38357616 | |
kupa | meccs | 3405778992 | 8982 | 3405778992 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 278528 | 8980031280 | 10 | 88420851552 | |
sakila | address | 3262934928 | 629 | 3262934928 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1398803472 | 0 | 0 | 0 | 5 | 45552144 | |
world | City | 3225499728 | 4079 | 3225499728 | 0 | 0 | 0 | 0 | 0 | 0 | 4081 | 273685 | 2677744080 | 0 | 0 | 0 | 4 | 22900416 | |
kupa | csapat | 2451586368 | 1290 | 2451586368 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 572387904 | 11 | 128059881840 | |
world | CountryLanguage | 2069402016 | 984 | 2069402016 | 0 | 0 | 0 | 0 | 0 | 0 | 986 | 38783 | 2034311136 | 0 | 0 | 0 | 4 | 24519264 | |
sakila | film_text | 2018202384 | 1000 | 2018202384 | 0 | 0 | 0 | 0 | 0 | 0 | 2002 | 119290 | 3844200624 | 0 | 0 | 0 | 1005 | 205229376 | |
test19 | pilote | 2000391888 | 30 | 2000391888 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2177336304 | 0 | 0 | 0 | 5 | 56953776 | |
sku | Attore | 1928429184 | 1 | 1928429184 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2014608816 | 0 | 0 | 0 | 5 | 118250880 | |
Table_insertion | ecurie | 1898097168 | 18 | 1898097168 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1840562592 | 0 | 0 | 0 | 5 | 114561216 | |
Table_insertion | pilote | 1895740176 | 30 | 1895740176 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1763289792 | 0 | 0 | 0 | 5 | 105814368 | |
TlapaleriaMalfoy | Registro | 1643990832 | 2 | 1643990832 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1688358144 | 0 | 0 | 0 | 5 | 161634528 | |
test19 | voiture | 1604130528 | 14 | 1604130528 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1757596896 | 0 | 0 | 0 | 5 | 69376560 | |
sakila | actor | 1563197856 | 450 | 1563197856 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1904985456 | 0 | 0 | 0 | 5 | 41129616 | |
test19 | ecurie | 1538014896 | 4 | 1538014896 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1844007792 | 0 | 0 | 0 | 5 | 37154832 | |
sakila | staff | 1473538704 | 2 | 1473538704 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1888437936 | 0 | 0 | 0 | 5 | 29835696 | |
sakila | customer | 1230421104 | 599 | 1230421104 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1183361520 | 0 | 0 | 0 | 5 | 27277536 | |
Table_insertion | voiture | 1113584208 | 29 | 1113584208 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1231565808 | 0 | 0 | 0 | 5 | 36068208 | |
vedettfak | megye | 1004063808 | 120 | 1004063808 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1092377088 | 0 | 0 | 0 | 5 | 38990688 |
|