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]> > > > >