persisting session-specific configuration items to system wide data stores does appear to be problematic.. perhaps sujatha could explain the reasoning behind this shift?
M- ----- Original Message ----- From: "B. Keith Murphy" <[EMAIL PROTECTED]> To: "'mysql list'" <mysql@lists.mysql.com> Sent: Tuesday, November 27, 2007 4:58 PM Subject: Re: Spfile in Mysql...... > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
