Re: SELECT causing connections to back up?

2008-03-03 Thread Waynn Lue
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

SELECT causing connections to back up?

2008-03-03 Thread Waynn Lue
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 Use