List:General Discussion« Previous MessageNext Message »
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?
View as plain text  
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 <franks1984@stripped> 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

Thread
do i have to restart the mysql server when i change some global variables?Lin Chun31 May
  • Re: do i have to restart the mysql server when i change some global variables?Suresh Kuna31 May
  • Re: do i have to restart the mysql server when i change some global variables?Prabhat Kumar31 May