End of Product Lifecycle. Active development and support for MySQL database server versions 3.23, 4.0, and 4.1 has ended. However, for MySQL 4.0 and 4.1, there is still extended support available. For details, see http://www.mysql.com/company/legal/lifecycle/#calendar. According to the MySQL Lifecycle Policy (see http://www.mysql.com/company/legal/lifecycle/#policy), only Security and Severity Level 1 issues will still be fixed for MySQL 4.0 and 4.1. Please consider upgrading to a recent version (MySQL 5.0 or 5.1).
Fixed workaround under Linux to avoid problems with
pthread_mutex_timedwait(), which is used
with INSERT DELAYED. See
Section 2.13.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 non-existent 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.