"Too many active concurrent transactions"

"Too many active concurrent transactions"

am 02.06.2011 18:07:00 von Angelo Vargas

--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.com

--20cf3033451df394a904a4bcd468--

Re: "Too many active concurrent transactions"

am 02.06.2011 18:27:17 von a.smith

Quoting Angelo Vargas :

> 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@m.gmane.org

Re: "Too many active concurrent transactions"

am 02.06.2011 18:55:29 von Angelo Vargas

--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, wrote:

> Quoting Angelo Vargas :
>
> 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.com

--0016e6dd98555501d504a4bd82b2--