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 | 836358640128 | 990062 | 836358640128 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1624870896 | 0 | 0 | 0 | 5 | 31797216 | |
sakila | film | 469898196240 | 924532 | 469898196240 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1785681744 | 0 | 0 | 0 | 5 | 41565216 | |
sakila | film_actor | 171649512144 | 991200 | 171649512144 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1576949616 | 0 | 0 | 0 | 5 | 50259792 | |
sakila | category | 17055980304 | 30877 | 17055980304 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1734552336 | 0 | 0 | 0 | 5 | 92260608 | |
sys | sys_config | 16633680096 | 6 | 16633680096 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2281697088 | 0 | 0 | 0 | 5 | 323067360 | |
sakila | address | 2196434064 | 122 | 2196434064 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3127016112 | 0 | 0 | 0 | 5 | 38788464 | |
sakila | staff | 2012373264 | 6 | 2012373264 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2832702048 | 0 | 0 | 0 | 5 | 28703136 | |
sakila | payment | 1081675584 | 1 | 1081675584 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 7752177840 | 0 | 0 | 0 | 5 | 30846816 | |
sakila | rental | 950851440 | 1 | 950851440 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 6954461712 | 0 | 0 | 0 | 5 | 36938880 | |
sakila | actor | 944718192 | 1226 | 944718192 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1298226336 | 0 | 0 | 0 | 5 | 39992304 | |
sakila | customer | 920374224 | 62 | 920374224 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1656041904 | 0 | 0 | 0 | 5 | 31705872 | |
test19 | pilote | 901095360 | 1 | 901095360 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1000779120 | 0 | 0 | 0 | 5 | 42773808 | |
test19 | ecurie | 771858912 | 1 | 771858912 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1038944016 | 0 | 0 | 0 | 5 | 50307840 | |
test19 | voiture | 693323136 | 1 | 693323136 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 970954512 | 0 | 0 | 0 | 5 | 47315136 | |
sakila | city | 668682432 | 136 | 668682432 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1463260656 | 0 | 0 | 0 | 5 | 31627200 | |
world | CountryLanguage | 583403568 | 62 | 583403568 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 2357 | 1072560192 | 0 | 0 | 0 | 11 | 98370096 | |
sakila | country | 501012864 | 84 | 501012864 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 812694432 | 0 | 0 | 0 | 5 | 26552592 | |
sakila | store | 366226080 | 3 | 366226080 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1227249936 | 0 | 0 | 0 | 5 | 27817152 | |
sakila | language | 179977248 | 25 | 179977248 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 750381456 | 0 | 0 | 0 | 5 | 71783184 | |
world | Country | 39868752 | 1 | 39868752 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 332575056 | 0 | 0 | 0 | 4 | 19524384 | |
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 |
|