> 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=arch...@jab.org
