From: Sander de Bruijne (sanderdebruijne.eu)
Date: Sat Oct 23 2010 - 12:19:50 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

> exit mysql client and enter again.

Instead of exit client and enter again, just type \r (reconnect)
and you have a new session.

On 10/23/2010 06:44 PM, Claudio Nanni wrote:
> Just a little note:
>
> sometimes, if you are in command line session, you will not see the change
> of the dynamic variable unless you logout and in again,
> so in case you change the value of a dynamic variable but still the "show
> variables" shows you the old value, dont panic!
> exit mysql client and enter again.
>
> Aloha!
>
> Claudio
>
>
>
> 2010/10/23 Prabhat Kumar<aim.prabhatgmail.com>
>
>> Here you get all details:
>>
>> http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
>>
>> All the Dynamic variable can be change on fly eg.
>> wait_timeout<
>> http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_wait_timeout
>> .
>>
>>
>> On Sat, Oct 23, 2010 at 6:07 PM, wroxdb<wroxdbgmail.com> wrote:
>>
>>> Hello,
>>>
>>> what system variables of mysqld can be changed on fly?
>>>
>>> thanks.
>>>
>>> --
>>> MySQL General Mailing List
>>> For list archives: http://lists.mysql.com/mysql
>>> To unsubscribe:
>>> http://lists.mysql.com/mysql?unsub=aim.prabhatgmail.com
>>>
>>>
>>
>> --
>> Best Regards,
>>
>> Prabhat Kumar
>> MySQL DBA
>>
>> My Blog: http://adminlinux.blogspot.com
>> My LinkedIn: http://www.linkedin.com/in/profileprabhat
>>
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]