… used: ## InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing… = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer pool is sized…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…Innodb_buffer_pool_read_ahead 1152 23231 130919 23228 130731 131497 Innodb_buffer_pool_read_requests 12947073 10228611 7816154 10251697 9319281 9393396 Innodb_buffer_pool…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…INNODB STATUS and look for memory information block, which can use like this: ———————- BUFFER POOL AND MEMORY ———————- Total memory allocated 132183490560; in additional pool… most likely cause for Innodb run away memory allocation is Dictionary cache though there could be…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…MySQL 5.6 and MariaDB 5.5. Note that query cache is disabled during these benchmark runs and that the disks…Innodb_buffer_pool_read_ahead 0 20920 23669 20920 23734 Innodb_buffer_pool_read_requests 1361851 1264739 1235472 1263290 1235781 Innodb_buffer_pool_reads 120548 102948 76882 102672 76832 Innodb…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
…, and elimination of useless tables in joins Thread pooling and a segmented key cache for improved scalability That’s really just a…, better diagnostics, improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of all, MariaDB 5.5 might be here pretty…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
… Double Buffering – This is again very important for buffer pool size choice. You do not want OS to cache what Innodb is caching already. Innodb cache is more efficient compared to OS cache because…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…: set innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible to InnoDB‘s buffer pool. For this, you need to find a way to tell Linux to keep a small OS file cache. I… Linux File Cache with good results. I just wrote the post on this this matter the other day – choosing innodb_buffer_pool_size Q36…
Post: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 11 Comments
… from the cache. You can use this feature to tune buffer pool invalidation strategy, for example play with innodb_old_blocks_pct and innodb_old_blocks_time actually observing data stored in buffer pool rather…
Post: XtraDB feature: save / restore buffer pool
January 20, 2010 By 19 Comments
…, the release-making feature is ability to save and restore InnoDB buffer pool. The idea is not new and was originally developed by… of buffer pool ? There are several reasons. First, it’s not rate on modern servers to have 32GB+ of RAM, with allocated InnoDB buffer_pool 26GB or more. When you do restart of server, it may take long time to populate cache with useful…
