SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 07:02 AM
| ||||
| ||||
 Re: Spfile in Mysql...... Hi, Mysql should bring this as there new feature in there next release! Regards, Sujatha On Nov 27, 2007 11:44 AM, Shanmugam, Dhandapani < dhandapani.shanmugam@eds.com> 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/mysql?unsub=dhandapani.shanmugam@eds.com*<http://lists.mysql.com/mysql?unsub=dhandapani.shanmugam@eds.com>      |
|
02-28-2008, 07:02 AM
| |||
| |||
| Re: Spfile in Mysql...... 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 < > dhandapani.shanmugam@eds.com> 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/mysql?unsub=dhandapani.shanmugam@eds.com*<http://lists.mysql.com/mysql?unsub=dhandapani.shanmugam@eds.com> > |
|
02-28-2008, 07:02 AM
| |||
| |||
| Re: Spfile in Mysql...... 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 <jay@mysql.com> 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 < > > dhandapani.shanmugam@eds.com> 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/mysql?unsub=dhandapani.shanmugam@eds.com*< > http://lists.mysql.com/mysql?unsub=dhandapani.shanmugam@eds.com> > > > > |
|
02-28-2008, 07:02 AM
| |||
| |||
| Re: Spfile in Mysql...... This has probably already been over-talked about  but I will throw mytwo 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 <jay@mysql.com> 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 < >>> dhandapani.shanmugam@eds.com> 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/mysql?unsub=dhandapani.shanmugam@eds.com*< >>> >> http://lists.mysql.com/mysql?unsub=dhandapani.shanmugam@eds.com> >> >> > > |
|
02-28-2008, 07:02 AM
| ||||
| ||||
| Re: Spfile in Mysql...... 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" <bmurphy@paragon-cs.com> 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 <jay@mysql.com> 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 < > >>> dhandapani.shanmugam@eds.com> 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/mysql?unsub=dhandapani.shanmugam@eds.com*< > >>> > >> http://lists.mysql.com/mysql?unsub=dhandapani.shanmugam@eds.com> > >> > >> > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mgainty@hotmail.com > > |
Linear Mode
