OK,
I have a MySQL server running 4.0.12 on a 12 CPU Sun U4500 with 12GB of memory.
With the query cache running, this machine would noticeably "hiccup" (just stop responding to requests) every so often and wouldn't squeeze more then 1000 queries per second or so as a result (heavily mixed OLTP work, with a lot of SELECT's and almost as many UPDATE's).
Without the Query Cache (and no other tweaking), I'm now at over 2100 at the same time of day.
Is there a problem with the query cache that causes MySQL to be far less scalable then just straight MySQL/InnoDB?
Are there any thoughts on this? Is there a resource specifically for high performance/high load MySQL implementation/usage?
Dylan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
