From: Prabhat Kumar Date: May 31 2010 10:13am Subject: Re: do i have to restart the mysql server when i change some global variables? List-Archive: http://lists.mysql.com/mysql/221758 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=00c09f93d65c83bfde0487e11ba6 --00c09f93d65c83bfde0487e11ba6 Content-Type: text/plain; charset=ISO-8859-1 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 SETstatement, 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 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 --00c09f93d65c83bfde0487e11ba6--