- 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
We again use unbuffered disk I/O in Windows. Windows XP and Windows 2000 read performance seems to be very poor with normal I/O.
Increased the max key length of InnoDB tables from 500 to 1024 bytes.
Increased the table comment field in SHOW TABLE STATUS so that up to 16000 characters of foreign key definitions can be printed there.
The auto-increment counter is no longer incremented if an insert of a row immediately fails in an error.
Allow dropping and creating a table even if innodb_force_recovery is set. One can use this to drop a table which would cause a crash in rollback or purge, or if a failed table import causes a runaway rollback in recovery.
Fixed a bug : Using ORDER BY primarykey DESC in 4.0.3 causes an assertion failure in btr0pcur.c, line 203.
Fixed a bug : fast shutdown (which is the default) sometimes was slowed down by purge and insert buffer merge.
Fixed a bug : doing a big SELECT from a table where no rows were visible in a consistent read could cause a very long (> 600 seconds) semaphore wait in btr0cur.c line 310.
Fixed a bug : if the MySQL query cache was used, it did not get invalidated by a modification done by ON DELETE CASCADE or ...SET NULL.
Fixed a bug : if you created a temporary table inside LOCK TABLES, and used that temporary table, that caused an assertion failure in ha_innodb.cc.
Fixed a bug : if you set innodb_flush_log_at_trx_commit to 1, SHOW VARIABLES would show its value as 16 million.
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.
