I am testing SSDs for use with MySql and see no performance benefits. It makes me feel like I have to do something wrong.
Here is the setup:
- Xeon 5520 2.26 Ghz Quad Core
- 12 GB Ram
- 300 GB 15K RAID 1
- 64GB SSD in RAID 1
For the test, I moved the mysql directory to the SSD.
I imported a table with 3 million rows. It then imports the same table with data and index directories symbolically linked to the 15k drive.
Loading data into tables using dump from mysqldump. 15k drives showed faster insertion speeds on SSDs:
- 15k ~ = 35,800 inserts / sec
- SSD! = 27,000 inserts / sec
Then I tested the SELECT speed by doing 'SELECT * FROM table INTO OUTFILE' / tmp / table.txt ':
- 15kk ~ = 3,000,000 rows in 4.19 seconds
- SSD ~ = 3 000 000 4,21
, SSD, . , ?
: SSD : noatime noob-scheduler