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 <san...@debruijne.eu>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.prab...@gmail.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<wro...@gmail.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.prab...@gmail.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 > To unsubscribe: http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be > > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
