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
>



-- 
Claudio

Reply via email to