Fonctionnalit ajoute ou modifie :
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 pread()
and pwrite()
calls if there is a long
semaphore wait.
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
will be written to a
file
every 15 seconds.
<datadir>
/innodb.status.<pid>
Bogues corrigs :
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 non-debug 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 FOREIGN KEY
,
ON UPDATE CASCADE
was not triggered if
the update changed a string to another value identical in
alphabetical ordering, e.g.,
‘abc
’ ->
‘aBc
’.
Protect the reading of the latest foreign key error
explanation buffer with a mutex; in theory, a race condition
could cause 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.
Parse CONSTRAINT FOREIGN KEY
correctly.
(Bug#3332)
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
srv0srv.c
, whether the bug shows itself.
4 bytes were overwritten with a pointer to a statically
allocated string 'get windows 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 read_key
fails with a lock wait timeout error 146.
Allow quotes to be embedded in strings in the private SQL
parser of InnoDB, so that ‘'
’
can be used in InnoDB table and column names. Display quotes
within identifiers properly.
Debugging: Allow UNIV_SYNC_DEBUG
to be
disabled while UNIV_DEBUG
is enabled.
Debugging: Handle magic numbers in a more consistent way.
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.