MySQL 8.0.18 stable version released! Hash Join is here as expected

MySQL 8.0.18 stable version (GA) was officially released yesterday, and Hash Join also arrived as expected.

Here’s a quick look at the highlights of this release!

1. Hash Join

Hash Join does not require any indexes to execute and is more efficient than the current block nested loop algorithm in most cases.

2. EXPLAIN ANALYZE

EXPLAIN ANALYZE runs the query and then produces EXPLAIN output, along with other information about how the optimizer's estimates matched the actual execution.

3. Randomly generate passwords when creating users

Added syntax to CREATE USER, ALTER USER , and SET PASSWORD statements to generate a strong random password and return it as a result to the client.

The syntax for adding is:

CREATE USER user IDENTIFIED BY RANDOM PASSWORD,
ALTER USER user IDENTIFIED BY RANDOM PASSWORD,
SET PASSWORD [FOR user] TO RANDOM

4. Group replication

group_replication_exit_state_action Added OFFLINE_MODE mode to specify the behavior of Group Replication when a server leaves the group unintentionally.

The OFFLINE_MODE behavior closes all connections and prohibits new connections for users who do not have CONNECTION_ADMIN or SUPER privileges, but otherwise behaves similarly to the existing READ_ONLY mode.

5. Innodb adds an option to control write IOPs in idle state

This option controls the write IOPs when InnoDB is idle. The purpose is to reduce write IO to extend the life of the flash memory.

In addition, there are many improvements to the internal details. For details, please visit: news-8-0-18.html

Download

Windows (x86, 32-bit), MSI Installer 8.0.18 (mysql-installer-web-community-8.0.18.0.msi) 18.6M

Windows (x86, 32-bit), MSI Installer 8.0.18 (mysql-installer-community-8.0.18.0.msi) 415.1M

Windows (x86, 64-bit), ZIP Archive (mysql-8.0.18-winx64.zip) 272.3M

Related Links:

MySQL 8 for Windows 32-bit v8.0.18 official free version

MySQL 8.0 for Windows v8.0.18 official free version 64-bit

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.7 installation tutorials for various versions

MySQL 5.6 installation tutorials for various versions

mysql8.0 installation tutorials for various versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.