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.
Fixed workaround under Linux to avoid problems with
pthread_mutex_timedwait()
, which is used
with INSERT DELAYED
. See
Section 2.12.1, “Linux Notes”.
Fixed that one get a 'disk full' error message if one gets disk full when doing sorting (instead of waiting until we got more disk space).
Fixed a bug in MyISAM
with keys > 250
characters.
In MyISAM
one can now do an
INSERT
at the same time as
other threads are reading from the table.
Added max_write_lock_count
variable to mysqld to force a
READ
lock after a certain number of
WRITE
locks.
Inverted flag delay_key_write
on show variables
.
Renamed concurrency
variable to
thread_concurrency
.
The following functions are now multi-byte-safe:
LOCATE(
,
substr
,str
)POSITION(
,
substr
IN str
)LOCATE(
,
substr
,str
,pos
)INSTR(
,
str
,substr
)LEFT(
,
str
,len
)RIGHT(
,
str
,len
)SUBSTRING(
,
str
,pos
,len
)SUBSTRING(
,
str
FROM pos
FOR
len
)MID(
,
str
,pos
,len
)SUBSTRING(
,
str
,pos
)SUBSTRING(
,
str
FROM pos
)SUBSTRING_INDEX(
,
str
,delim
,count
)RTRIM(
,
str
)TRIM([[BOTH | TRAILING]
[
,
remstr
] FROM]
str
)REPLACE(
,
str
,from_str
,to_str
)REVERSE(
,
str
)INSERT(
,
str
,pos
,len
,newstr
)LCASE(
,
str
)LOWER(
,
str
)UCASE(
and
str
)UPPER(
;
patch by Wei He.
str
)
Fix core dump when releasing a lock from a nonexistent table.
Remove locks on tables before starting to remove duplicates.
Added option FULL
to
SHOW PROCESSLIST
.
Added option --verbose
to
mysqladmin.
Fixed problem when automatically converting
HEAP
to MyISAM
.
Fixed bug in HEAP
tables when doing insert
+ delete + insert + scan the table.
Fixed bugs on Alpha with
REPLACE()
and
LOAD DATA
INFILE
.
Added interactive_timeout
variable to mysqld.
Changed the argument to
mysql_data_seek()
from
ulong
to ulonglong
.
User Comments
Add your own comment.