Switch off InnoDB logging - Possible?

[Matthew Hird]

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