Shulou(Shulou.com)06/01 Report--

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

Take a quick look at the highlights of this version!

1.Hash Join

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

2.EXPLAIN ANALYZE

EXPLAIN ANALYZE will run the query and then generate EXPLAIN output, as well as other information about how the optimizer estimates match the actual execution.

3. You can randomly generate a password when you create a user

Syntax has been added to the CREATE USER, ALTER USER, and SET PASSWORD statements to generate strong random passwords and return them to the client as a result.

The syntax to add 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 mode to specify the behavior of group replication when the server unintentionally leaves the group.

The OFFLINE_MODE behavior closes all connections and forbids users who do not have CONNECTION_ADMIN or SUPER privileges to establish new connections, otherwise it behaves like an existing READ_ONLY mode.

5.innodb adds an option to control writing to IOPs when idle

This option controls writing IOP when InnoDB is idle. The goal is to reduce the number of IO writes to extend the life of flash memory.

In addition, there are many improvements to the internal details. For more information, 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

Related links:

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

MySQL 8.0 for Windows v8.0.18 official Free official Edition 64-bit

Wonderful topic sharing:

Installation tutorials for different versions of mysql

Installation tutorials for each version of mysql5.7

Installation tutorials for each version of mysql5.6

Installation tutorials for each version of mysql8.0

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.