Functionality added or changed:
Better error message when the server has to crash because the buffer pool is exhausted by the lock table or the adaptive hash index.
Print always the count of pending
pwrite() calls if there is a long
Improve space utilization when rows of 1,500 to 8,000 bytes are inserted in the order of the primary key.
Remove potential buffer overflow errors by sending diagnostic
output to stderr or files instead of stdout or fixed-size
memory buffers. As a side effect, the output of
SHOW INNODB STATUS is written
to a file
every 15 seconds.
Fixed a bug:
DROP DATABASE did
not work if
FOREIGN KEY references were
defined within the database. (Bug #3058)
Remove unnecessary files, functions and variables. Many of these were needed in the standalone version of InnoDB. Remove debug functions and variables from nondebug build.
Add diagnostic code to analyze an assertion failure in ha_innodb.cc on line 2020 reported by a user. (Bug #2903)
Fixed a bug: in a
UPDATE CASCADE was not triggered if the update
changed a string to another value identical in alphabetic
ordering, for example, “
Protect the reading of the latest foreign key error
explanation buffer with a mutex; in theory, a race condition
SHOW INNODB STATUS
print garbage characters after the error info.
Fixed a bug: The row count and key cardinality estimate was grossly too small if each clustered index page only contained one record.
CONSTRAINT FOREIGN KEY correctly.
Fixed a memory corruption bug on Windows. The bug is present
in all InnoDB versions in Windows, but it depends on how the
linker places a static array in
whether the bug shows itself. 4 bytes were overwritten with a
pointer to a statically allocated string '
aio return value'.
Fix a glitch reported by Philippe Lewicki on the general
mailing list: do not print a warning to the
.err log if
fails with a lock wait timeout error 146.
Permit quotation marks to be embedded in strings in the
private SQL parser of InnoDB, so that
'” can be used in InnoDB
table and column names. Display quotation marks within
UNIV_SYNC_DEBUG to be
UNIV_DEBUG is enabled.
Debugging: Handle magic numbers in a more consistent way.