Shulou(Shulou.com)05/31 Report--

MySQL 8.0 what are the key points, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

On the improvement of MySQL Server

1.1 redo log refactoring

Redo log is redesigned in MySQL8.0, mainly improving fsync to make it more efficient, reduce locks, optimize flush mechanism, and don't flush frequently. At the same time, concurrent requests from higher users are supported.

Http://dimitrik.free.fr/blog/archives/2017/10/mysql-performance-80-redesigned-redo-log-readwrite-workloads-scalability.html

1.2 MySQL DDL

The atomicity of DDL is realized in MySQL8.0.

Https://mysqlserverteam.com/atomic-ddl-in-mysql-8-0/

1.3 histogram

The concept of histogram is added to MySQL8.0 for index statistics and analysis.

Https://mysqlserverteam.com/histogram-statistics-in-mysql/

1.4 descending index

MySQL 8.0 is available in descending order.

Https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html

1.5 Hidden Index

MySQL8.0 supports hidden indexes. Adding and modifying indexes can be realized by hiding indexes, which facilitates the management of indexes.

Https://dev.mysql.com/doc/refman/8.0/en/invisible-indexes.html

1.6 improvement of temporary table

Since 5. 7, all internal temporary tables have become shared tablespaces for "ibtmp1". In addition, the metadata of the temporary table is also stored in memory.

In MySQL8.0, the MEMORY storage engine will also be replaced by the TempTable storage engine with the default storage engine for internal temporary tables. This new engine provides more efficient storage space for VARCHAR and VARBINARY columns.

Https://dev.mysql.com/doc/refman/8.0/en/internal-temporary-tables.html

1.7 persistent global variables

MySQL8.0 uses the new syntax restart to make the next restart still effective.

Http://lefred.be/content/mysql-8-0-changing-configuration-easily-and-cloud-friendly/

1.8 encryption of redo and undo

In MysQL 5. 7, the tablespaces of each table can be encrypted. In MySQL8.0, UNDO and REDO LOG can also be encrypted, thus improving the security of MySQL.

Https://dev.mysql.com/doc/refman/8.0/en/innodb-tablespace-encryption.html#innodb-tablespace-encryption-redo-log

1.9 modification of Innodb lock

By adding the parameters FOR UPDATE NOWAIT and FOR UPDATE SKIP LOCKED to SQL, you can set the wait to skip the lock or skip the lock.

Https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html#innodb-locking-reads-nowait-skip-locked

1.10 window function

In MySQL8.0, a window function has been added, which can be used to implement several new query methods for better data statistics and analysis.

Http://elephantdolphin.blogspot.com/2017/09/mysql-8s-windowing-function-part-1.html

1.11 New optimizer

In MySQL 8.0.3, a new optimizer, SET_VAR, was introduced to specify the parameter configuration in SQL.

Https://mysqlserverteam.com/new-optimizer-hint-for-changing-the-session-system-variable/

1.12 role

In MySQL8.0, the functionality of roles has been added. It is more convenient for users to manage.

Http://datacharmer.blogspot.com/2017/09/revisiting-roles-in-mysql-80.html

1.13 modification of the character set

In MySQL8.0.1, MySQL supports Unicode 9.0 and modifies the default character set to utf8mb4

Http://lefred.be/content/mysql-clients-and-emojis/

II. Improvement on MySQL replication

2.1 replication aspect modification

New changes in binlog and replication in MySQL8.0.3.

Http://datacharmer.blogspot.com/2017/09/revisiting-roles-in-mysql-80.html

2.2 more efficient Json replication

In MySQL8.0.3, JSON replication is more efficient and provides new json functionality. Only the update changes are recorded in binlog, not all of them.

Https://mysqlhighavailability.com/efficient-json-replication-in-mysql-8-0/

2.3 replication Enhancement

In MySQL8.0.3, more performance monitoring tools such as "dynamic trace, debug log" have been added to modify the default parameters of replication and replicate groups.

Https://mysqlhighavailability.com/replication-features-in-mysql-8-0-3/

2.4 New features for MySQL replication

In MySQL8.0, improvements to replication increase observability and provide replication efficiency (parallel replication based on WRITESET).

Https://mysqlhighavailability.com/mysql-8-0-new-features-in-replication/

III. Improvement of MySQL MGR

3.1 support for copying whitelist

In MySQL8.0.4, the support of whitelist for group replication effectively improves the security of group replication.

Https://mysqlhighavailability.com/hostname-support-in-group-replication-whitelist/

3.2 what's new in MySQL INNODB Cluster

New features added in MySQL INNODB Cluster:

Https://mysqlserverteam.com/mysql-innodb-cluster-whats-new-in-the-8-0-ga-release/

3.3Monitoring of MySQL MGR

Improved observability and manageability of MySQL group replication, and enhanced related tools in MySQL8.0.4.

Https://mysqlhighavailability.com/more-p_s-instrumentation-for-group-replication/

IV. About MySQL bug repair

4.1self-adding bug fixes

Fix the bug on the self-increment column in MySQL8.0. The max (self-increment id) + 1 method is no longer used to determine the next self-increment id.

Http://lefred.be/content/bye-bye-bug-199/

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

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.