set wait_timeout=X and set interactive_timeout=x do not work

Has anyone run into the situation using mysql where set wait_timeout=X
and set interactive_timeout=x do not work. I've tried them from inside
the client under root user and in the my.ini file before startup, and I
get the default values no matter what I put in there. Any ideas?

win2k sp4
mysqld-nt 4.0.24

Thanks,
Corey

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: set wait_timeout=X and set interactive_timeout=x do not work

I could only set them using console, with SET GLOBAL. The config file
setting could not set the variable and instead used 5, I thought it
was the default, but then, removing the setting I noticed the default
was 28800. This value is good for me, but I could not change this
using options file (tried everything at the manual) so, if I ever need
to change this, I'll use the SET SESSION at the client, wich works
fine for me. I don't think its a bug, maybe it was documented wrong
(?).

Best regards,

On Apr 12, 2005 6:17 PM, Corey Tisdale wrote:
> Has anyone run into the situation using mysql where set wait_timeout=X
> and set interactive_timeout=x do not work. I've tried them from inside
> the client under root user and in the my.ini file before startup, and I
> get the default values no matter what I put in there. Any ideas?
>
> win2k sp4
> mysqld-nt 4.0.24
>
> Thanks,
> Corey
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: set wait_timeout=X and set interactive_timeout=x do not work

I tried set global as well and no dice. I know this stuff worked when I
was running 4.0.23, so I wonder if something changed in .24 with the way
it worked.

I can try anything like

set global wait_timeout=300

and no matter what it will be 3600. It's driving me mad.

Any ideas?


Daniel da Veiga wrote:

>I could only set them using console, with SET GLOBAL. The config file
>setting could not set the variable and instead used 5, I thought it
>was the default, but then, removing the setting I noticed the default
>was 28800. This value is good for me, but I could not change this
>using options file (tried everything at the manual) so, if I ever need
>to change this, I'll use the SET SESSION at the client, wich works
>fine for me. I don't think its a bug, maybe it was documented wrong
>(?).
>
>Best regards,
>
>On Apr 12, 2005 6:17 PM, Corey Tisdale wrote:
>
>
>>Has anyone run into the situation using mysql where set wait_timeout=X
>>and set interactive_timeout=x do not work. I've tried them from inside
>>the client under root user and in the my.ini file before startup, and I
>>get the default values no matter what I put in there. Any ideas?
>>
>>win2k sp4
>>mysqld-nt 4.0.24
>>
>>Thanks,
>>Corey
>>
>>--
>>MySQL Windows Mailing List
>>For list archives: http://lists.mysql.com/win32
>>To unsubscribe: http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
>>
>>
>>
>>
>
>
>
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org