speed up queries with sdd
joshua at themarshians.com
Mon Oct 1 10:35:49 MDT 2012
On Mon, Oct 1, 2012 at 10:07 AM, Merrill Oveson <moveson at gmail.com> wrote:
> Put my mysql database on sdd drive...
> Will my queries run much faster?
> Anybody tried this?
I have had a lot of success doing this. It depends on what your database
and read/writes look like though. MySQL does a good job caching reads as
Lloyd said, so if your data is relatively static, then you won't get as
much bang for your buck.
We used SSD's in a system with a healthy mix of reads/writes, so disk speed
was something worth investing in. SSD gave use about 20% improvement
overall. If you're database is heavy read though, you won't see that much
improvement because MySQL is already doing most of the work with that.
You will almost certainly see some increase by using SSD's. It's just a
question of whether your database will see enough to make it worth the cost.
More information about the PLUG