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.
databasename works as second argument to mysqlhotcopy.
The values for the
UMASK_DIR environment variables now can be specified in octal by beginning the value with a zero.
RIGHT JOIN. This makes
RIGHT a reserved word.
@@identity as a synonym for
LAST_INSERT_ID(). (This is for MSSQL compatibility.)
Fixed a bug in myisamchk and
REPAIR TABLE when using
LOAD DATA INFILE now works with FIFOs. (Patch by Toni L. Harbaugh-Blackford.)
FLUSH LOGS broke replication if you specified a log name with an explicit extension as the value of the
Fixed a bug in
MyISAM with packed multiple-part keys.
Fixed crash when using
CHECK TABLE on Windows.
Fixed a bug where
FULLTEXT index always used the
koi8_ukr character set.
Fixed privilege checking for
MyISAM repair/reindex code didn't use the
--tmpdir option for its temporary files.
BACKUP TABLE and
Fixed core dump on
CHANGE MASTER TO when the slave did not have the master to start with.
Time in the processlist for
Connect of the slave thread.
The slave now logs when it connects to the master.
Fixed a core dump bug when doing
FLUSH MASTER if you didn't specify a file name argument to
ha_berkeley.x files to the MySQL Windows distribution.
Fixed some mutex bugs in the log code that could cause thread blocks if new log files couldn't be created.
Added lock time and number of selected processed rows to slow query log.
--memlock option to mysqld to lock mysqld in memory on systems with the
mlockall() call (as in Solaris).
HEAP tables didn't use keys properly. (Bug from 3.23.23.)
Added better support for
MERGE tables (keys, mapping, creation, documentation...). See Section 13.3, “The MERGE Storage Engine”.
Fixed bug in mysqldump from 3.23 which caused some
CHAR columns not to be quoted.
optimize and repair code.
OPTIMIZE TABLE is now mapped to
REPAIR TABLE with statistics and sorting of the index tree. This means that for the moment it only works on
Added a pre-alloced block to root_malloc to get fewer mallocs.
Added a lot of new statistics variables.
ORDER BY bug with
Removed warning that mysqld couldn't remove the
.pid file under Windows.
--log-isam to log
MyISAM tables instead of isam tables.
CHECK TABLE to work on Windows.
Added file mutexes to make
pwrite() safe on Windows.