Re: Mysql with short wait_timeout

Mathieu Bruneau <[email protected]>
Newsgroups gmane.comp.mobile.kannel.devel
Message-ID <[email protected]>
On Tue, Jul 28, 2009 at 10:27 AM, Mathieu Bruneau <[email protected]> wrote:

>
>
>> > 2 - Send a set wait_timeout on connection to override the value from
>> MySQL,
>> > however in this case I don't know what we should set it to since the
>> mysql_ping
>> > is based on activity... (Maybe 8h ? since it's the default MySQL value)
>>
>> And what if you have no Kannel activity for 8 hours? In the
>> mentioned doc it's not very clear if that can be deactivated,
>> which may be a solution.
>
>
> Yes, you can set it to 0 to deactivate it.
>
>

Correction, I just experiment with that and there is no way to deactivate
it, valid range in the documentation is 1-31536000. Setting it to 0 (which
it accepts) seems to have mysql drop the connections very fast :)


-- 
Math
aka ROunofF

[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.