IMPORTANT NOTE: if you upgrade to InnoDB-4.1.1 or higher, you cannot downgrade to a version lower than 4.1.1 any more! That is because earlier versions of InnoDB are not aware of multiple tablespaces.
Multiple tablespaces now available for InnoDB. You can store
each InnoDB type table and its indexes into a separate
.ibd
file into a MySQL database
directory, into the same directory where the
.frm
file is stored.
The MySQL query cache now works for InnoDB tables also if
AUTOCOMMIT=0
, or the statements are
enclosed inside BEGIN ... COMMIT
.
Reduced InnoDB memory consumption by a few megabytes if one sets the buffer pool size < 8 MB.
You can use raw disk partitions also in Windows.
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.