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

--0016e65c8d4068ec980487e0bef6
Content-Type: text/plain; charset=ISO-8859-1

hi

as the title

thanks

--
-------------------------
Lin Chun

--0016e65c8d4068ec980487e0bef6--

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

--001636e0a87b2dcd870487e1191b
Content-Type: text/plain; charset=ISO-8859-1

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 wrote:

> hi
>
> as the title
>
> thanks
>
> --
> -------------------------
> Lin Chun
>



--
Thanks
Suresh Kuna
MySQL DBA

--001636e0a87b2dcd870487e1191b--

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

--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-variabl es.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--