From: Johan De Meersman Date: October 24 2010 11:10am Subject: Re: mysql's system variables List-Archive: http://lists.mysql.com/mysql/223425 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=002215047c9bb9828804935aedf0 --002215047c9bb9828804935aedf0 Content-Type: text/plain; charset=ISO-8859-1 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 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 >> >> 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 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.prabhat@stripped >>>> >>>> >>>> >>> -- >>> 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=vegivamp@stripped > > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --002215047c9bb9828804935aedf0--