--- On Mon, 25/10/10, Daevid Vincent dae...@daevid.com wrote:
From: Daevid Vincent dae...@daevid.com
Subject: RE: Is SSD suitable for mysql server?
To: 'mysql' mysql@lists.mysql.com
Date: Monday, 25 October, 2010, 21:52
I guess it depends on how
important your data is too. Quite
a few
Hi Warren, all!
Your statement is true ...
Warren Young wrote:
[[...]]
A lone 2 TB rotating disk will beat a top-of-the-line SSD for linear
writes, and you can beat an SSD for linear reads with a pair of disks in
RAID-0 or -1, or four disks in RAID-10. [[...]]
... but irrelevant:
Linear
At 12:56 AM 10/25/2010, you wrote:
Hello,
We are a company for gaming.
Our main db is mysql 5.1 installed on Linux.
Currently the hardware for mysql is 2*4 CPU, 16G memory, Raid 10 (four disks).
Now we have the plan to replace the disks with SSD for better performance.
Do you think is it right
On Mon, Oct 25, 2010 at 7:56 AM, wroxdb wro...@gmail.com wrote:
Hello,
We are a company for gaming.
Our main db is mysql 5.1 installed on Linux.
Currently the hardware for mysql is 2*4 CPU, 16G memory, Raid 10 (four
disks).
Now we have the plan to replace the disks with SSD for better
--- On Mon, 25/10/10, Johan De Meersman vegiv...@tuxera.be wrote:
From: Johan De Meersman vegiv...@tuxera.be
Subject: Re: Is SSD suitable for mysql server?
To: wroxdb wro...@gmail.com
Cc: mysql mysql@lists.mysql.com
Date: Monday, 25 October, 2010, 10:03
On Mon, Oct 25, 2010 at 7:56 AM
On 10/25/2010 3:03 AM, Johan De Meersman wrote:
SSD may still be useful if you have a lot of writes, though.
Only if by a lot you mean a minority.
A lone 2 TB rotating disk will beat a top-of-the-line SSD for linear
writes, and you can beat an SSD for linear reads with a pair of disks in
On 10/25/2010 4:32 AM, Glyn Astill wrote:
There have been some reports of raid cards not behaving themselvs
with SSDs attached.
I'd be surprised if these bugs haven't all been worked out by now. SSDs
started to hit the mass market in force about two years ago. Any vendor
still shipping a
I guess it depends on how important your data is too. Quite
a few of the SSDs on the market have been proven to not
honour flush requests, so if the power goes out you've got
corrupted data.
Uh. If you're not using a UPS battery backup then you deserve to loose your
data. And if you don't