setting innodb_flush_log_at_trx_commit to 2 instead of default 1 made innedb-tables like 100 times faster
By murtlest in mysql on 2010-05-20 01:14:34.