Software Update: MySQL 3.23.47

Spread the love

Stephan Oudmaijer informs us that a new MySQL is available for download. The changelog isn’t that huge this time around, so it’s below:

  • InnoDB now supports NULL in keys.
  • Fixed shutdown problem on HPUX. (Introduced in 3.23.46)
  • Added ‘DO expression’ command.
  • Fixed core dump bug in replication when using SELECT RELEASE_LOCK();
  • Added new statement DO expression,[expression]†
  • Added slave-skip-errors option
  • Added statistics variables for all MySQL commands. (SHOW STATUS is now much longer).
  • Fixed default values ​​for InnoDB tables.
  • Fixed that GROUP BY expr DESC works.
  • Fixed bug when using t1 LEFT JOIN t2 ON t2.key=constant.
  • mysql_config now also work with binary (relocated) distributions.

[break] MySQL 3.23.47-Max has some important bug fixes for users of InnoDB tables. ORDER BY and DISTINCT queries on large tables have better performance in this version. For information, see the InnoDB changelog and InnoDB bugfix page† [/break]

MySQL/InnoDB-3.23.47

  • InnoDB allows now several similar key values ​​in a UNIQUE secondary index if those values ​​contain SQL NULLs. Thus the convention is now the same as in MyISAM tables.
  • InnoDB gives a better row count estimate for a table which contains BLOBs.
  • In a FOREIGN KEY constraint InnoDB is now case-insensitive to column names, and in Windows also to table names.
  • InnoDB allows a FOREIGN KEY column of CHAR type to refer to a column of VARCHAR type, and vice versa. MySQL silently changes the type of some columns between CHAR and VARCHAR, and these silent changes do not hinder FOREIGN KEY declaration any more.
  • Recovery has been made more resilient to corruption of log files.
  • Unnecessary statistics calculation has been removed from queries which generate a temporary table. Some ORDER BY and DISTINCT queries will now run much faster.
  • MySQL now knows that the table scan of an InnoDB table is done through the primary key. This will save a sort in some ORDER BY queries.
  • The maximum key length of InnoDB tables is again restricted to 500 bytes. The MySQL interpreter is not able to handle longer keys.

Version number 3.23.47
Operating systems Windows 9x, Windows NT, Windows 2000, Linux, BSD, Windows XP, Linux x86, UNIX
Website MySQL
Download
You might also like