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

hi as the title thanks -- - Lin Chun

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

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?

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