Hi,
I have two environments running dbmail. I noticed that one mysql
server's query graph looks very different to the other. Turns out one
has query cache enabled while the other doesn't.
Read about query cache here:
http://dev.mysql.com/doc/refman/5.0/en/query-cache.html
The server that uses query cache seams to be having a bit more cache hit
queries than select queries. Averages of 3.5 select queries per second
vs 4.0 cache hit queries per second. It sure looks like a big improvement.
So the question is, has anyone done tests/benchmarks for a dbmail mostly
IMAP environment and whether using the query cache has helped. Also how
much memory was allocated to query cache.
PS: Might very well be the reason I had awful performance with the
lower(blah) selects on a mysql server with no query cache. (dbmail-dev
thread "Re: message I sent to dbmail-dev")
Comments?
Alex
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
