List:General Discussion« Previous MessageNext Message »
From:Sander de Bruijne Date:October 23 2010 5:19pm
Subject:Re: mysql's system variables
View as plain text  
 > 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.prabhat@stripped>
>
>> 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<wroxdb@stripped>  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=1
>>>
>>>
>>
>> --
>> Best Regards,
>>
>> Prabhat Kumar
>> MySQL DBA
>>
>> My Blog: http://adminlinux.blogspot.com
>> My LinkedIn: http://www.linkedin.com/in/profileprabhat
>>
>
>
Thread
mysql's system variableswroxdb23 Oct
  • Re: mysql's system variablesPrabhat Kumar23 Oct
    • Re: mysql's system variablesClaudio Nanni23 Oct
      • Re: mysql's system variablesSander de Bruijne23 Oct
        • Re: mysql's system variablesJohan De Meersman24 Oct
      • Re: mysql's system variablesMySQL)24 Oct