Hi! InnoDB is a MySQL table type which supports transactions, row level locking, foreign key constraints, and a non-free hot backup tool.
InnoDB is included in all MySQL-4.0 downloads, and in MySQL-Max-3.23 downloads at http://www.mysql.com. The release 4.0.8 adds a small new feature that has been requested by several users. You can now also set an ON UPDATE CASCADE action on a foreign key constraint. The free space margin in InnoDB was reduced from 5 % to 1 %. This means you have 4 % more space in your tablespace for storing tables and indexes. No conversion of tables is needed to take advantage of this extra space, just an upgrade to 4.0.8 is enough. Full changelog: * InnoDB now supports also the SQL syntax FOREIGN KEY (...) REFERENCES ...(...) [ON UPDATE CASCADE | ON UPDATE SET NULL | ON UPDATE RESTRICT | ON UPDATE NO ACTION]. * Tables and indexes now reserve 4 % less space in the tablespace. Also existing tables reserve less space. By upgrading to 4.0.8 you will see more free space in "InnoDB free" in SHOW TABLE STATUS. * Fixed bugs: updating the PRIMARY KEY of a row would generate a foreign key error on all FOREIGN KEYs which referenced secondary keys of the row to be updated. Also, if a referencing FOREIGN KEY constraint only referenced the first columns in an index, and there were more columns in that index, updating the additional columns generated a foreign key error. These bug fixes will only be backported to 3.23 if users find this a big problem. * Fixed a bug: if an index contains some column twice, and that column is updated, the table will become corrupt. From now on InnoDB prevents creation of such indexes. * Fixed a bug: removed superfluous error 149 and 150 printouts from the .err log when a locking SELECT caused a deadlock or a lock wait timeout. * Fixed a bug: an assertion in btr0sea.c, in function btr_search_info_update_slow could theoretically fail in a race of 3 threads. * Fixed a bug: one could not switch a session transaction isolation level back to REPEATABLE READ after setting it to something else. Best regards, Heikki Tuuri Innobase Oy --------------------------------------------------------------------- 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
