List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:November 8 2010 2:59pm
Subject:Re: is changing my.cnf without restart safe?
View as plain text  
No, this is in and of itself safe. I didn't realise you could change the
InnoDB datafiles on the fly, though - thanks for that hint :-)

MySQL will never write the config file itself, so you're not at risk of
conflict there. You are at risk of putting something in the configfile which
messes up your MySQL server at the next restart, however; but that's pretty
much the case for any other daemon, too.



On Mon, Nov 8, 2010 at 11:06 AM, AHMET ARSLAN <aarslan2@stripped>wrote:

> Hello MySQL Community,
>
> Last Friday I changed /etc/mysql/my.cnf file (at server) accidentally.
> I set the variable innodb_data_file_path to  ibdata1:100M
>
> Then I realized that I changed the server copy. Then to get the original
> value I issued the query :
> SHOW VARIABLES LIKE  'innodb_data_file_path'
>
> I get the following:
> innodb_data_file_path =
> ibdata1:4000M;ibdata2:4000M;ibdata3:4000M;ibdata4:4000M:autoextend
>
> I wrote this value to my.cnf again.
>
> MySQL isn't restarted in these whole process. Whole thing took 5-10
> minutes.
>
> Here is my questions:
>
> if i change something in my.cnf, they are not activated until i restart
> mysql right?
>
> is above scenario safe? Do you think i messed up something?
>
> Thank you for your help.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

Thread
is changing my.cnf without restart safe?AHMET ARSLAN8 Nov
  • Re: is changing my.cnf without restart safe?Johan De Meersman8 Nov