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 | 393420988752 | 330000 | 393420988752 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 841682688 | 0 | 0 | 0 | 5 | 16383840 | |
sakila | film | 216445026336 | 310021 | 216445026336 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1567634112 | 0 | 0 | 0 | 5 | 35633664 | |
sakila | film_actor | 86929213536 | 330400 | 86929213536 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1556154336 | 0 | 0 | 0 | 5 | 21601536 | |
sakila | category | 9534580704 | 10273 | 9534580704 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1923143904 | 0 | 0 | 0 | 5 | 40099488 | |
vedettfak | fa | 4851595056 | 22 | 4851595056 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 4972466928 | 0 | 0 | 0 | 5 | 1855748928 | |
sakila | rental | 3541082160 | 5 | 3541082160 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 3531890208 | 0 | 0 | 0 | 5 | 35634720 | |
sakila | customer | 3427897440 | 229 | 3427897440 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 5679102528 | 0 | 0 | 0 | 5 | 36520176 | |
sakila | country | 2385306528 | 53 | 2385306528 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2211568656 | 0 | 0 | 0 | 5 | 77868912 | |
sakila | actor | 1771417296 | 402 | 1771417296 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1562494032 | 0 | 0 | 0 | 5 | 147802512 | |
sakila | address | 1717652112 | 29 | 1717652112 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 1697844192 | 0 | 0 | 0 | 5 | 33517968 | |
vedettfak | megye | 1649142000 | 137 | 1649142000 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1151764944 | 0 | 0 | 0 | 5 | 64393824 | |
sakila | payment | 1269131424 | 2 | 1269131424 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1379407392 | 0 | 0 | 0 | 5 | 31972512 | |
sakila | inventory | 1235510496 | 203 | 1235510496 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1223707056 | 0 | 0 | 0 | 5 | 40660224 | |
sakila | city | 1019293440 | 26 | 1019293440 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1350243312 | 0 | 0 | 0 | 5 | 44117568 | |
sakila | language | 1013789040 | 53 | 1013789040 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 768231552 | 0 | 0 | 0 | 5 | 50611440 | |
sakila | staff | 826864896 | 8 | 826864896 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 913586256 | 0 | 0 | 0 | 5 | 40827072 | |
sakila | store | 808737072 | 8 | 808737072 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 874025856 | 0 | 0 | 0 | 5 | 41371440 | |
test19 | pilote | 775552800 | 2 | 775552800 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 858310992 | 0 | 0 | 0 | 5 | 60099600 | |
sys | sys_config | 758095536 | 3 | 758095536 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 717625392 | 0 | 0 | 0 | 5 | 245876928 | |
Stefano | vulcano | 720962352 | 3 | 720962352 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 953757024 | 0 | 0 | 0 | 5 | 37147968 | |
test19 | ecurie | 666669696 | 2 | 666669696 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 932325504 | 0 | 0 | 0 | 5 | 48162048 | |
test19 | voiture | 545466768 | 4 | 545466768 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 780604704 | 0 | 0 | 0 | 5 | 32219088 | |
sakila | film_text | 491777616 | 1 | 491777616 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 442 | 946722480 | 0 | 0 | 0 | 4 | 23726208 | |
world | Country | 46018368 | 2 | 46018368 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 723900672 | 0 | 0 | 0 | 5 | 12692774688 | |
mysql | dd_properties | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|