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/