Hi all

The same thing mysql also uses it own defaults file if my.cnf is not found. It uses its own defaults-extra-file configurations to start the db.


Yeah but only specific variables can be changed globally or session wise.
Others needs recycling of db. :-)





----- Original Message ----
From: Martin Gainty <mgainty@hotmail.com>
To: B. Keith Murphy <bmurphy@paragon-cs.com>; mysql list <mysql@lists.mysql.com>
Sent: Wednesday, November 28, 2007 3:49:20 AM
Subject: 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
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=john_mysql@yahoo.com







Get easy, one-click access to your favorites. Make Yahoo! your homepage.


__________________________________________________ __________________________________
Be a better pen pal.
Text or chat with friends inside Yahoo! Mail. See how. http://overview.mail.yahoo.com/