- 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 transaction isolation levels READ COMMITTED and READ UNCOMMITTED. READ COMMITTED more closely emulates Oracle and makes porting of applications from Oracle to MySQL easier.
Deadlock resolution is now selective: we try to pick as victims transactions with less modified or inserted rows.
FOREIGN KEY definitions are now aware of the lower_case_table_names setting in my.cnf.
SHOW CREATE TABLE does not output the database name to a FOREIGN KEY definition if the referred table is in the same database as the table.
InnoDB does a consistency check to most index pages before writing them to a datafile.
If you set innodb_force_recovery > 0, InnoDB tries to jump over corrupt index records and pages when doing SELECT * FROM table. This helps in dumping.
InnoDB now again uses asynchronous unbuffered I/O in Windows 2000 and XP; only unbuffered simulated async I/O in NT, 95/98/ME.
Fixed a bug : the InnoDB range estimator greatly exaggerated the size of a short index range if the paths to the endpoints of the range in the index tree happened to branch already in the root. This could cause unnecessary table scans in SQL queries. The fix will also be backported to 3.23.54.
Fixed a bug present in 3.23.52, 4.0.3, 4.0.4: InnoDB startup could take very long or even crash on some Windows 95/98/ME computers.
Fixed a bug : the AUTO-INC lock was held to the end of the transaction if it was granted after a lock wait. This could cause unnecessary deadlocks.
Fixed a bug : if SHOW INNODB STATUS, innodb_monitor, or innodb_lock_monitor had to print several hundred transactions in one report, and the output became truncated, InnoDB would hang, printing to the error log many waits for a mutex created at srv0srv.c, line 1621.
Fixed a bug : SHOW INNODB STATUS on Unix always reported average file read size as 0 bytes.
Fixed a potential bug in 4.0.4: InnoDB now does ORDER BY ... DESC like MyISAM.
Fixed a bug : DROP TABLE could cause crash or a hang if there was a rollback concurrently running on the table. The fix will only be backported to 3.23 if this appears a real problem for users.
Fixed a bug : ORDER BY could fail if you had not created a primary key to a table, but had defined several indexes of which at least one was a UNIQUE index with all its columns declared as NOT NULL.
Fixed a bug : a lock wait timeout in connection with ON DELETE CASCADE could cause corruption in indexes.
Fixed a bug : if a SELECT was done with a unique key from a primary index, and the search matched to a delete-marked record, InnoDB could return the NEXT record.
Outstanding bugs: in 4.0.4 two bugs were introduced to AUTO_INCREMENT. REPLACE can cause the counter to be left 1 too low. A deadlock or a lock wait timeout can cause the same problem. These will be fixed in 4.0.6.
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.
