Software update: MySQL 3.23.40

MySQL AB today released a new stable release of MySQL. Version 3.23.40 includes an important bug fix related to MySQL replication and is therefore worth it for the people who use it in any case. You can use the source code and binaries as usual from this link refuel inside. Below the complete changelog†

• Multi table DELETE.
• Don’t anymore support old client protocols prior to MySQL 3.21.
• Don’t include the old C API functions mysql_drop_db, mysql_create_db and mysql_connect, if not compiled with
• USE_OLD_FUNCTIONS.
• Renamed safe_mysqld to mysqld_safe.
• Allow one to use IN instead of FROM in SHOW commands.
• SHOW INDEXES is now a synonym for SHOW INDEX.
• Added support for symbolic links to MyISAM tables. Symlink handling is now enabled by default for Windows.
• LOAD DATA FROM MASTER “auto-magically” sets up a slave.
• A new HANDLER interface to MyISAM tables.
• COUNT(DISTINCT) is about 30% faster.
• Creating full text indexes are now much faster.
• Searching on packed (CHAR/VARCHAR) keys are now much faster.
• Added SQL_CALC_FOUND_ROWS and FOUND_ROWS(). This makes it possible to know how many rows a query would have returned without a LIMIT clause.
• Changed output format of SHOW OPEN TABLES.
• Allow SELECT expression LIMIT ….
• Added IDENTITY as a synonym for AUTO_INCREMENT (like Sybase).
• Added ORDER BY syntax to UPDATE and DELETE.
• Optimized queries of type: SELECT DISTINCT * from table_name ORDER by key_part1 LIMIT #