Re: Spfile in Mysql......

2007-11-27 Thread John Dba
From: Martin Gainty <[EMAIL PROTECTED]> To: B. Keith Murphy <[EMAIL PROTECTED]>; mysql list 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 problemat

Re: Spfile in Mysql......

2007-11-27 Thread Martin Gainty
7;" 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

Re: Spfile in Mysql......

2007-11-27 Thread B. Keith Murphy
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

Re: Spfile in Mysql......

2007-11-27 Thread Sujatha S
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 relea

Re: Spfile in Mysql......

2007-11-27 Thread Jay Pipes
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 dynam

Re: Spfile in Mysql......

2007-11-27 Thread Sujatha S
Hi, Mysql should bring this as there new feature in there next release! 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 an

Re: Spfile in Mysql......

2007-11-27 Thread Baron Schwartz
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