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

This article mainly explains "what are the new features of MySQL 8.0". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn what are the new features of MySQL 8.0.

First, more friendly support for mobile applications

Enhanced support for GIS (Spatial graphic Information)

The default character is utf8mb4.

Second, developers are preferred.

JSON data type-optimized for update performanc

JSON function-added a conversion function that can analyze JSON data using SQL

CRUD mixed API of MySQL X API-SQL and NoSQL

Third, data-driven-improve the efficiency of processing data analysis

General table expressions (CTE) replace the exported tables and with statements of subqueries to improve SQL readability and processing performance

The Windows function is used for analysis processing such as ranking, object records and surrounding data for management and statistical analysis.

Fourth, improve the performance and scalability of applications

Improve centralized access through parameters to reduce unlocking wait

The invisible index hides the index from the optimizer to delete the index on the premise of retaining the index and append it in segments (when the data is updated, the hidden index will also be updated)

Performance Schema extends the default access to information to improve query performance

Use the Hint statement to change the session variable (temporarily change the session variable in a SQL)

Descending index to improve scanning speed

Extended hint statements perform table join and index merge in the order specified by SQL

Fifth, improve the performance and scalability of the MySQL server

Innodb dedicated servers, virtual machines and cloud environments automatically set variables suitable for InnoDB

Cloud-friendly settings use SET PERSIST to persist changes made to the SQL interface. Appended a table that confirms where the set value has been changed

Resource groups improve processing efficiency and performance by mapping threads to CPU

The rectangle of the column provides the optimizer with unindexed statistics to improve the execution plan

The optimization cost estimation optimizer supports the latest storage technology and makes an execution plan according to the state of the data cache.

Transaction scheduling "Contention-Aware Transaction Scheduling", as the default scheduling algorithm for InnoDB, significantly improves its performance.

Sixth, strengthen the security and availability of applications.

MySQL InnoDB Cluster MySQL standard high availability suite. Automatic failover and recovery, collision detection

The data dictionary uses InnoDB to manage metadata. Improve the consistency and reliability of metadata

Enhanced security adds a role & Dynamic Privileges. Extends transparent data encryption

Thank you for your reading, the above is the content of "what are the new features of MySQL 8.00.After the study of this article, I believe you have a deeper understanding of the new features of MySQL 8.0. the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.