Fixed that databasename
works as second
argument to mysqlhotcopy
.
The values for the UMASK
and
UMASK_DIR
environment variables now can
be specified in octal by beginning the value with a zero.
Added RIGHT JOIN
. This makes
RIGHT
a reserved word.
Added @@IDENTITY
as a synonym for
LAST_INSERT_ID()
. (This is for MSSQL
compatibility.)
Fixed a bug in myisamchk
and
REPAIR
when using
FULLTEXT
index.
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 log-bin
option.
Fixed a bug in MyISAM
with packed
multi-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 CHECK TABLE
.
The MyISAM
repair/reindex code didn't use
the --tmpdir
option for its temporary
files.
Added BACKUP TABLE
and RESTORE
TABLE
.
Fixed core dump on CHANGE MASTER TO
when
the slave did not have the master to start with.
Fixed incorrect 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 filename argument
to --log-bin
.
Added missing 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.
Added --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
項7.2. 「MERGE
テーブル」.
Fixed bug in mysqldump
from 3.23 which
caused some CHAR
columns not to be
quoted.
Merged analyze
, check
,
optimize
and repair code.
OPTIMIZE TABLE
is now mapped to
REPAIR
with statistics and sorting of the
index tree. This means that for the moment it only works on
MyISAM
tables.
Added a pre-alloced block to root_malloc to get fewer mallocs.
Added a lot of new statistics variables.
Fixed ORDER BY
bug with
BDB
tables.
Removed warning that mysqld
couldn't
remove the .pid
file under Windows.
Changed --log-isam
to log
MyISAM
tables instead of isam tables.
Fixed CHECK TABLE
to work on Windows.
Added file mutexes to make pwrite()
safe
on Windows.
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.