Hi! InnoDB is a MySQL table type which provides to MySQL transactions, row level locking, foreign key constraints, and a non-free hot backup tool.
InnoDB is included in all MySQL-4.0 downloads and MySQL-Max-3.23 downloads. You can download them from http://www.mysql.com. MySQL AB decided to release 4.0.6 quickly to fix recently discovered security issues in MySQL-4.0.5. For InnoDB, 4.0.6 is a bugfix release which corrects version 4.0.5 major bugs in AUTO_INCREMENT and REPLACE, INSERT INTO ... SELECT ..., and CREATE TABLE ... SELECT ... . Full changelog: * 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 1 MB of written binlog. * 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 InnoDB. * Fixed a bug introduced in 4.0.5: if binlogging was not switched on, SQL commands INSERT INTO ... SELECT ... or CREATE TABLE ... SELECT ... could cause InnoDB to hang on a semaphore created in btr0sea.c, line 128. * Fixed a bug: in replication issuing SLAVE STOP in the middle of a multi-statement transaction could cause that SLAVE START would only perform part of the transaction. A similar error could occur if the slave crashed and was restarted. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
