On Mon, Oct 25, 2010 at 7:56 AM, wroxdb <wroxdb@stripped> 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 for the SSD solution for mysql?
>
It may or may not be, depending on which problem you're trying to solve :-)
For starters, how big is your DB ? If it fits in memory anyways, you'll not
see a lot of benefit for selects. SSD may still be useful if you have a lot
of writes, though.
If the database doesn't fit in available memory, a lot more factors are
going to apply, depending on the usage patterns.
Incidentally, i'm not aware of how SSD plays with hard/software RAID setups
- anyone know more about this ?
>
> Thanks.
>
> Regards,
> Kenn.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
