- Documentation Library
- Table of Contents
- MySQL 5.0 Manual
- Table of Contents
- C.9 Evolutions de InnoDB
- C.9.1 MySQL/InnoDB-4.0.21, pas publiée
- C.9.2 MySQL/InnoDB-4.1.4, 31 Août 2004
- C.9.3 MySQL/InnoDB-4.1.3, 28 Juin 2004
- C.9.4 MySQL/InnoDB-4.1.2, pas publiée
- C.9.5 MySQL/InnoDB-4.0.20, 18 mai 2004
- C.9.6 MySQL/InnoDB-4.0.19, 4 mai 2004
- C.9.7 MySQL/InnoDB-4.0.18, 13 février 2004
- C.9.8 MySQL/InnoDB-5.0.0, 24 décembre 2003
- C.9.9 MySQL/InnoDB-4.0.17, 17 décembre 2003
- C.9.10 MySQL/InnoDB-4.1.1, 4 décembre 2003
- C.9.11 MySQL/InnoDB-4.0.16, 22 octobre 2003
- C.9.12 MySQL/InnoDB-3.23.58, 15 septembre 2003
- C.9.13 MySQL/InnoDB-4.0.15, 10 septembre 2003
- C.9.14 MySQL/InnoDB-4.0.14, 22 juillet 2003
- C.9.15 MySQL/InnoDB-3.23.57, 20 juin 2003
- C.9.16 MySQL/InnoDB-4.0.13, 20 mai 2003
- C.9.17 MySQL/InnoDB-4.1.0, 3 avril 2003
- C.9.18 MySQL/InnoDB-3.23.56, 17 mars 2003
- C.9.19 MySQL/InnoDB-4.0.12, 18 mars 2003
- C.9.20 MySQL/InnoDB-4.0.11, 25 février 2003
- C.9.21 MySQL/InnoDB-4.0.10, 4 février 2003
- C.9.22 MySQL/InnoDB-3.23.55, 24 janvier 2003
- C.9.23 MySQL/InnoDB-4.0.9, 14 janvier 2003
- C.9.24 MySQL/InnoDB-4.0.8, 7 janvier 2003
- C.9.25 MySQL/InnoDB-4.0.7, 26 décembre 2002
- C.9.26 MySQL/InnoDB-4.0.6, 19 décembre 2002
- C.9.27 MySQL/InnoDB-3.23.54, 12 dcembre 2003
- C.9.28 MySQL/InnoDB-4.0.5, 18 novembre 2002
- C.9.29 MySQL/InnoDB-3.23.53, 9 octobre 2002
- C.9.30 MySQL/InnoDB-4.0.4, 2 octobre 2002
- C.9.31 MySQL/InnoDB-4.0.3, 28 août 2002
- C.9.32 MySQL/InnoDB-3.23.52, 16 août 2002
- C.9.33 MySQL/InnoDB-4.0.2, 10 juillet 2002
- C.9.34 MySQL/InnoDB-3.23.51, 12 juin 2002
- C.9.35 MySQL/InnoDB-3.23.50, 23 avril 2002
- C.9.36 MySQL/InnoDB-3.23.49, 17 février 2002
- C.9.37 MySQL/InnoDB-3.23.48, 9 février 2002
- C.9.38 MySQL/InnoDB-3.23.47, 28 décembre 2001
- C.9.39 MySQL/InnoDB-4.0.1, 3 décembre 2001
- C.9.40 MySQL/InnoDB-3.23.46, 30 novembre 2001
- C.9.41 MySQL/InnoDB-3.23.45, 23 novembre 2001
- C.9.42 MySQL/InnoDB-3.23.44, 2 novembre 2001
- C.9.43 MySQL/InnoDB-3.23.43, 4 octobre 2001
- C.9.44 MySQL/InnoDB-3.23.42, 9 septembre 2001
- C.9.45 MySQL/InnoDB-3.23.41, 13 août 2001
- C.9.46 MySQL/InnoDB-3.23.40, 16 juillet 2001
- C.9.47 MySQL/InnoDB-3.23.39, 13 juin 2001
- C.9.48 MySQL/InnoDB-3.23.38, 12 mai 2001
InnoDB now supports also 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.
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.
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.
