This has probably already been over-talked about :) but I will throw my two cents in. I would be very much opposed to a situation where changes made on-the-fly are stored permanently in the my.cnf file. If I decide to keep a change to a server setting I am very much capable of doing it myself. Besides, if it is permanent I need to make the changes to my subversion copies of my.cnf.

Keith

Sujatha S wrote:
Yes! I think in oracle the dynamic changes are recorded in spfile.. so that
it uses on instance startup.. rather making an permanent entry in pfile.

Regards,

On 11/28/07, Jay Pipes <[EMAIL PROTECTED]> wrote:
Sujatha S wrote:
Mysql should bring this as there new feature in there next release!
Unlikely.  Dynamic changes are, well, dynamic.  Permanent stuff goes in
the my.cnf.

-jay

Regards,

Sujatha
On Nov 27, 2007 11:44 AM, Shanmugam, Dhandapani <
[EMAIL PROTECTED]> wrote:

Hello,
The dynamic changes made on mysql server instance gets vanished once
the instance goes down...!! Is there any way for mysql to store the dynamic changes on my.cnf file automatically ..?(like Oracle) , so on next startup mysql automatically pickup the dynamic changes made from my.cnf file....
Unfortunately there is not. You should alter your my.cnf file to record
the
changes you make.

--

MySQL General Mailing List

For list archives: *http://lists.mysql.com/mysql*<
http://lists.mysql.com/mysql>
To unsubscribe: *
http://lists.mysql.com/[EMAIL PROTECTED]<
http://lists.mysql.com/[EMAIL PROTECTED]>



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to