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 | 324614872560 | 330054 | 324614872560 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 2053884624 | 0 | 0 | 0 | 5 | 34856448 | |
sakila | film | 190287938016 | 320274 | 190287938016 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2601603312 | 0 | 0 | 0 | 5 | 42022992 | |
sys | sys_config | 124013489424 | 16 | 124013489424 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2349502320 | 0 | 0 | 0 | 5 | 56402544 | |
sakila | payment | 82837357152 | 32096 | 82837357152 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 9826161840 | 0 | 0 | 0 | 5 | 53310048 | |
sakila | film_actor | 67369586592 | 330400 | 67369586592 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1755453216 | 0 | 0 | 0 | 5 | 54967968 | |
sakila | rental | 24711798672 | 41356 | 24711798672 | 0 | 0 | 0 | 0 | 0 | 0 | 70 | 1196032 | 14096857632 | 0 | 0 | 0 | 5 | 39812256 | |
sakila | category | 7037672400 | 10327 | 7037672400 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 881699808 | 0 | 0 | 0 | 5 | 42344544 | |
sakila | inventory | 6194280576 | 9301 | 6194280576 | 0 | 0 | 0 | 0 | 0 | 0 | 23 | 425984 | 6923878368 | 0 | 0 | 0 | 5 | 60358848 | |
sakila | address | 5178178896 | 4279 | 5178178896 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1115218368 | 0 | 0 | 0 | 5 | 39257328 | |
vedettfak | megye | 4396830240 | 15 | 4396830240 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4433751696 | 0 | 0 | 0 | 5 | 56144880 | |
sakila | staff | 3867932640 | 22 | 3867932640 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 3802790112 | 0 | 0 | 0 | 5 | 42480240 | |
Table_insertion | voiture | 3829265088 | 34 | 3829265088 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 3931927296 | 0 | 0 | 0 | 5 | 35365440 | |
sakila | customer | 3688130160 | 4033 | 3688130160 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 979586256 | 0 | 0 | 0 | 5 | 20816928 | |
sku | Attore | 3146211552 | 14 | 3146211552 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 884406864 | 0 | 0 | 0 | 5 | 42612768 | |
test19 | ecurie | 3092548272 | 22 | 3092548272 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 900278016 | 0 | 0 | 0 | 5 | 2407622976 | |
world | City | 2363323248 | 14 | 2363323248 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 459 | 2421720576 | 0 | 0 | 0 | 10 | 71252016 | |
sakila | language | 2324540592 | 234 | 2324540592 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 811126272 | 0 | 0 | 0 | 5 | 42085296 | |
sakila | city | 2187162912 | 451 | 2187162912 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 866887296 | 0 | 0 | 0 | 5 | 33481536 | |
sakila | film_text | 2052648576 | 8 | 2052648576 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 442 | 623621856 | 0 | 0 | 0 | 12 | 87888240 | |
sakila | country | 1504070304 | 207 | 1504070304 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 706773408 | 0 | 0 | 0 | 5 | 37847040 | |
Table_insertion | ecurie | 1190751408 | 33 | 1190751408 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1235405952 | 0 | 0 | 0 | 5 | 36036000 | |
test19 | voiture | 927498528 | 12 | 927498528 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 950563680 | 0 | 0 | 0 | 5 | 62420688 | |
Stefano | vulcano | 825704880 | 12 | 825704880 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 875045424 | 0 | 0 | 0 | 5 | 47993088 | |
vedettfak | fa | 813584112 | 4 | 813584112 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1044423072 | 0 | 0 | 0 | 5 | 58661856 | |
test19 | pilote | 769417968 | 6 | 769417968 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 907122480 | 0 | 0 | 0 | 5 | 49308336 |
|