Author - Yasufumi Kinoshita

Tuning for heavy writing workloads

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

Adaptive checkpointing

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 buffer […]

Read more