May 23, 2012

Post: Impact of logging on MySQL’s performance

… error was calculated. As it is seen from the chart above the performance almost doesn’t depend on logging – the difference… from performance degradation caused by the microslow patch itself. Let’s do the same tests but logging to /dev/null. CPU-bound… bigger than a second without worry about performance impact in case of CPU-bound workload. The performance impact is negligibly small in IO…

Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage

…:mysql:start, here are my thoughts and interesting facts. First, chart with results for InnoDB vs InnoDB-plugin during runs (values… InnoDB-plugin. Now on CPU usage and disk utilization. Disk throughput: CPU (user) usage: Even with improvements, XtraDB performs less 150MB/s in… more can be done. Still you can have very impressive performance improvement in IO-intensive or IO-bound workloads. You may…

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

… | 24×1600.000 Models | 24xIntel(R) Xeon(R) CPU X5650 @ 2.67GHz Caches | 24×12288 KB # Memory … I decided that instead of preparing charts for each benchmark, I’ll just… performance improvement is marginal however WB cache brings single thread random write performance close…

Comment: Tools

… _the_ tool for analyzing I/O activity (cause, performances, kernel paths, …) on Linux. – iogrind : another I/O…and efficient to answer questions like “why (io, cpu,…) did the system was slow two days …can be re-used to draw nice graphes/charts) – ethtool/mii-tool : to check running features and…