… of pages free, it probably means your active database size is smaller than allocated buffer pool size so you can tune it down. Even if free pages is zero as in this case database pages will not…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…even…If the page is touched again while on the cold portion, it is…zero), which means that pages…FREE_BUFFERS: 1024 * FREE_BUFFERS: 1024 DATABASE_PAGES: 7163 * DATABASE_PAGES: 7162 OLD_DATABASE_PAGES: 2624 * OLD_DATABASE_PAGES: 2623 MODIFIED_DATABASE_PAGES: 0 * MODIFIED_DATABASE_PAGES…) as revenue …
Post: How much space does empty Innodb table take ?
December 16, 2008 By 7 Comments
… as much as 6 pages are required for start ? If we add more indexes to this tables – each further index will take additional 16K page even if it contains no data. This is understandable – each index has to have at least one page allocated to it. Now it is…_table mode is interesting question on its own. As we populate table we will see Free space will remain at zero as Data_length is small…
Post: Bug#12704861
November 20, 2011 By 1 Comment
…went digging. Even though…bug as it is …zeroed out). btr_page_alloc_low(): Refactored from btr_page_alloc(). Return the number of the allocated page, or FIL_NULL if…pages. btr_page_free(): Assert that the page is a B-tree page and it has been X-latched by the mini-transaction. If the freed page…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… play on the safe side, having enough “free” memory used as Cache and Buffers. Kevin Burton wrote a… zero on Linux. Couple of swaps per minute would not hurt bad but if you’re doing 100+ pages… fetch page data swapped out. This is very wrong thinking. First OS would have to swap even clean page from…
