To get the best locking performance out of InnoDB in 5.1, you’ll want to set the following options (“My Favorite New Feature of MySQL 5.1: Less InnoDB Locking” explains why):

[mysqld]<br /> innodb_autoinc_lock_mode=2<br /> binlog_format=row<br /> tx_isolation=READ-COMMITTED