MySQL 8.0. 18 Stable release! Hash Join arrived as scheduled

2021-12-12 10:08:46
OfStack

MySQL 8.0. 18 Stable Edition (GA) was officially released yesterday, and Hash Join arrived as scheduled.

Browse the highlights of this version quickly!

1.Hash Join

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

2.EXPLAIN ANALYZE

EXPLAIN ANALYZE runs the query and generates EXPLAIN output, along with additional information about how the optimizer estimates match the actual execution.

3. You can randomly generate passwords when creating users

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

The syntax added 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 adds the OFFLINE_MODE pattern to specify the behavior of group replication when the server unintentionally leaves the group.

The OFFLINE_MODE behavior closes all connections and prohibits users with non-CONNECTION_ADMIN or SUPER privileges from establishing new connections, otherwise it behaves like the existing READ_ONLY mode.

5. innodb adds an option to control writing to IOPs in idle state

This option controls writing IOP when InnoDB is idle. The purpose is to reduce the write IO to prolong the life of flash memory.

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

Download address

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