Re: Mysql with short wait_timeout

On Wed, Jul 29, 2009 at 9:27 AM, Damián Viano
<[email protected]>wrote:

> On Wed, Jul 29, 2009 at 09:33:57AM +0200, Alexander Malysh wrote:
> > The only issue you have, is max allowed connections in mysql and not
> > kannel itself.
> >
> > Just make sure kannel always get connection to mysql and you will never
> > see issue there.
>
> Right, and it's not hard to do that (from mysql 5.0.3 onwards), as long as
> you
> use different users for the different apps running in your mysql.
>
> Check MAX_USER_CONNECTIONS at:
> http://dev.mysql.com/doc/refman/5.0/en/user-resources.html
>
> That's the right(tm) fix IMO.
>
> Hope to help.
>
>  Damián Viano(Des).
>

Indeed that's a very good fix, I went a different approach to fix it where I
have Kannel use a mysql instance with wait_timeout bigger than my short one.
I'll look if I set this per user limitation in the future...

Regards,

-- 
Math
aka ROunofF

[email protected]