… as soon as possible. An example configuration tuning flow control in a master/slave cluster … node, or perhaps the effect of some large transaction briefly stalling an applier thread. However,… however keep the certification index smaller in memory. It keeps the certification interval small, which …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… 1), or work around it with by fsyncing to memory (Battery or capacitor-backed write cache), etc., but … to several hundred. This really will open a large window where rows won’t be able to… you can update much faster. I see this tuning very frequently for “performance” reasons when data durability …
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… Parsing and optimization needs memory. This is usually small to be ignored but certain queries can have very large memory requrement for this step, especially specially crafted ones. Stored Procedures. Compex stored procedures may require a lot of memory Prepared… of memory. Storage Engines. In general storage engines may have their own per thread or global memory allocations which are not tuned as…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… lower but still at least 16-32Mb so it is large enough to accommodate indexes for temporary tables which are created… so it is large enough to keep most of your tables open. It uses some OS resources and some memory but for… have 64GB of memory to waste. Furthermore doing so may decrease performance. I normally leave per session variable tuning to second step…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
… generally hear about read_buffer_size tuning ? If you want fast full table scans for large table you should set this variable to some high value. Sample my.cnf values on large memory sizes recommend 1M settings and MySQL built-in default is 128K. Some people having a lot of memory and…
Comment: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… for most MySQL High Availability needs. The reasons are: – Bad memory or MySQL Bugs on Primary can corrupt storage… which will… DRBD – Long switch time even for Innodb tables – on large system tuned for performance filesystem recovery from journal and Innodb recovery can…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… tuning” or prefer to expose tuning options to be available to the user. HT: I favor self tuning. PZ: I also like self tuning… may have problems on Linux if you lock very large portion of physical memory. There is also third alternative – “huge pages” which…€™re considering buying 40 8-core boxes with 32G of memory. Have any specific thoughts here? INNODB was originally written on…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…started to come around. There are even tuning utilities (anti-tuning anti-utilities?) for Oracle, specifically designed … the index blocks that are frequently used. How large is that? This is yet another thing …and forget it. If you have enough memory, who cares. The memory isn’t allocated until it’s …
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… course depend on the workload. Hardware If you have large Innodb database size Memory is paramount. 16G-32G is the cost efficient… options here or read one of our MySQL Presentations. Application tuning for Innodb Especially when coming from MyISAM background there would… it in joins), large unpacked indexes (try to be easy on indexes). With these basic innodb performance tunings you will be better…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… Buffer Pool. This of course assumes your database is large so you need large buffer pool, if not – setting buffer pool a… like innodb additional memory pool (which can grow more than memory you allocated for it, especially in case you have large amount of… in case of memory pressure. But what is more important Innodb algorithms are finely tuned with consideration what is in memory and what…
