Released on 10 Dec 1999
MySQL 3.23.7 Changelog

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 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(str) and UPPER(str); patch by Wei He.

  • 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.