[development] 2k qps
dries.buytaert at gmail.com
Wed Oct 11 07:14:11 UTC 2006
On 11 Oct 2006, at 06:44, Laura Scott wrote:
> This isn't a software solution, but bumping up your RAM could buy
> you a lot. I don't know what kind of caching you're doing, but more
> ram gives you room for (more) query_cache, which is a little thing
> that can buy you a lot. IME, once MySQL runs out of ram, the read/
> write temps can bring you to a crawl, and then the queries just
> pile up. RAM is cheap. Even after you optimize your code, that
> headroom can help performance.
Be careful here because Tamir might take your advice, spends his
money on RAM, only to find out that it is not helping him one bit.
RAM _might_ help iff (i) the problem is memory-bound and (ii) he
properly tuned MySQL. If, however, the problem is CPU-bound or I/O-
bound (disks), extra RAM is not likely to help him. Or maybe he
hasn't turned on the query cache to begin with.
Dries Buytaert :: http://www.buytaert.net/
More information about the development