MySQL Forums
Forum List  »  Newbie

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


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?


Options: ReplyQuote

Written By
Switch off InnoDB logging - Possible?
June 16, 2009 03:19AM

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.