It has been awhile since I last checked-in on new features in MySQL.
I last installed MySQL 5.5 - since then there has been a 5.6 and 5.7 release.
Here are a few selected notes out of the many changes that I found of interest...
5.6 MySQL Release
- MySQL now supports stronger encryption for user account
passwords, available through an authentication plugin
sha256_passwordthat implements SHA-256 password hashing
EXPLAINstatement now provides execution plan information for
EXPLAINprovided information only for
SELECTstatements. In addition, the
EXPLAINstatement now can produce output in JSON format.
- Many interesting enhancements to the optimizer...
- Condition handling. MySQL now supports the
5.7 MySQL Release
- DDL performance for
InnoDBtemporary tables is improved through optimization of
TRUNCATE TABLE, and
InnoDBnow supports MySQL supported spatial data types. Prior to this release, InnoDB would store spatial data as binary
BLOBremains the underlying data type but spatial data types are now mapped to a new InnoDB internal data type,
- Condition handling. MySQL now supports stacked diagnostics areas.
EXPLAINcan now be used to obtain the execution plan for an explainable statement executing in a named connection