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:
libmysqld.c is now 1024*1024*1024.
You can now specify
max_allowed_packet in a file read by
mysql_options(MYSQL_READ_DEFAULT_FILE). for clients.
When sending a too big packet to the server with the not compressed protocol, the client now gets an error message instead of a lost connection.
We now send big queries/result rows in bigger hunks, which should give a small speed improvement.
Fixed some bugs with the compressed protocol for rows > 16MB.
InnoDB tables now also support
ON UPDATE CASCADE in
FOREIGN KEY constraints. See the
InnoDB section in the manual for the
Fixed bug in
ALTER TABLE with
Fixed core dump bug in
Fixed a bug in handling communication packets bigger than 16MB. Unfortunately this required a protocol change; If you upgrade the server to 4.0.8 and above and have clients that use packets >= 255*255*255 bytes (=16581375) you must also upgrade your clients to at least 4.0.8. If you don't upgrade, the clients hang when sending a big packet.
Fixed bug when sending blobs longer than 16MB to client.
Fixed bug in
GROUP BY when used on BLOB column with
Fixed a bug in handling
NULL values in