Hi! InnoDB is a MySQL table type which provides transactions, foreign key constraints, and a non-free hot backup tool. InnoDB is included in all versions of MySQL-4.0. You can download MySQL-4.0 from http://www.mysql.com.
As the MySQL-4.0 branch approaches declaration of stability, this InnoDB release contains only bug fixes and minor improvements. InnoDB users who have experienced table locking problems when running reports of type CREATE TABLE ... SELECT ... or INSERT INTO ... SELECT ... will find the first changelog item below welcome. Full changelog: * In INSERT INTO t1 SELECT ... FROM t2 WHERE ... MySQL previously set a table level read lock on t2. This lock is now removed. * Increased SHOW INNODB STATUS max printed length to 200 kB. * Fixed a major bug in InnoDB query optimization: queries of type SELECT ... WHERE indexfirstcolumn < x and SELECT ... WHERE indexfirstcolumn > x could cause a table scan even if the selectivity would have been very good. * Fixed a bug: purge could cause a hang in a BLOB table where the primary key index tree was of height 1. Symptom: semaphore waits caused by an X-latch set in btr_free_externally_stored_field(). * Fixed a bug: using InnoDB HANDLER commands on a fresh handle crashed mysqld in ha_innobase::change_active_index(). * Fixed a bug: if MySQL estimated a query in the middle of a SELECT statement, InnoDB could hang on the adaptive hash index latch in btr0sea.c. * Fixed a bug: InnoDB could report table corruption and assert in page_dir_find_owner_slot() if an adaptive hash index search coincided with purge or an insert. * Fixed a bug: some file system snapshot tool in Windows 2000 could cause an InnoDB file write to fail with error 33 ERROR_LOCK_VIOLATION. In synchronous writes InnoDB now retries the write 100 times at 1 second intervals. * Fixed a bug: SQL command REPLACE INTO t1 SELECT ... did not work if t1 has an auto-inc column. * An outstanding bug: SET FOREIGN_KEY_CHECKS=0 is not replicated properly in the MySQL replication. 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
