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
((SELECT a, b, c FROM t ORDER BY a LIMIT 3) ORDER BY b LIMIT 2) ORDER BY c …