OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: how would mysqld restart affect dynamically set global variables?

From: Steve Musumeche (steveinternetretailconnection.com)
Date: Wed Mar 14 2007 - 11:43:46 CDT


I believe it would revert back to the settings in your my.cnf file. If
you want the change to be permanent, then set it there.

Steve Musumeche
CIO, Internet Retail Connection
steveinternetretailconnection.com

Bing Du wrote:
> Hi,
>
> We're running mysql 4.1.20. If I understand the manual correctly, I can
> change max_connections while mysqld is running without restart mysqld to
> make the change take effect. But what if mysqld restarts later in some
> other situations, like machine reboot, would my (global) change on
> max_connections remain? I'm just very clear when to make dynamic changes
> and when is better to put changes in my.cnf. Please advise.
>
> Thanks in advance,
>
> Bing
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql