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 | language | 7950453984 | 128 | 7950453984 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4876901040 | 0 | 0 | 0 | 5 | 140703552 | |
sakila | store | 6350604480 | 5 | 6350604480 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 6372879216 | 0 | 0 | 0 | 5 | 65175792 | |
sakila | rental | 4702014768 | 6 | 4702014768 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4688597760 | 0 | 0 | 0 | 5 | 37108896 | |
sakila | film | 4567357344 | 155 | 4567357344 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4152780720 | 0 | 0 | 0 | 5 | 48163104 | |
test19 | ecurie | 4166708304 | 6 | 4166708304 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4478889360 | 0 | 0 | 0 | 5 | 45939168 | |
sakila | inventory | 3850462176 | 128 | 3850462176 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 6357197616 | 0 | 0 | 0 | 5 | 95446560 | |
sakila | category | 3727407024 | 3 | 3727407024 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3855314496 | 0 | 0 | 0 | 5 | 41468064 | |
sakila | staff | 2319101664 | 8 | 2319101664 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2201114784 | 0 | 0 | 0 | 5 | 86804256 | |
sys | sys_config | 1848909744 | 11 | 1848909744 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1818251952 | 0 | 0 | 0 | 5 | 106764240 | |
sakila | customer | 1686700752 | 210 | 1686700752 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 1229166048 | 0 | 0 | 0 | 5 | 22717200 | |
sakila | address | 1621483248 | 189 | 1621483248 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1399261248 | 0 | 0 | 0 | 5 | 20868672 | |
sakila | country | 1381299216 | 191 | 1381299216 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 716856096 | 0 | 0 | 0 | 5 | 34585584 | |
sku | Attore | 1147010304 | 7 | 1147010304 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1424293200 | 0 | 0 | 0 | 5 | 33077088 | |
sakila | city | 1040374368 | 160 | 1040374368 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 893886048 | 0 | 0 | 0 | 5 | 20287344 | |
sakila | payment | 999589008 | 4 | 999589008 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1081697232 | 0 | 0 | 0 | 5 | 33168432 | |
test19 | pilote | 849004992 | 6 | 849004992 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1123628880 | 0 | 0 | 0 | 5 | 47741760 | |
test19 | voiture | 803016720 | 2 | 803016720 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1027611552 | 0 | 0 | 0 | 5 | 48545904 | |
world | Country | 501428928 | 32 | 501428928 | 0 | 0 | 0 | 0 | 0 | 0 | 27 | 6987 | 1174955232 | 0 | 0 | 0 | 7 | 72353424 | |
world | City | 395874864 | 7 | 395874864 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 459 | 2432858208 | 0 | 0 | 0 | 7 | 44598048 | |
sakila | film_text | 175764864 | 3 | 175764864 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 442 | 728534400 | 0 | 0 | 0 | 9 | 52446240 | |
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 |
|