As usual, the number of improvements this version is impressive
MySQL, one of the most popular open source database in the world, has just reached version 5.6.9 RC.As usual, any new version of MySQL brings lots of improvements and version 5.6.9 RC makes no exception, even if it's not a stable and final version (which should be available soon).
Highlights of MySQL 5.6.9 RC:
• The --random-passwords option for mysql_install_db is now supported for MySQL install operations (but not the upgrades), using Solaris PKG packages.
• The gtid_done server system variable has been renamed to gtid_executed;
mysqld now writes dates to the error log in ISO (YYYY-MM-DD hh:mm:ss) format;
• The timing values for low-level InnoDB read operations were adjusted for better performance with fast storage devices, such as SSD;
• The THREAD_ID column in Performance Schema tables was widened from INT to BIGINT to accommodate 64-bit values;
• Connection IDs now are permitted to be 64-bit values, when the server supports them (when built with 64-bit data types);
• mysql_thread_id() has remained unchanged and the client/server protocal has only 4 bytes for the ID value. This function returns an incorrect (truncated) value for connection IDs larger than 32 bits and should be avoided;
• A DML statement using the index merge access method could lock many rows from the table, even when those rows were not part of the final result set;
• The value of the Seconds_Behind_Master column in the output of SHOW SLAVE STATUS was always set to NULL whenever the SQL thread or the I/O thread was stopped, but now the column is set to NULL only if the SQL thread is not running.
A complete list of fixed bugs, updates and new features can be found in the comprehensive official announcement.
Download MySQL 5.6.9 RC right now from Softpedia. Remember that this is a development version and it should NOT be installed on production machines. It is intended for testing purposes only.