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