Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My company is considering migrating our MySQL data from an HDD array to an SSD, possibly the Intel SSD 520 series. We have a fairly large set of databases, some with upwards of 100 million rows, so we are looking for some performance gains. I have done some research and have found quite a bit of info about MySQL on SSD's with Linux & EXT3/EXT4 but not so much with Windows & NTFS. Has anyone had any experience using MySQL on an SSD with Windows 2008 & NTFS? Any tips or suggestions are greatly appreciated.

share|improve this question
    
Not sure I understand. Are the databases currently running on Linux or Windows? – Brent Pabst Sep 6 '12 at 14:44
    
Apologize if I wasn't clear. We are currently running MySQL on Windows 2008 with an HDD array and are considering moving the MySQL data to an SSD. – William Buchanan Sep 6 '12 at 16:07
    
When you say array, are you just talking about a local RAID array, a DASD or a SAN? How big are the databases in GB? – Brent Pabst Sep 6 '12 at 16:15
    
Local RAID array, all databases together about 250GB, which is several DB's in the 60 - 80GB range. – William Buchanan Sep 6 '12 at 16:36
    
I don't have enough experience with MySQL to provide a lot of help on this question, my only suggestion is that I would imagine a lot of the MSSQL technical articles relating to SSD usage would be relavent, albeit not precise. They both work in similar ways to some extent so a lot of the performance pitfalls with MSSQL on SSDs and vice versa are probably still relevant to your question. – Brent Pabst Sep 6 '12 at 17:11

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.