In response to an email offlist, I forgot to specify that these are InnoDB tables.
On Mon, Mar 3, 2008 at 2:53 PM, Waynn Lue <[EMAIL PROTECTED]> wrote: > 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]
