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

Reply via email to