I have a question for the mysql gurus. My site needs to read RSS feeds every hour and update the DB. As a result I need to insert/delete/update 1000s of rows each minute. As a result there's a ton of root IO (ie disk read/write) - as shown by SliceManager's Diagnostics.

I understand there's some write_ahead_log or something on those lines with MySQL/InnoDB in which I can set up MySQL not to write to disk every statement (ie each ins/upd/del) but rather batch them up until a certain size and then flush the write to disk. I think this is called write_ahead_log or something like that.

Has anyone used this - what my.cnf values need to be set or changed to get this going?

Thanks a bunch in advance!