EmergencyEMERGENCY? Get 24/7 Help Now!

Tuning for heavy writing workloads

 | October 14, 2009 |  Posted In: Benchmarks, Insight for DBAs, MySQL

For the my previous post, there was comment to suggest to test db_STRESS benchmark on XtraDB by Dimitri. And I tested and tuned for the benchmark. I will show you the tunings. It should be also tuning procedure for general heavy writing workloads. At first, <tuning peak performance>. The next, <tuning purge operation> to stabilize […]

Read More

Which adaptive should we use?

 | September 15, 2009 |  Posted In: Benchmarks, Percona Software

As you may know, InnoDB has 2 limits for unflushed modified blocks in the buffer pool. The one is from physical size of the buffer pool. And the another one is oldness of the block which is from the capacity of transaction log files. In the case of heavy updating workload, the modified ages of […]

Read More

Adaptive checkpointing

 | November 13, 2008 |  Posted In: Benchmarks, Percona Software

Do you know that there are two limits about dirty (modified but not flushed to disk) blocks of InnoDB buffer pool? One is the limit of “amount”. The other is the limit of “age”. — limit of “amount” — As you know, buffer pool of InnoDB works as write-back cache of its datafiles. If the […]

Read More