Since innodb_log_arch_dir has no relevance under MySQL, there is no need to specify it any more in my.cnf.
LOAD DATA INFILE in
autocommit = 1 mode no longer
does implicit commits for each 1MB of written binary log.
Fixed a bug introduced in 4.0.4: LOCK TABLES ... READ LOCAL should not set row locks on the rows read. This caused deadlocks and lock wait timeouts in mysqldump.
Fixed two bugs introduced in 4.0.4: in AUTO_INCREMENT, REPLACE could cause the counter to be left 1 too low. A deadlock or a lock wait timeout could cause the same problem.
Fixed a bug: TRUNCATE on a TEMPORARY table crashed
Fixed a bug introduced in 4.0.5: If binary logging was not
switched on, INSERT INTO ... SELECT ... or CREATE TABLE ...
SELECT ... could cause
InnoDB to hang on a
semaphore created in btr0sea.c, line 128. Workaround: switch
binary logging on.
Fixed a bug: in replication issuing STOP SLAVE in the middle of a multiple-statement transaction could cause that START SLAVE would only perform a part of the transaction. A similar error could occur if the slave crashed and was restarted.