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 | 47342298960 | 32124 | 47342298960 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 14346264768 | 0 | 0 | 0 | 5 | 64878528 | |
sakila | rental | 39081116976 | 32088 | 39081116976 | 0 | 0 | 0 | 0 | 0 | 0 | 51 | 884736 | 15214690656 | 0 | 0 | 0 | 5 | 30601296 | |
sakila | store | 32175759264 | 4 | 32175759264 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3190900944 | 0 | 0 | 0 | 5 | 115297776 | |
vedettfak | fa | 13817498112 | 2516 | 13817498112 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 2253374112 | 0 | 0 | 0 | 5 | 106258944 | |
world | City | 13570958544 | 8158 | 13570958544 | 0 | 0 | 0 | 0 | 0 | 0 | 8160 | 546978 | 6434073888 | 0 | 0 | 0 | 5 | 67880736 | |
sakila | film_actor | 11762084928 | 10924 | 11762084928 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 3310469712 | 0 | 0 | 0 | 5 | 32255520 | |
sakila | film | 6343058832 | 2126 | 6343058832 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1274515440 | 0 | 0 | 0 | 5 | 39391968 | |
sakila | inventory | 4860301248 | 9162 | 4860301248 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 278528 | 2229097728 | 0 | 0 | 0 | 5 | 32609280 | |
sakila | film_text | 4480567344 | 2000 | 4480567344 | 0 | 0 | 0 | 0 | 0 | 0 | 4002 | 238138 | 2303779104 | 0 | 0 | 0 | 2005 | 310692624 | |
sakila | staff | 3917585760 | 29 | 3917585760 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1325032896 | 0 | 0 | 0 | 5 | 26055216 | |
sakila | customer | 3311389488 | 1223 | 3311389488 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1933223952 | 0 | 0 | 0 | 5 | 43136544 | |
TlapaleriaMalfoy | Registro | 2777801136 | 4 | 2777801136 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2987668464 | 0 | 0 | 0 | 5 | 35640000 | |
sakila | actor | 2606291952 | 400 | 2606291952 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1296186144 | 0 | 0 | 0 | 5 | 63276576 | |
Table_insertion | ecurie | 2465823888 | 8 | 2465823888 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2476097184 | 0 | 0 | 0 | 5 | 88139568 | |
world | CountryLanguage | 2105576352 | 1968 | 2105576352 | 0 | 0 | 0 | 0 | 0 | 0 | 1970 | 77159 | 1697285040 | 0 | 0 | 0 | 5 | 80877456 | |
sakila | city | 1858461264 | 1251 | 1858461264 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1257909312 | 0 | 0 | 0 | 5 | 39165984 | |
sakila | address | 1837662288 | 1232 | 1837662288 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1454095104 | 0 | 0 | 0 | 5 | 42154464 | |
test19 | ecurie | 1771406208 | 8 | 1771406208 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1892043648 | 0 | 0 | 0 | 5 | 126449136 | |
test19 | pilote | 1766992656 | 60 | 1766992656 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1715062272 | 0 | 0 | 0 | 5 | 87432576 | |
sakila | film_category | 1609088976 | 2002 | 1609088976 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 828830640 | 0 | 0 | 0 | 5 | 30860016 | |
Table_insertion | pilote | 1605005424 | 60 | 1605005424 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1504273584 | 0 | 0 | 0 | 5 | 84614640 | |
world | Country | 1344942192 | 478 | 1344942192 | 0 | 0 | 0 | 0 | 0 | 0 | 480 | 125220 | 1541013936 | 0 | 0 | 0 | 5 | 50295696 | |
Table_insertion | voiture | 1316953440 | 28 | 1316953440 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1290238752 | 0 | 0 | 0 | 5 | 69723456 | |
sakila | country | 1191348048 | 271 | 1191348048 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 937463472 | 0 | 0 | 0 | 5 | 82339488 | |
sakila | category | 1164763776 | 64 | 1164763776 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1337054400 | 0 | 0 | 0 | 5 | 72451632 |
|