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]