Hi! InnoDB is a MySQL table type which offers transactions, row level locking, foreign key constraints, and a non-free hot backup tool.
InnoDB is included in MySQL-Max-3.23 and all MySQL-4.0 downloads available at http://www.mysql.com. MySQL AB decided to release MySQL-4.0.7 just a week after 4.0.6 to fix a security issue in mysql_drop_db() in 4.0. InnoDB in 4.0.7 allows a user to define for a FOREIGN KEY constraints also ON UPDATE actions. This new feature has been requested by several users during the past year. As a special Christmas present you now have 4 % more free space in your tablespace to use for storage of tables and indexes. That is possible because the free space margin in InnoDB was reduced from 5 % to 1 % of the tablespace size. No conversion of tables is needed. You get the bonus space simply by upgrading to 4.0.7. 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.7 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. * 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 and 150 printouts from the .err log when a locking SELECT caused a deadlock or a lock wait timeout. I wish a prosperous New Year to all MySQL/InnoDB users! 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