…innodb_buffer_pool_instances=16 # MySQL 5.5 and 5.6 loose-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions=8 innodb_buffer_pool…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… the MySQL process using the numactl utility, drop the file cache and pre-allocate the innodb buffer pool with the innodb_buffer_pool_… 21120 2 3 81 13 0 Note the free column going down and the cache one going … look at the Linux settings for the dirty pages. You can either set “vm.dirty_ratio” or “…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…Innodb_buffer_pool_pages_datablogpercona.commanual Innodb_buffer_pool_pages_dirtyblogpercona.commanual Innodb_buffer_pool_pages_flushedblogpercona.commanual Innodb_buffer_pool_pages_freeblogpercona.commanual Innodb_buffer_pool_pages_latchedblogpercona.commanual Innodb_buffer_pool_pages…
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 good post about his… adjustments. You may want to make MySQL to use Large Pages for allocating Innodb Buffer Pool and few other buffers, which may have other performance benefits…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…Innodb_buffer_pool_pages_dirty)/(1+Innodb_buffer_pool_pages_data+Innodb_buffer_pool_pages_free). This is the exact formula that InnoDB uses internally to estimate current innodb_dirty_pages…
Post: What is stored InnoDB buffer pool
September 28, 2008 By 8 Comments
…MySQL 5.0 which show innodb buffer pool content mysql> select * from information_schema.INNODB_BUFFER_POOL…
Comment: When EXPLAIN estimates can go wrong!
October 15, 2011 By 7 Comments
…innodb_buffer_pool_pages | Innodb_buffer_pool_pages_data | 141 | | Innodb_buffer_pool_pages_dirty | 0 | | Innodb_buffer_pool_pages_flushed | 0 | | Innodb_buffer_pool_pages_free | 10098 | | Innodb_buffer_pool_pages_misc | 0 | | Innodb_buffer_pool_pages…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… what MySQL InnoDB tuning should apply. The LRU list is used when InnoDB tries to read data from disk, but there are no free pages… flushing is used. There is a variable in SHOW STATUS, innodb_buffer_pool_pages_flushed, but it shows the sum of flushing from both… 5.5, I added the SHOW STATUS variable innodb_buffer_pool_pages_LRU_flushed, which shows only pages flushed by the LRU list. So, let…
Post: InnoDB memory allocation, ulimit, and OpenSUSE
August 23, 2010 By 7 Comments
… comments in the code (InnoDB code actually has very good comments), max_size is the maximum number of buffer pool pages (16K each), n… proper innodb_buffer_pool_size estimations when the system has a lot of RAM and you want to have the largest possible innodb_buffer_pool_size… for a 76 GB buffer pool. Even with the extra 3.37 GB allocation, there was still some free memory. Or was there…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… Innodb stats: mysql> select * from information_schema.innodb_buffer_pool_stats\G *************************** 1. row *************************** POOL_ID: 0 POOL_SIZE: 8191 FREE_BUFFERS: 1024 DATABASE_PAGES: 7162 OLD_DATABASE_PAGES: 2623 MODIFIED_DATABASE_PAGES… the buffer pool. mysql> select * from information_schema.innodb_buffer_pool_stats\G *************************** 1. row *************************** POOL_ID: 0 POOL_SIZE: 8192 FREE_BUFFERS: 1024 DATABASE_PAGES: 7163 OLD_DATABASE_PAGES: 2624 MODIFIED_DATABASE_PAGES…
