MySQL, one of the most popular open source database in the world, has just reached version 5.5.28.As usual, any new version of MySQL brings lots of improvements and version 5.5.28 makes no exception. The number of changes is impressive, starting with the addition of a much-anticipated MySQL Enterprise Audit plugin.
Highlights of MySQL 5.5.28:
• MySQL Enterprise Edition subscriptions now include MySQL Enterprise Audit, which has been implemented using a server plugin named audit_log. This means that MySQL Audit API will enable standard, policy-based monitoring and logging of connection and query activity executed on specific MySQL server;
• The internal interface of the Thread Pool plugin has been modified, but older versions will work with the current ones:
• Certain information_schema tables originally introduced in MySQL 5.6 are now also available in MySQL 5.5 and MySQL 5.1;
• When a SELECT ... FOR UPDATE, UPDATE, or other SQL statement scanned rows in an InnoDB table using a < or <= operator in a WHERE clause, the next row after the affected range could also be locked. This particular issue occurred under various isolation levels, but it has now been fixed.
• Another fix was implemented for tables using PARTITION BY HASH or PARTITION BY KEY, when the partition pruning mechanism encountered a multi-range list or inequality using a column from the partitioning key, it continued with the next partitioning column;
• The RPM spec file now also runs the test suite on the new binaries;
• A LIMIT clause has been added to a query containing GROUP BY and ORDER BY could cause the optimizer to choose an incorrect index for processing the query, and return more rows than required.
A complete list of fixed bugs, updates and new features can be found in the comprehensive official announcement.
Download MySQL 5.5.28 right now from Softpedia.