do i have to restart the mysql server when i change some global variables?

[Lin Chun]

hi

as the title

thanks

-- 
-
Lin Chun

Re: do i have to restart the mysql server when i change some global variables?

[Suresh Kuna]

unless and until if the variable is read-only, you don't need Lin.

On Mon, May 31, 2010 at 3:17 PM, Lin Chun franks1...@gmail.com wrote:

 hi

 as the title

 thanks

 --
 -
 Lin Chun




-- 
Thanks
Suresh Kuna
MySQL DBA

Re: do i have to restart the mysql server when i change some global variables?

[Prabhat Kumar]

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 
 SEThttp://dev.mysql.com/doc/refman/5.1/en/set-option.htmlstatement, 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