A Quick Peek at MySQL 8.0.31

Percona Database Performance Blog

Oracle releases updates to MySQL on a quarterly basis and the Release Notes for 8.0.31 arrived just before the software.  This time around there are some very interesting new features that will be handy including SQL standards support, as well as over 130 bug fixes.

The TL;DR:  Some nice new features but nothing spectacular.

• FULL is now a reserved word.
• InnoDB now supports parallel index builds, which improves index build performance. In particular, loading sorted index entries into a B-tree is now multithreaded.
• The OpenSSL library for MySQL Server has been updated to version 1.1.1q.
• The optimizer has been improved so that the old ER_NOT_SUPORTED_YET is not thrown when you try something like this:
  Shell

  ((SELECT a, b, c FROM t ORDER BY a LIMIT 3) ORDER BY b LIMIT 2) ORDER BY c LIMIT 1;

• MySQL now follows the semantics specified in the SQL standard, so that a higher outer limit cannot override an inner lower one. This means that the expression (SELECT … LIMIT 3) LIMIT 5 can return at most three rows.
• UNION DISTINCT and UNION ALL can now be nested in arbitrary combinations.
• The Performance and sys schemas now expose metrics for the global and session memory limits introduced in MySQL 8.0.28.
• The  MySQL Server’s offline mode now requires the CONNECTION_ADMIN privilege in addition to the SYSTEM_VARIABLES_ADMIN privilege. Sessions whose users have the CONNECTION_ADMIN privilege remain connected when offline mode is activated, and users with that privilege can make new connections to an offline server instance. This means that administrators who can activate offline mode cannot inadvertently lock themselves out by doing so.

Summary:  Some minor improvements but nothing earth-shattering.  Testing things like parallel index builds will take some time. But overall it looks like we are getting some solid improvements out of the MySQL Engineers at Oracle.