D.4.13 Changes in release 3.23.46 (29 Nov 2001)

• Fixed problem with aliased temporary table replication.
• InnoDB and BDB tables will now use index when doing an ORDER BY on the whole table.
• Fixed bug where one got an empty set instead of a DEADLOCK error when using BDB tables.
• One can now kill ANALYZE, REPAIR, and OPTIMIZE TABLE when the thread is waiting to get a lock on the table.
• Fixed race condition in ANALYZE TABLE.
• Fixed bug when joining with caching (unlikely to happen).
• Fixed race condition when using the binary log and INSERT DELAYED which could cause the binary log to have rows that were not yet written to MyISAM tables.
• Changed caching of binary log to make replication slightly faster.
• Fixed bug in replication on Mac OS X.

User Comments

A useful index to the updates may be found at <a
href='http://www.bitbybit.dk/mysqlfaq'>http://www.
bitbybit.dk/mysqlfaq</a>. This index contains the
changes grouped by concept, making it easy to
find out when a particular feature/bug was
added/fixed.

It is great..really great...We are expecting
mysql will update itslf by forseeing new demands
and hence to support your large customer base.
And also expecting a new mysql version with full
support for Foreign Key

Good job guys, I always enjoy new releases. My
only wishlist item is for speed improvements on
super huge tables (1M+ records). "DELETE FROM
table WHERE keycolumn='someval'" really could use
some speed improvement. Also it would be cool if
there was a way to force OPTIMIZE for some
deletes so it's not an extra command to clean out
the rows flagged for removal.

Add your own comment.