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 | 32148 | 94843360656 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 13753776432 | 0 | 0 | 0 | 5 | 19543920 | 1048576 | 843056 | 205520 | 64 | 60 | 60 | 11041 | |
sakila | rental | 41754 | 21729957216 | 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 | 27 | 5341781808 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 5311749168 | 0 | 0 | 0 | 5 | 130564896 | 16384 | 655 | 15729 | 1 | 0 | 0 | 19 | |
sakila | staff | 171 | 5139965424 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 4496450112 | 0 | 0 | 0 | 5 | 31234896 | 32768 | 267 | 32501 | 2 | 1 | 0 | 2 | |
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 | 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 | 261 | 4397859312 | 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 | 103 | 3734300064 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4590763584 | 0 | 0 | 0 | 5 | 43130208 | 65536 | 26640 | 38896 | 4 | 0 | 0 | 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 | |
sakila | customer | 628 | 2540196384 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1644869952 | 0 | 0 | 0 | 5 | 35673264 | 98304 | 53205 | 45099 | 6 | 4 | 0 | 601 | |
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 | address | 105 | 2184770016 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2315118960 | 0 | 0 | 0 | 5 | 35232384 | 98304 | 51858 | 46446 | 6 | 0 | 4 | 605 | |
sys | sys_config | 51 | 1534498944 | 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 | |
sms_1 | student_info | 2 | 32114016 | 2 | 107061504 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 294912 | 4815134544 | 9 | 99311153568 | 49152 | 119 | 49033 | 3 | 0 | 0 | 2 | |
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 | 33 | 19242960 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 385 | 9272208 | 9 | 361 | 19508016 | 24 | 143707872 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|