MySQL 8.1 new features
Here are the top new features in 8.1.0 release of MySQL database version:
- Logging of the shutdown process has been enhanced, with the addition of startup and shutdown messages for the MySQL server, plugins, and components.
- Release MySQL 8.1 extends EXPLAIN FORMAT=JSON with an INTO a user variable where it can be worked with using MySQL JSON functions.
- Added the SHOW PARSE_TREE statement, which shows the JSON-formatted parse tree for a SELECT statement.
SHOW PARSE_TREE SELECT * FROM t3 WHERE id > 2\G - Stripping of comments from the mysql client was the default behavior; from MySQL 8.1.0 onwards, the default has changed to preserving such comments.
- Default value for the SOURCE_RETRY_COUNT option of the CHANGE REPLICATION SOURCE TO statement has been changed to 10.
- Added the tls-certificates-enforced-validation system variable, which permits a DBA to enforce certificate validation at server startup or when using the ALTER INSTANCE RELOAD TLS statement to reload certificates at runtime.
- group_replication_set_as_primary() function now waits for ongoing DDL statements such as ALTER TABLE when waiting for all transactions to complete, prior to electing a new primary.
- Added server system variables to control the amount of time MySQL accounts that connect to a MySQL server using LDAP pluggable authentication must wait when the LDAP server is down or unresponsive.
- Added status variables specific to Group Replication plugin that improve diagnosis and troubleshooting of network instabilities, providing statistics about network usage, control messages, and data messages for each group member.
