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

Spfile in Mysql......

2007-11-27 Thread Shanmugam, Dhandapani
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...