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