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, which you can download from http://www.mysql.com/downloads/mysql-4.0.html.

MySQL-4.0.12 is a bugfix release of the MySQL-4.0 branch, which will soon be declared stable.

Full changelog:

* In crash recovery InnoDB now prints progress information about the rollback of large transactions.

* Fixed a bug/feature: if your application program used mysql_use_result(), and used >= 2 connections to send SQL queries, it could deadlock on the adaptive hash S-latch in btr0sea.c. Now mysqld releases the S-latch whenever it passes data from a SELECT to the client.

* Fixed a bug: MySQL could erroneously return 'Empty set' if InnoDB estimated an index range size to 0 records though the range was not empty; MySQL also failed to do the next-key locking in the case of an empty index range.

* An outstanding bug: SQL command SET FOREIGN_KEY_CHECKS=0 is not replicated properly in the MySQL replication.

Best regards,

Heikki Innobase Oy http://www.innodb.com - read the up-to-date InnoDB manual at http://www.innodb.com/ibman.html