Hi! InnoDB is a MySQL table type which provides transactions, row level locking, foreign key constraints, and a non-free hot backup tool.
InnoDB is included in all MySQL-4.0 and MySQL-4.1 downloads from http://www.mysql.com. MySQL-4.0 is the stable version which is recommended for production use. Release 4.0.15 contains a few bug fixes. The bugs only affected a minority of users. The full changelog: * Fixed a bug: if you updated a row so that the 8000 byte maximum length (without BLOB and TEXT) was exceeded, InnoDB simply removed the record from the clustered index. In a similar insert, InnoDB would leak reserved file space extents, which would only be freed at the next mysqld startup. * Fixed a bug: if you used big BLOBs, and your log files were relatively small, InnoDB could in a big BLOB operation temporarily write over the log produced AFTER the latest checkpoint. If InnoDB would crash at that moment, then the crash recovery would fail, because InnoDB would not be able to scan the log even up to the latest checkpoint. Starting from this version, InnoDB tries to ensure the latest checkpoint is young enough. If that is not possible, InnoDB prints a warning to the .err log of MySQL and advises you to make the log files bigger. * Fixed a bug: setting innodb_fast_shutdown=0 had no effect. * Fixed a bug introduced in 4.0.13: if a CREATE TABLE ended in a comment, that could cause a memory overrun. * Fixed a bug: If InnoDB printed 'Operating system error number .. in a file operation' to the .err log in Windows, the error number explanation was wrong. Workaround: look at the InnoDB Reference Manual section 13.2 about Windows error numbers. * Fixed a bug: If you created a column prefix PRIMARY KEY like in t(a CHAR(200), PRIMARY KEY (a(10))) on a fixed-length CHAR column, InnoDB would crash even in a simple SELECT. CHECK TABLE would report the table as corrupt, also in the case where the created key was not PRIMARY. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]