MySQL 5.6.25 sql-bench results on Linux 4.2.3 kernel and SSD RAID 1

October 23rd, 2015 by bostjan

This post provides fresh sql-bench results for the test that was performed a while back.

Changed configuration

During testing period of whether SSD disks may be used on such an old hardware as HP DL360 G5 server, I figured I should run this test too. So I did.

First, system configuration:

  • CPUs: 2x Intel Xeon X5450 (3GHz)
  • Memory: 32GB
  • Storage: Software RAID 1 over two Samsung 850 PRO 512GB disks, dedicated to this container
  • Filesystem: ext4 on LVM
  • OS architecture: x86_64
  • Linux kernel version: 4.2.3
  • MySQL version: 5.6.25
  • Additional note: tests were performed in unprivileged LXC container

Results

Total time for all tests to complete: 601 seconds

Notes and interpretation

MySQL had to be reconfigured to use MyISAM storage engine by default, since the default was changed to InnoDB (in 5.5). Everything is a bit slower anyway. I expected “insert” test to be significantly faster, but it seems MySQL and kernel both do pretty good job optimizing disk writing patterns on spinning rust disks.
During the test the system was basically stuck with 100% CPU usage on one processor and the rest of them (7) did nothing. Wait IO was almost nonexistent, thanks to fast SSD response times.

I must admit I did expect this configuration to be a bit more performant, but I was mistaken.

That is it. For your and my future reference again 🙂


One Response to “MySQL 5.6.25 sql-bench results on Linux 4.2.3 kernel and SSD RAID 1”

  1. […] UPDATE: There was a newer test performed, with MySQL 5.6.25 on Linux 4.2.3 64bit, on almost the same hardware. You can see it here. […]

Leave a Reply

 

*