Hi! InnoDB is a table type which provides row level locking, transactions, and foreign key constraints to MySQL. It is included in the MySQL -Max distributions in the 3.23 series, and to all distributions of MySQL-4.0.
InnoDB release in MySQL-3.23.45 is a bugfix release. * In versions 3.23.42-.44, when creating a table on Windows, you have to use lower case letters in the database name to be able to access the table. Fixed in 3.23.45. * InnoDB now flushes stdout and stderr every 10 seconds: if these are redirected to files, the file contents can be better viewed with an editor. * Fixed an assertion failure in .44, in trx0trx.c, line 178 when you drop a table which has the .frm file but does not exist inside InnoDB. * Fixed a bug in the insert buffer. The insert buffer tree could get into an inconsistent state, causing a crash, and also crashing the recovery. This bug could appear especially in large table imports or alterations. * Fixed a bug in recovery: InnoDB could go into an infinite loop constantly printing a warning message that it cannot find free blocks from the buffer pool. * Fixed a bug: when you created a temporary table of the InnoDB type, and then used ALTER TABLE to it, the MySQL server could crash. * Prevented creation of MySQL system tables 'mysql.user', 'mysql.host', or 'mysql.db', in the InnoDB type. * Fixed a bug which can cause an assertion failure in 3.23.44 in srv0srv.c, line 1728. -- There are two known bugs which were not yet fixed in 3.23.45: * In a FOREIGN KEY constraint, on Windows you must specify the referenced table name always in lower case, and on both Unix and Windows you must specify the column names in the constraint in the same case as in the table creation. * If a table contains big BLOBs, then InnoDB gives much too big estimates for the rowcount in SHOW TABLE STATUS. 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