On MySQL 4.1 / InnoDB / FreeBSD / FFS / SCSI, small inserts run at about 167 transactions per second, i.e. one per rotation. Same setup but --innodb_flush_log_

On MySQL 4.1 / InnoDB / FreeBSD / FFS / SCSI, small inserts run at about 167 transactions per second, i.e. one per rotation. Same setup but --innodb_flush_log_at_trx_commit=0, a million transactions in 200 seconds, or 5000/second. I don't know if InnoDB wrote its B-Tree to disk during the 200 seconds. Same performance even with InnoDB's buffer pool size set to 200 KB with --innodb_buffer_pool_size=200000. The MySQL documentation claims that this configuration does crash-recovery correctly, though you may lose the last second's worth of transactions.