List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:October 24 2010 11:10am
Subject:Re: mysql's system variables
View as plain text  
Changes to global variables will indeed not affect the instantiated local
session variables. You can, however, also explicitly change those by using
"set local *variable*" - that should eliminate the need for most reconnects.

On Sat, Oct 23, 2010 at 7:19 PM, Sander de Bruijne <sander@stripped>wrote:

>
> > 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
>>>
>>>
>>
>>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

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