On Mon, Oct 1, 2012 at 10:07 AM, Merrill Oveson <[email protected]> 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. /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
