Re: "Too many active concurrent transactions"

2011-06-02 Thread Angelo Vargas
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

Re: "Too many active concurrent transactions"

2011-06-02 Thread 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 t

"Too many active concurrent transactions"

2011-06-02 Thread 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? Thanks

Patching MySQL CLI to log information

2011-06-02 Thread Andrew Braithwaite
Has anyone ever patched the MySQL or libmysql to log to some logfiles with information like the UNIX user, time, server connected to, port etc? I'm just trying to save myself a bit of C patching. Cheers, A -