SELECT * FROM `x$schema_table_statistics_with_buffer`
|
table_schema | table_name | 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 | innodb_buffer_allocated | innodb_buffer_data | innodb_buffer_free | innodb_buffer_pages | innodb_buffer_pages_hashed | innodb_buffer_pages_old | innodb_buffer_rows_cached | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sakila | payment | 32088 | 94005920976 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 1114112 | 13167674784 | 0 | 0 | 0 | 5 | 19543920 | 1015808 | 835288 | 180520 | 62 | 60 | 34 | 16079 | |
sakila | rental | 41250 | 19892122800 | 0 | 0 | 0 | 0 | 0 | 0 | 68 | 1163264 | 9998711712 | 0 | 0 | 0 | 5 | 36310560 | 1064960 | 882419 | 182541 | 65 | 16 | 64 | 16076 | |
sakila | film | 2151 | 9115550400 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 7814926416 | 0 | 0 | 0 | 5 | 39621120 | 212992 | 155213 | 57779 | 13 | 11 | 0 | 1006 | |
sakila | inventory | 11164 | 7511163792 | 0 | 0 | 0 | 0 | 0 | 0 | 19 | 360448 | 5268854448 | 0 | 0 | 0 | 5 | 38193936 | 262144 | 174254 | 87890 | 16 | 0 | 14 | 4588 | |
db_php5397 | book | 230 | 4221455568 | 1382 | 1279486032 | 0 | 0 | 0 | 0 | 462 | 19382 | 3810792480 | 1394 | 150341 | 1111088352 | 248 | 255920016 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
vedettfak | megye | 26 | 5330798880 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 5311749168 | 0 | 0 | 0 | 5 | 130564896 | 16384 | 655 | 15729 | 1 | 0 | 1 | 19 | |
sakila | language | 25 | 4819308912 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4488837408 | 0 | 0 | 0 | 5 | 34097712 | 16384 | 264 | 16120 | 1 | 0 | 1 | 6 | |
sakila | film_category | 2058 | 4438032720 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 4254052704 | 0 | 0 | 0 | 5 | 36624192 | 81920 | 33036 | 48884 | 5 | 0 | 4 | 1002 | |
sakila | category | 76 | 3980085120 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3947098320 | 0 | 0 | 0 | 5 | 42012960 | 16384 | 487 | 15897 | 1 | 0 | 0 | 16 | |
sakila | country | 79 | 3682140000 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3662884368 | 0 | 0 | 0 | 5 | 53242992 | 16384 | 3739 | 12645 | 1 | 0 | 1 | 110 | |
world | Country | 26 | 3643893264 | 0 | 0 | 0 | 0 | 0 | 0 | 27 | 6987 | 2066123664 | 0 | 0 | 0 | 6 | 46992000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
db_php5397 | web | 230 | 1078268928 | 1956 | 2178639936 | 0 | 0 | 0 | 0 | 462 | 51655 | 583707168 | 1969 | 342010 | 1871426832 | 248 | 625768176 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
world | CountryLanguage | 26 | 2471122368 | 0 | 0 | 0 | 0 | 0 | 0 | 27 | 1382 | 1614722208 | 0 | 0 | 0 | 7 | 64253376 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | address | 50 | 1490291088 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1938124848 | 0 | 0 | 0 | 5 | 35232384 | 81920 | 46431 | 35489 | 5 | 0 | 3 | 607 | |
sakila | customer | 52 | 1205778816 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1644869952 | 0 | 0 | 0 | 5 | 35673264 | 98304 | 53205 | 45099 | 6 | 0 | 3 | 601 | |
sys | sys_config | 30 | 1134054768 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 773030544 | 0 | 0 | 0 | 5 | 43015632 | 16384 | 338 | 16046 | 1 | 0 | 0 | 6 | |
sakila | store | 6 | 705409584 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 988458768 | 0 | 0 | 0 | 5 | 37936800 | 32768 | 66 | 32702 | 2 | 0 | 1 | 2 | |
Продуктовый магазин | Товары | 27 | 188649648 | 2 | 79616064 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
buknoy | students | 5 | 152913024 | 1 | 33035904 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 944842272 | 7 | 61554250560 | 16384 | 40 | 16344 | 1 | 0 | 0 | 1 | |
test19 | pilote | 26 | 38569344 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 879827520 | 0 | 0 | 0 | 5 | 36859680 | 16384 | 1119 | 15265 | 1 | 0 | 0 | 30 | |
cmru66141115 | cmru66141115 | 23 | 13062720 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 385 | 9272208 | 9 | 361 | 19508016 | 21 | 134395008 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1654784 | 1211315 | 443469 | 101 | 70 | 13 | 4344 | |
mysql | help_topic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1146880 | 897120 | 249760 | 70 | 0 | 65 | 665 | |
mysql | tables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 753664 | 537544 | 216120 | 46 | 38 | 0 | 424 | |
mysql | index_column_usage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 294912 | 155942 | 138970 | 18 | 5 | 4 | 1671 |
|