On Wed, March 14, 2007 9:35, Bing Du said: > 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 > Put the changes in dynamically. If they work change the my.cnf to make them survive the next time mysql is restarted (for example on a reboot).
------- William R. Mussatto, Senior Systems Engineer http://www.csz.com Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]