Help answer threads with 0 replies.
Go Back > Forums > Linux Forums > Linux - Hardware
User Name
Linux - Hardware This forum is for Hardware issues.
Having trouble installing a piece of hardware? Want to know if that peripheral is compatible with Linux?


  Search this Thread
Old 07-13-2009, 11:12 AM   #1
Registered: Aug 2005
Posts: 158

Rep: Reputation: 30
SSD Hard Drive and MySQL


I want to run a MySQL server on a SSD drive. The drive would be a 2.5" SLC SSD hard drive. The operating system would be Debian Lenny and the MySQL database would probably write to the database ~every 3-5 seconds.

I am worried about the amount of writes per sector, most manufactures say that you can write to them ~100 000 times. This doesnt sound like a lot though, because a write every 5 seconds would then only give it ~6 day lifespan.

I understand that some hard drives do wear-leveling to spread out the writes to different sectors. Is this OS dependent or is this built into the hard drive? Does this actually have a big impact? I want to get a minimum ~5 years lifespan out of the hard drive as it will be replicated and mass produced into ~100 copies.

Old 07-13-2009, 11:42 AM   #2
Registered: Jun 2007
Distribution: Fedora, RHEL, Centos
Posts: 294

Rep: Reputation: 54
from what I have read, wear-levelling is built into the drives and done without the OS knowing it is happening. I don't recall ever reading an SSD drive is good for DB type work though for that specific reason. I also read a great article that details the specifics on how SSD's work with the pro's/cons here:
Without knowing more details about your project, it is difficult to offer other solutions. If however you have a high tolerance for lost data (say 12 hours of lost data is acceptable), what about running TRX logging or similar on a ramdisk and only committing to disk every 2 hours or so.
Old 07-13-2009, 01:05 PM   #3
Registered: Aug 2002
Posts: 16,028

Rep: Reputation: 1851Reputation: 1851Reputation: 1851Reputation: 1851Reputation: 1851Reputation: 1851Reputation: 1851Reputation: 1851Reputation: 1851Reputation: 1851Reputation: 1851
Wear leveling is built into the disk hardware and is OS independent. It would depend on the drive and the wear leveling algorithm.
Old 07-13-2009, 03:32 PM   #4
Registered: Mar 2008
Posts: 16,883

Rep: Reputation: 2498Reputation: 2498Reputation: 2498Reputation: 2498Reputation: 2498Reputation: 2498Reputation: 2498Reputation: 2498Reputation: 2498Reputation: 2498Reputation: 2498
You are paying a lot for that drive. Might consider traditional raid arrays.

If you have enough ram might try a ram drive.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to disable read prefetch for an SSD drive MartyMcFly Linux - Hardware 1 01-20-2009 10:42 AM
New Linux user: Acer Aspire One, Limpus Linux OS w/8gb SSD drive acpiusa Linux - General 1 08-27-2008 05:22 AM
How hard to get MySQL data served from a separate physical drive? sneakyimp Linux - Software 2 09-18-2007 09:53 PM
mysql database install on external hard drive Peter Shepard Ubuntu 1 06-14-2007 07:29 AM
apache + mysql and hard drive question mouse46 Linux - Software 0 10-20-2004 06:57 PM > Forums > Linux Forums > Linux - Hardware

All times are GMT -5. The time now is 12:09 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration