June 18, 2013

Post: Aligning IO on a hard disk RAID – the Benchmarks

buffers. Buffers would be flushed within first few seconds so the effectsto make sure caches were clean. OLTP benchmark As the goal was to compare performance with different IO alignment, not different MySQL configurations

Post: How Percona does a MySQL Performance Audit

how fast they are. I can also get information about the all-important battery-backed write cache, how it’s configuredwhere there’s quicksand to be avoided. The changes Percona’s performance audits typically suggest can be really significant, and can completely change the performance

Post: How much overhead DRDB could cause ?

can be well below 10% The problem is however such configuration will likely have extremely poor performanceRAID card or something which has same effect, especially as it become pretty cheap these days. With good RAID as I benchmarked you canwhere this overhead comes from so you can find how

Post: Living with backups

buffers only toRAID configurations, the performance gains are quite clear. Now going back to flushing the data out of the cachewhere would we be without one-liners) On Linux there is also a utility called ionice. It allows to affect how