… soon as possible. An example configuration tuning flow control in a master/slave cluster might be: mysql> set global wsrep_provider_options… fc_limit does however keep the certification index smaller in memory. It keeps the certification interval small, which minimizes replication conflicts…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… states is then a matter of copying a relatively small memory block which, depending on many factors, can be from few… to the following kinds of transactions: MySQL transactions started with START TRANSACTION READ ONLY MySQL transactions created by a non-locking SELECT… the alpha stage. We are going to blog about other MySQL performance improvements introduced in our latest Percona Server release, stay tuned.
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… or work around it with by fsyncing to memory (Battery or capacitor-backed write cache), etc… MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication… update much faster. I see this tuning very frequently for “performance” reasons when …
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… some benchmarks for the use case where the MySQL working set is significantly larger than the InnoDB …a separate kernel module in addition to whatever flash memory driver you’ve already had to install, and …proc, I’d vote in the other direction. Stay tuned for part two of this series, wherein we’…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… buffers. This is memory which you can consider used when you just start MySQL Server. The rest of memory is available for connections… aux” to see VSZ – Virtual Memory allocated by MySQL process. You can also look at “Resident Memory” but I find it less helpful… global memory allocations which are not tuned as buffers. Watch for these especially now with many storage engines being released for MySQL by…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… which appeared in MySQL 4.0 Query Cache was designed to work with single core systems and relatively small memory amounts, both…. Query Cache Storage Engines MySQL Query Cache now stores queries in local memory, which is great however memory amount might be limited especially… be done by external script which can have application-specific tunings to prioritize which queries are more important to refresh for…
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
… be doing fine tuning for our Percona Server for MySQL version 5.6 release. Another thing to remember about MySQL 5.6 is… small (1M rows) benchmark so data was well fitting in memory and Read Only one to simplify things and get more…. Granted I have not tuned MySQL 5.6 for best performance going with defaults outside of few variables MySQL Sandbox sets explicitly but…
Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown
March 14, 2013 By 2 Comments
… workings of one of the nicest features of the newer MySQL optimizer: the Index Condition Pushdown Optimization, or ICP, which we… memory). Also, I was testing, as I said before, index condition pushdown. Let’s have a look at the EXPLAIN output: mysql… query faster, which means you need more manual care and tuning now. MySQL is conservative about “Using index” -in most cases it…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE_PER_TABLE | OFF | ON | | SYNC… 4MB instead of 1MB now allowing MySQL to handle larger queries. Makes sense as amount of memory available is much larger these… I guess is one of the component of purging fine tuning in MySQL 5.6 innodb_file_per_table is now ON…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…. I claim that somewhere around of 99% of advice about tuning MySQL‘s key cache hit ratio is wrong, even when you… a long time before the MySQL world started to come around. There are even tuning utilities (anti-tuning anti-utilities?) for Oracle, specifically… really big and forget it. If you have enough memory, who cares. The memory isn’t allocated until it’s used — if…
