MySQL Forums :: Newbie :: Switch off InnoDB logging - Possible?


Advanced Search

Switch off InnoDB logging - Possible?
Posted by: Matthew Hird ()
Date: June 16, 2009 03:19AM

Hi,

I've a MySQL server running with the InnoDB engine. My actual data is stored elsewhere and on startup of the MySQL server, the tables are truncated and the data inserted (don't ask!!).

Because I don't require the persistent nature of InnoDB, is there a way to switch off the looging? I ask because when I power nodes off, I'm finding that InnoDB cannot recover the logs and just continuously restarts. I don't care about recovering the data because I'm going to truncate it all anyway!!

Any suggestions?

cheers,
Matt

Options: ReplyQuote


Subject Written By Posted
Switch off InnoDB logging - Possible? Matthew Hird 06/16/2009 03:19AM
Re: Switch off InnoDB logging - Possible? Rick James 06/17/2009 10:50PM
Re: Switch off InnoDB logging - Possible? Matthew Hird 06/18/2009 07:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.