"Too many active concurrent transactions"

--20cf3033451df394a904a4bcd468
Content-Type: text/plain; charset=ISO-8859-1

I keep getting this error when we get spikes in traffic.

Even though max connections is set to 4096 and file limits are raised, mysql
still gives this error.

Is there a setting I should be looking for that will allow me to raise
whatever causes this error?

Thanks
--------------------------------
Angelo Vargas
angelo [at] at.com

--20cf3033451df394a904a4bcd468--
Angelo Vargas [ Do, 02 Juni 2011 18:07 ] [ ID #2060410 ]

Re: "Too many active concurrent transactions"

Quoting Angelo Vargas <angelo [at] at.com>:

> I keep getting this error when we get spikes in traffic.
>
> Even though max connections is set to 4096 and file limits are raised, mysql
> still gives this error.
>
> Is there a setting I should be looking for that will allow me to raise
> whatever causes this error?
>

Could be this bug:
http://bugs.mysql.com/bug.php?id=26590

Are you running 5.1.47 or 5.5.4 or newer?

Andy.





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2 [at] m.gmane.org
a.smith [ Do, 02 Juni 2011 18:27 ] [ ID #2060411 ]

Re: "Too many active concurrent transactions"

--0016e6dd98555501d504a4bd82b2
Content-Type: text/plain; charset=ISO-8859-1

It's actually running 5.1.56 (percona)

On Thu, Jun 2, 2011 at 11:27 AM, <a.smith [at] ukgrid.net> wrote:

> Quoting Angelo Vargas <angelo [at] at.com>:
>
> I keep getting this error when we get spikes in traffic.
>>
>> Even though max connections is set to 4096 and file limits are raised,
>> mysql
>> still gives this error.
>>
>> Is there a setting I should be looking for that will allow me to raise
>> whatever causes this error?
>>
>>
> Could be this bug:
> http://bugs.mysql.com/bug.php?id=26590
>
> Are you running 5.1.47 or 5.5.4 or newer?
>
> Andy.
>
>
>
>
>


--
--------------------------------
Angelo Vargas
angelo [at] at.com

--0016e6dd98555501d504a4bd82b2--
Angelo Vargas [ Do, 02 Juni 2011 18:55 ] [ ID #2060412 ]
Datenbanken » gmane.comp.db.mysql.general » "Too many active concurrent transactions"

Vorheriges Thema: timezone
Nächstes Thema: Collate issue