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.
HIGH_PRIORITY option to
INSERT. This overrides the effect of the
--low-priority-updates server option and does not perform concurrent inserts.
ALTER TABLE syntax.
tbl_name ADD (field_list)
Fixed problem with optimizer that could sometimes use incorrect keys.
GRANT/REVOKE ALL PRIVILEGES doesn't affect
Removed extra “
)” from the output of
Fixed problem when storing numbers in timestamps.
Fix problem with time zones that have half hour offsets.
Permit the syntax
UNIQUE INDEX in
mysqlhotcopy - fast online hot-backup utility for local MySQL databases. By Tim Bunce.
New more secure mysqlaccess. Thanks to Steve Harvey for this.
--safe-updates options to mysql.
max_join_size variables to mysql.
READ LOCAL lock that doesn't lock the table for concurrent inserts. (This is used by mysqldump.)
LOCK TABLES ... READ no longer permits concurrent inserts.
--skip-delay-key-write option to mysqld.
Fixed security problem in the protocol regarding password checking.
_rowid can now be used as an alias for an integer type unique indexed column.
Added back blocking of
SIGPIPE when compiling with
--thread-safe-clients to make things safe for old clients.