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 | 32119 | 94759039056 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 13753776432 | 0 | 0 | 0 | 5 | 19543920 | 1048576 | 843056 | 205520 | 64 | 60 | 60 | 11041 | |
sakila | rental | 41528 | 21609180912 | 0 | 0 | 0 | 0 | 0 | 0 | 70 | 1196032 | 11467573392 | 0 | 0 | 0 | 5 | 36310560 | 1097728 | 897591 | 200137 | 67 | 16 | 63 | 11221 | |
sakila | film | 2176 | 9235812960 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 7814926416 | 0 | 0 | 0 | 5 | 39621120 | 212992 | 155213 | 57779 | 13 | 11 | 12 | 1006 | |
db_php5397 | book | 345 | 6763315152 | 1382 | 1279486032 | 0 | 0 | 0 | 0 | 692 | 28902 | 4249755312 | 1394 | 150341 | 1111088352 | 364 | 329492592 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | inventory | 11190 | 7569771264 | 0 | 0 | 0 | 0 | 0 | 0 | 19 | 360448 | 5268854448 | 0 | 0 | 0 | 5 | 38193936 | 262144 | 174254 | 87890 | 16 | 0 | 13 | 4588 | |
world | Country | 55 | 5416443648 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 13512 | 3760159392 | 0 | 0 | 0 | 9 | 83290944 | 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 | 32 | 4851563904 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4488837408 | 0 | 0 | 0 | 5 | 34097712 | 16384 | 264 | 16120 | 1 | 0 | 0 | 6 | |
sakila | staff | 113 | 4763908512 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 4496450112 | 0 | 0 | 0 | 5 | 31234896 | 32768 | 267 | 32501 | 2 | 0 | 0 | 2 | |
sakila | film_category | 2058 | 4438032720 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 4254052704 | 0 | 0 | 0 | 5 | 36624192 | 81920 | 33036 | 48884 | 5 | 0 | 5 | 1002 | |
sakila | country | 207 | 4131860304 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3662884368 | 0 | 0 | 0 | 5 | 53242992 | 16384 | 3739 | 12645 | 1 | 0 | 0 | 110 | |
sakila | category | 76 | 3980085120 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3947098320 | 0 | 0 | 0 | 5 | 42012960 | 16384 | 487 | 15897 | 1 | 0 | 1 | 16 | |
sakila | city | 52 | 3400360128 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4590763584 | 0 | 0 | 0 | 5 | 43130208 | 65536 | 26640 | 38896 | 4 | 0 | 1 | 601 | |
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 | 8 | 69457872 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | customer | 378 | 2045962512 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1644869952 | 0 | 0 | 0 | 5 | 35673264 | 98304 | 53205 | 45099 | 6 | 0 | 1 | 601 | |
sakila | address | 79 | 1724217792 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1938124848 | 0 | 0 | 0 | 5 | 35232384 | 81920 | 46431 | 35489 | 5 | 0 | 5 | 607 | |
sys | sys_config | 45 | 1417440816 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 773030544 | 0 | 0 | 0 | 5 | 43015632 | 16384 | 338 | 16046 | 1 | 0 | 0 | 6 | |
sakila | store | 9 | 744490560 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 988458768 | 0 | 0 | 0 | 5 | 37936800 | 32768 | 66 | 32702 | 2 | 0 | 1 | 2 | |
sakila | actor | 56 | 540081168 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1326697152 | 0 | 0 | 0 | 5 | 35362272 | 32768 | 10353 | 22415 | 2 | 0 | 0 | 200 | |
Продуктовый магазин | Товары | 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 | 10 | 207024576 | 1 | 33035904 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 944842272 | 7 | 61554250560 | 16384 | 40 | 16344 | 1 | 0 | 1 | 1 | |
test19 | pilote | 26 | 38569344 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 879827520 | 0 | 0 | 0 | 5 | 36859680 | 16384 | 1119 | 15265 | 1 | 0 | 1 | 30 | |
cmru66141115 | cmru66141115 | 31 | 18165312 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 385 | 9272208 | 9 | 361 | 19508016 | 22 | 137314848 | 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 | 1671168 | 1223689 | 447479 | 102 | 73 | 4 | 4401 |
|