I could be wrong (I'm not our office's resident MySQL guru), but I think that MySQL does some significant caching into DRAM. So, if you're worried about the query time of an uncached query, then possibly, but otherwise, I'd just let the caching algorithm handle it. Also depends on what you're requirements are, in terms of how many unique queries (therefore not cached) per second, total queries per second, etc.
I'm not saying that SSDs don't have their uses, but many times it's not the best solution. Certainly not the most cost-effective. Lloyd Brown Systems Administrator Fulton Supercomputing Lab Brigham Young University http://marylou.byu.edu On 10/01/2012 10:07 AM, Merrill Oveson wrote: > Pluggers: > > > Put my mysql database on sdd drive... > > Will my queries run much faster? > > Anybody tried this? > > Merrill > > /* > PLUG: http://plug.org, #utah on irc.freenode.net > Unsubscribe: http://plug.org/mailman/options/plug > Don't fear the penguin. > */ > /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
