Yes and No. Its depend on the type of variable you have changed. If its Dynamic , MySQL restart not required, else its required.
System variables can be set at server startup using options on the command > line or in an option file. Most of them can be changed dynamically while the > server is running by means of the > SET<http://dev.mysql.com/doc/refman/5.1/en/set-option.html>statement, which > enables you to modify operation of the server without > having to stop and restart it. You can refer to system variable values in > expressions. > Check the complete list of variable. : http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html Thanks, On Mon, May 31, 2010 at 3:17 PM, Lin Chun <franks1...@gmail.com> wrote: > hi > > as the title > > thanks > > -- > ------------------------- > Lin Chun > -- Best Regards, Prabhat Kumar MySQL DBA Datavail-India Mumbai Mobile : 91-9987681929 www.datavail.com My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat