MySQL Benchmarks: MariaDB 5.2.5 custom CentOS 64bit RPM binaries – Intel optimized
Summary
There was definitely some gains in MyISAM read only performance with custom built MariaDB 5.2.5 RPM packages especially when paired up with DEADLINE linux scheduler and once past 24 cpu cores the gains are much more noticeable. For InnoDB read only performance, Intel optimized RPM dropped to levels inline with Percona 5.5.10-20.1 and MySQL 5.5.11 once past 24 cpu cores while still maintaining a slight lead over Percona 5.5.10-20.1 and MySQL 5.5.11 up to 16 cpu cores even with the drop in performance compared to MariaDB 5.2.5 official and custom ‘generic’ RPMs. MyISAM read only performance difference between the official and custom ‘generic’ RPM was about the same up to 24 cpu cores. Past 24 cpu cores, the custom ‘generic’ RPM was around 4-16% faster than official MariaDB 5.2.5 RPM.
For InnoDB read write tests, Intel optimized RPM fell behind ever so slightly up to 16 cpu cores. But from 24 cpu cores up, the drop in InnoDB read write performance for Intel optimized RPM was much more noticeable falling behind even Percona 5.5.10-20.1 and MySQL 5.5.11.
Basically, for Intel optimized RPM I built, compared to official MariaDB 5.2.5 RPM you’re loosing around 0.5% to 4% of InnoDB read write performance once past 24 cpu cores for a noticeable gain in MyISAM read performance. For MyISAM performance, Intel optimized MariaDB 5.2.5 RPM is up to 32% faster than custom MariaDB 5.2.5 ‘generic’ and up to 44% faster than official MariaDB 5.2.5 RPM
Highlights for MyISAM read only performance:
- MyISAM read only: At 12 cpu cores, Intel optimized RPM package with DEADLINE scheduler was 24% faster than official RPM with same scheduler and 8% faster than official RPM’s best result with CFQ scheduler. Intel optimized RPM was also 33-37% faster than Percona 5.5.10-20.1 and 48-79% faster than MySQL 5.5.11.
- MyISAM read only: At 16 cpu cores, Intel optimized RPM’s lead grows to 40% faster than official RPM and nearly 29% faster than ‘generic’ custom RPM. Intel optimized RPM was also 65% faster than Percona 5.5.10-20.1 and 82% faster than MySQL 5.5.11.
- MyISAM read only: At 24 cpu cores, Intel optimized RPM was ~44% faster than official RPM with same DEADLINE scheduler and ~32% faster than custom RPM’s best with NOOP scheduler. Intel optimized RPM was also 50-57% faster than Percona 5.5.10-20.1 and 67-103% faster than MySQL 5.5.11.
- MyISAM read only: At 32 cpu cores, Intel optimized RPM was ~32% faster than official RPM with same DEADLINE scheduler and ~25% faster than custom RPM’s best with NOOP scheduler. Intel optimized RPM was also 33-37% faster than Percona 5.5.10-20.1 and 49-139% faster than MySQL 5.5.11.
- MyISAM read only: At 48 cpu threads, Intel optimized RPM was ~21.5% faster than official RPM with same DEADLINE scheduler and ~8.5% faster than custom RPM’s best with NOOP scheduler. Intel optimized RPM was also 10-15% faster than Percona 5.5.10-20.1 and 20-104% faster than MySQL 5.5.11.
- MyISAM read only: At 64 cpu threads, Intel optimized RPM was ~19% faster than official RPM with same DEADLINE scheduler and ~1.8% faster than custom RPM’s best with NOOP scheduler. Intel optimized RPM was also 1.8% faster than Percona 5.5.10-20.1 with DEADLINE but Percona 5.5.10-20.1 led by 4% with NOOP and Intel optimized RPM was 5-82% faster than MySQL 5.5.11.
