- 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
You can define foreign key constraints on InnoDB tables. An example: FOREIGN KEY (col1) REFERENCES table2(col2).
You can create > 4 GB datafiles in those file systems that allow it.
Improved InnoDB monitors, including a new innodb_table_monitor which allows you to print the contents of the InnoDB internal data dictionary.
DROP DATABASE will now work also for InnoDB tables.
Accent characters in the default character set latin1 will be ordered according to the MySQL ordering.<br> NOTE: if you are using latin1 and have inserted characters whose code is > 127 to an indexed CHAR column, you should run CHECK TABLE on your table when you upgrade to 3.23.43, and drop and reimport the table if CHECK TABLE reports an error!
InnoDB will calculate better table cardinality estimates.
Change in deadlock resolution: in .43 a deadlock rolls back only the SQL statement, in .44 it will roll back the whole transaction.
Deadlock, lock wait timeout, and foreign key constraint violations (no parent row, child rows exist) now return native MySQL error codes 1213, 1205, 1216, 1217, respectively.
A new my.cnf parameter innodb_thread_concurrency helps in performance tuning in high concurrency environments.
A new my.cnf option innodb_force_recovery will help you in dumping tables from a corrupted database.
A new my.cnf option innodb_fast_shutdown will speed up shutdown. Normally InnoDB does a full purge and an insert buffer merge at shutdown.
Raised maximum key length to 7000 bytes from a previous limit of 500 bytes.
Fixed a bug in replication of auto-inc columns with multiline inserts.
Fixed a bug when the case of letters changes in an update of an indexed secondary column.
Fixed a hang when there are > 24 datafiles.
Fixed a crash when MAX(col) is selected from an empty table, and col is a not the first column in a multi-column index.
Fixed a bug in purge which could cause crashes.
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.
