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 | 156102540000 | 165002 | 156102540000 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 2516756352 | 0 | 0 | 0 | 5 | 36203376 | |
sakila | film | 84119671680 | 154179 | 84119671680 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3443834592 | 0 | 0 | 0 | 5 | 42005568 | |
sakila | payment | 78476403984 | 32088 | 78476403984 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 1114112 | 12383463840 | 0 | 0 | 0 | 5 | 19998528 | |
Table_insertion | voiture | 39576216240 | 51 | 39576216240 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 39259931568 | 0 | 0 | 0 | 5 | 94807152 | |
sakila | film_actor | 37422807312 | 165202 | 37422807312 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 6334920768 | 0 | 0 | 0 | 5 | 86900880 | |
sakila | rental | 21526301808 | 41252 | 21526301808 | 0 | 0 | 0 | 0 | 0 | 0 | 22 | 409600 | 7538609232 | 0 | 0 | 0 | 5 | 21048192 | |
sakila | category | 6527963904 | 5137 | 6527963904 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3936293856 | 0 | 0 | 0 | 5 | 44311872 | |
sakila | inventory | 6170847936 | 9192 | 6170847936 | 0 | 0 | 0 | 0 | 0 | 0 | 23 | 425984 | 5588588544 | 0 | 0 | 0 | 5 | 44659824 | |
sakila | customer | 4207260816 | 651 | 4207260816 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 3536095728 | 0 | 0 | 0 | 5 | 21136368 | |
sakila | country | 3937837728 | 179 | 3937837728 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3952441680 | 0 | 0 | 0 | 5 | 40432656 | |
sakila | store | 3936969168 | 8 | 3936969168 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4051643904 | 0 | 0 | 0 | 5 | 36721344 | |
sakila | actor | 2549704080 | 202 | 2549704080 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2887849536 | 0 | 0 | 0 | 5 | 53504880 | |
sakila | staff | 2388420672 | 6 | 2388420672 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2513902512 | 0 | 0 | 0 | 5 | 32964624 | |
sakila | address | 2221364640 | 1287 | 2221364640 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1516360032 | 0 | 0 | 0 | 5 | 20373936 | |
sakila | language | 1335890160 | 77 | 1335890160 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 927132624 | 0 | 0 | 0 | 5 | 46382688 | |
sakila | city | 1327083120 | 751 | 1327083120 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1223912448 | 0 | 0 | 0 | 5 | 21679152 | |
Table_insertion | ecurie | 863346528 | 31 | 863346528 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 836765952 | 0 | 0 | 0 | 5 | 38909376 | |
test19 | voiture | 688259616 | 2 | 688259616 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 758663664 | 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 | |
world | City | 39783216 | 2 | 39783216 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 272030352 | 0 | 0 | 0 | 6 | 28999344 | |
mysql | dd_properties | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | schemata | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespace_files | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespaces | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | check_constraints | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|