Added user level lock functions
GET_LOCK(string,timeout)
,
RELEASE_LOCK(string)
.
Added Opened_tables
to show
status
.
Changed connect timeout to 3 seconds to make it somewhat
harder for crackers to kill mysqld
through telnet + TCP/IP.
Fixed bug in range optimiser when using WHERE
key_part_1 >= something AND key_part_2 <=
something_else
.
Changed configure
for detection of
FreeBSD 3.0 9803xx and above
WHERE
with string_col_key =
constant_string
didn't always find all rows if the
column had many values differing only with characters of the
same sort value (like e and e with an accent).
Strings keys looked up with 'ref' were not compared in case-sensitive fashion.
Added umask()
to make log files
non-readable for normal users.
Ignore users with old (8-byte) password on startup if not
using --old-protocol
option to
mysqld
.
SELECT
which matched all key fields
returned the values in the case of the matched values, not
of the found values. (Minor problem.)
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.