Re: mysql's system variables

2010-10-24 Thread Shawn Green (MySQL)
On 10/23/2010 12: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 o

Re: mysql's system variables

2010-10-24 Thread Johan De Meersman
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 my

Re: mysql's system variables

2010-10-23 Thread Sander de Bruijne
> 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 variabl

Re: mysql's system variables

2010-10-23 Thread Claudio Nanni
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 ent

Re: mysql's system variables

2010-10-23 Thread 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 . On Sat, Oct 23, 2010 at 6:07 PM, wroxdb wrote:

mysql's system variables

2010-10-23 Thread wroxdb
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=arch...@jab.org