On Thu, Aug 6, 2009 at 10:06 AM, Clint Webb <[email protected]> wrote:
> > Actually, if you are using Memcache, then you will probably have better > performance if you disable the database cache. > > Assuming you are using mysql, this page will help you disable it (which is > quite easy actually) > http://dev.mysql.com/doc/refman/5.1/en/query-cache.html > > Note: Memcached by itself isnt a direct replacement for db query caches, > however, proper application of memcached would invalidate most benefits that > you get from the query cache. You should run your own benchmarks to see > what works best for you. > > And another thing that suprises me a lot, but I see it all the time. Do you have appropriate indexes on your tables? When I was doing general consulting years ago, The easiest money I would make is going to businesses that are having trouble with their systems that have been running for years but now getting excruciatingly slow. After poking around for a few minutes, discover that none of their tables have indexes, or the indexes are incomplete. Instant performance gain, very happy clients. -- "Be excellent to each other"
