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.
system command to mysql.
Fixed bug when
HANDLER was used with some unsupported table type.
mysqldump now puts
ALTER TABLE and
tbl_name DISABLE KEYS
ALTER TABLE in the sql dump.
tbl_name ENABLE KEYS
Added mysql_fix_extensions script.
Fixed stack overrun problem with
LOAD DATA FROM MASTER on OSF/1.
Fixed shutdown problem on HP-UX.
FLUSH DES_KEY_FILE statement.
--des-key-file option to mysqld.
HEX( now returns the characters in
str converted to hexadecimal.
Fixed problem with
GRANT when using
lower_case_table_names = 1.
SELECT ... IN SHARE MODE to
SELECT ... LOCK IN SHARE MODE (as in MySQL 3.23).
A new query cache to cache results from identical
Fixed core dump bug on 64-bit machines when it got an incorrect communication packet.
MATCH ... AGAINST(... IN BOOLEAN MODE) can now work without
Fixed slave to replicate from 3.23 master.
Miscellaneous replication fixes/cleanup.
Got shutdown to work on Mac OS X.
myisam/ft_dump utility for low-level inspection of
Fixed bug in
DELETE ... WHERE ... MATCH ....
Added support for
MATCH ... AGAINST(... IN BOOLEAN MODE). Note that you must rebuild your tables with
ALTER TABLE to be able to use boolean full-text search.
INSTR() are now case sensitive if either argument is a binary string.
RAND() initialization so that
RAND(N+1) are more distinct.
Fixed core dump bug in
UPDATE ... ORDER BY.
INSERT INTO ... SELECT always had
IGNORE enabled. Now MySQL stops (and possibly rolls back) by default in case of an error unless you specify
DATA DIRECTORY and
INDEX DIRECTORY directives on Windows.
Added boolean full-text search code. It should be considered early alpha.
ALTER TABLE to accept the
Indexes are now used with
ORDER BY on a whole