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 | 624533671344 | 660005 | 624533671344 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 2516756352 | 0 | 0 | 0 | 5 | 36203376 | |
sakila | film | 347385826656 | 616709 | 347385826656 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3443834592 | 0 | 0 | 0 | 5 | 42005568 | |
sakila | film_actor | 131879251680 | 660828 | 131879251680 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 6334920768 | 0 | 0 | 0 | 5 | 86900880 | |
sakila | payment | 78476403984 | 32088 | 78476403984 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 1114112 | 12383463840 | 0 | 0 | 0 | 5 | 19998528 | |
Table_insertion | voiture | 41595096576 | 110 | 41595096576 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 39259931568 | 0 | 0 | 0 | 5 | 94807152 | |
sakila | rental | 21526301808 | 41252 | 21526301808 | 0 | 0 | 0 | 0 | 0 | 0 | 22 | 409600 | 7538609232 | 0 | 0 | 0 | 5 | 21048192 | |
sakila | category | 14938835472 | 20609 | 14938835472 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3936293856 | 0 | 0 | 0 | 5 | 44311872 | |
sakila | inventory | 6213163440 | 9218 | 6213163440 | 0 | 0 | 0 | 0 | 0 | 0 | 23 | 425984 | 5588588544 | 0 | 0 | 0 | 5 | 44659824 | |
sakila | customer | 4314828144 | 679 | 4314828144 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 3536095728 | 0 | 0 | 0 | 5 | 21136368 | |
test1998 | secondary_table | 4113580416 | 0 | 0 | 2 | 4113580416 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 144384768 | 7 | 92546605536 | |
sakila | country | 4017130128 | 231 | 4017130128 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3952441680 | 0 | 0 | 0 | 5 | 40432656 | |
sakila | store | 3970373088 | 16 | 3970373088 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4051643904 | 0 | 0 | 0 | 5 | 36721344 | |
sakila | actor | 3762033264 | 830 | 3762033264 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2887849536 | 0 | 0 | 0 | 5 | 53504880 | |
sakila | staff | 3655612224 | 11 | 3655612224 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3614028000 | 0 | 0 | 0 | 5 | 32964624 | |
sakila | address | 2501508240 | 1538 | 2501508240 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1516360032 | 0 | 0 | 0 | 5 | 20373936 | |
sakila | city | 1653552912 | 777 | 1653552912 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1223912448 | 0 | 0 | 0 | 5 | 21679152 | |
sakila | language | 1645282320 | 127 | 1645282320 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 927132624 | 0 | 0 | 0 | 5 | 46382688 | |
Table_insertion | ecurie | 971235408 | 53 | 971235408 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 836765952 | 0 | 0 | 0 | 5 | 38909376 | |
sku | Attore | 760841136 | 1 | 760841136 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 869754336 | 0 | 0 | 0 | 5 | 35661120 | |
test19 | voiture | 688259616 | 2 | 688259616 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 987277632 | 0 | 0 | 0 | 5 | 193786032 | |
sys | sys_config | 685528800 | 1 | 685528800 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 869457072 | 0 | 0 | 0 | 5 | 42200928 | |
abidal | secondary_table | 324706272 | 6 | 89432640 | 2 | 235273632 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 439868352 | 7 | 68208137184 | |
vedettfak | fa | 99764016 | 2 | 99764016 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 1790535648 | 0 | 0 | 0 | 5 | 44406384 | |
abidal | primary_table | 48344736 | 1 | 18870720 | 1 | 29474016 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 215115648 | 6 | 51079206816 | |
world | CountryLanguage | 40131696 | 2 | 40131696 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 407 | 612312096 | 0 | 0 | 0 | 4 | 27014592 |
|