LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Hardware
User Name
Password
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?

Notices

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

Rep: Reputation: 30
SSD Hard Drive and MySQL


Hi,

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.



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

Rep: Reputation: 53
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: http://www.anandtech.com/storage/sho...spx?i=3531&p=1
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
michaelk
Moderator
 
Registered: Aug 2002
Posts: 11,562

Rep: Reputation: 684Reputation: 684Reputation: 684Reputation: 684Reputation: 684Reputation: 684
Wear leveling is built into the disk hardware and is OS independent. It would depend on the drive and the wear leveling algorithm.

http://www.bitmicro.com/press_resources_flash_ssd.php
http://www.bitmicro.com/press_resour...ash_ssd_db.php
 
Old 07-13-2009, 03:32 PM   #4
jefro
Guru
 
Registered: Mar 2008
Posts: 10,280

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

If you have enough ram might try a ram drive.
 
  


Reply


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
Trackbacks are Off
Pingbacks are On
Refbacks are 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


All times are GMT -5. The time now is 07:20 PM.

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