- Documentation Library
- Table of Contents
- MySQL 5.5 Manual
- MySQL 5.4 Manual
- MySQL 5.1 Manual
- MySQL 5.0 Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- B.4 Changes in InnoDB
- B.4.1 Changes in MySQL/InnoDB-4.0.21, September 10, 2004
- B.4.2 Changes in MySQL/InnoDB-4.1.4, August 31, 2004
- B.4.3 Changes in MySQL/InnoDB-4.1.3, June 28, 2004
- B.4.4 Changes in MySQL/InnoDB-4.1.2, May 30, 2004
- B.4.5 Changes in MySQL/InnoDB-4.0.20, May 18, 2004
- B.4.6 Changes in MySQL/InnoDB-4.0.19, May 4, 2004
- B.4.7 Changes in MySQL/InnoDB-4.0.18, February 13, 2004
- B.4.8 Changes in MySQL/InnoDB-5.0.0, December 24, 2003
- B.4.9 Changes in MySQL/InnoDB-4.0.17, December 17, 2003
- B.4.10 Changes in MySQL/InnoDB-4.1.1, December 4, 2003
- B.4.11 Changes in MySQL/InnoDB-4.0.16, October 22, 2003
- B.4.12 Changes in MySQL/InnoDB-3.23.58, September 15, 2003
- B.4.13 Changes in MySQL/InnoDB-4.0.15, September 10, 2003
- B.4.14 Changes in MySQL/InnoDB-4.0.14, July 22, 2003
- B.4.15 Changes in MySQL/InnoDB-3.23.57, June 20, 2003
- B.4.16 Changes in MySQL/InnoDB-4.0.13, May 20, 2003
- B.4.17 Changes in MySQL/InnoDB-4.1.0, April 3, 2003
- B.4.18 Changes in MySQL/InnoDB-3.23.56, March 17, 2003
- B.4.19 Changes in MySQL/InnoDB-4.0.12, March 18, 2003
- B.4.20 Changes in MySQL/InnoDB-4.0.11, February 25, 2003
- B.4.21 Changes in MySQL/InnoDB-4.0.10, February 4, 2003
- B.4.22 Changes in MySQL/InnoDB-3.23.55, January 24, 2003
- B.4.23 Changes in MySQL/InnoDB-4.0.9, January 14, 2003
- B.4.24 Changes in MySQL/InnoDB-4.0.8, January 7, 2003
- B.4.25 Changes in MySQL/InnoDB-4.0.7, December 26, 2002
- B.4.26 Changes in MySQL/InnoDB-4.0.6, December 19, 2002
- B.4.27 Changes in MySQL/InnoDB-3.23.54, December 12, 2002
- B.4.28 Changes in MySQL/InnoDB-4.0.5, November 18, 2002
- B.4.29 Changes in MySQL/InnoDB-3.23.53, October 9, 2002
- B.4.30 Changes in MySQL/InnoDB-4.0.4, October 2, 2002
- B.4.31 Changes in MySQL/InnoDB-4.0.3, August 28, 2002
- B.4.32 Changes in MySQL/InnoDB-3.23.52, August 16, 2002
- B.4.33 Changes in MySQL/InnoDB-4.0.2, July 10, 2002
- B.4.34 Changes in MySQL/InnoDB-3.23.51, June 12, 2002
- B.4.35 Changes in MySQL/InnoDB-3.23.50, April 23, 2002
- B.4.36 Changes in MySQL/InnoDB-3.23.49, February 17, 2002
- B.4.37 Changes in MySQL/InnoDB-3.23.48, February 9, 2002
- B.4.38 Changes in MySQL/InnoDB-3.23.47, December 28, 2001
- B.4.39 Changes in MySQL/InnoDB-4.0.1, December 23, 2001
- B.4.40 Changes in MySQL/InnoDB-3.23.46, November 30, 2001
- B.4.41 Changes in MySQL/InnoDB-3.23.45, November 23, 2001
- B.4.42 Changes in MySQL/InnoDB-3.23.44, November 2, 2001
- B.4.43 Changes in MySQL/InnoDB-3.23.43, October 4, 2001
- B.4.44 Changes in MySQL/InnoDB-3.23.42, September 9, 2001
- B.4.45 Changes in MySQL/InnoDB-3.23.41, August 13, 2001
- B.4.46 Changes in MySQL/InnoDB-3.23.40, July 16, 2001
- B.4.47 Changes in MySQL/InnoDB-3.23.39, June 13, 2001
- B.4.48 Changes in MySQL/InnoDB-3.23.38, May 12, 2001
InnoDBnow 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 should 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 becomes corrupt. From now on
InnoDBprevents 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.
User Comments
Add your own comment.