MyISAM versus InnoDB I'm working on a projects which involves a lot of database writes, I'd say (70% inserts and 30% reads). This ratio would also include updates which I consider to be one read and one write. The reads can be dirty (e.g. I don't need 100% accurate information at the time of read).The task in question will be doing over 1 million database transactions an hour. I've read a bunch of stuff on the web about the differences between MyISAM and