I've been noticing strange load spikes on our mysql machine, throwing back the dreaded "max connections error", even though the value is set to 500. I'm wondering if this is related to an hourly script I run that does a few somewhat-db intensive queries. The script runs a query that groups by Users to find out who's been the most active across our system. Would that cause other connections to the database to back up? I just saw it happen, so I killed the query and everything returned to normal pretty quickly, but I'm somewhat confused, because it looked like connections to other databases were being backed up as well. One other weird thing, if I'm doing a complex SELECT from a table, and something else is INSERTing into that same table, the INSERT is taking awhile, even though there shouldn't be any contention since I'm not doing SELECT FOR UPDATE.
Any ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
