Benchmarking SSD for MySQL
Today I bought Intel X25-M, to test its performance and consider if we could replace a HDD used in our slave database of Pathtraq with a solid state disk. Connecting the drive to a test server, I have just run a synthetic benchmark to check its performance for 16KB random access with O_DIRECT flag set, which is pretty similar to the access pattern we see in our daily InnoDB use.
|HDD (Maxtor 7L250S0)||SSD (Intel X25-M)||Ratio||Read (MB/sec)||2.64||38.0||1440%|
|Write (MB/sec, hdparm -W 0)||1.91||11.2||585%|
Looks very promising. I will post further results as I continue my benchmarks.
PS2. I have also checked by opening the disk as a raw device with -c 4 to check if performance increases under higher concurrency (due to NCQ, etc.), but there were no improvements at least on our system. (unfortunately we did not have XFS installed)