Top New Features in MySQL 8.1 database

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.

Related MySQL Articles:  MySQL DBA top basic/advanced interview questions - Part 1