End of Product Lifecycle. Active development and support for MySQL Database Server versions 3.23, 4.0, and 4.1 has ended. For details, see http://www.mysql.com/about/legal/lifecycle/#calendar. Please consider upgrading to a recent version. Further updates to the content of this manual will be minimal. All formats of this manual will continue to be available until 31 Dec 2010.
Functionality added or changed:
InnoDB: The new Windows installation wizard
of MySQL makes
InnoDB as the MySQL default
table type on Windows, unless explicitly specified otherwise.
Note that it places the
my.ini file in the
installation directory of the MySQL server. See
Section 220.127.116.11, “The Location of the my.ini File”.
InnoDB: Added the configuration option
setting the size in megabytes by which
tablespaces are extended when they become full. The default
value is 8, corresponding to the fixed increment of 8MB in
previous versions of MySQL.
Detection of using the same table for updating and selecting in multi-update queries was not done correctly. (Bug#5455)
InnoDB: A maximum of 1000 connections could
InnoDB at the same time, a
higher number causing an assertion failure. Now the maximum can
be much higher, and depends on the buffer pool size.
After reaching a certain limit of prepared statements per connection (97), statement IDs began to overlap, so occasionally wrong statements were chosen for execution. (Bug#5399)
The values of the
variables now are stored in the query cache with other query
information to avoid returning an incorrect result from the
Name resolution of external columns of subqueries was done correctly if the subquery was placed in the select list of the outer query and used grouping. (Bug#5326)
Executing a statement containing thousands of placeholders
caused a buffer overflow in the prepared statements API
The internal field length of integer user variables was
incorrect. This showed up when creating a table as
A prepared statement using
LIKE and called
with arguments in different character sets caused the server to