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 | 39729950832 | 75 | 39729950832 | 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 | 6564048480 | 5140 | 6564048480 | 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 | 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 | 3973868448 | 205 | 3973868448 | 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 | staff | 3603767904 | 9 | 3603767904 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3614028000 | 0 | 0 | 0 | 5 | 32964624 | |
sakila | actor | 2574182688 | 204 | 2574182688 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2887849536 | 0 | 0 | 0 | 5 | 53504880 | |
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 | 1335890160 | 77 | 1335890160 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 927132624 | 0 | 0 | 0 | 5 | 46382688 | |
Table_insertion | ecurie | 948168144 | 45 | 948168144 | 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 | 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 | |
world | City | 39783216 | 2 | 39783216 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 272030352 | 0 | 0 | 0 | 6 | 28999344 | |
test1998 | primary_table | 37300032 | 0 | 0 | 1 | 37300032 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 8806107024 | 6 | 77463090672 | |
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 |
|