What are the Key improvements MySQL 5.7 Release

MySQL 5.7 General Availability (GA) has been released for quite few months Download now and we have not have the chance to take a look over new added features and capabilities. This version looks very exciting and the world’s most popular open source database improved usability, manageability, and security.

 Here are key enhancements included in MySLQ 5.7

Performance & Scalability

Improved InnoDB scalability and performance on temporary tables, faster online and bulk load operations.

JSON Support

   With the newly added JSON support in MySQL, you can now combine the flexibility of NoSQL with the strength of a relational database.

Replication improvements

for increased availability and performance. They include multi-source replication, multi-threaded slave enhancements, online GTIDs, and enhanced semi-sync replication.

Performance Schema

delivering much better insights. We’ve added numerous new monitoring capabilities, reduced the footprint and overhead, and significantly improved ease of use with the new SYS Schema.

Security

We are fulfilling “secure by default” requirements and many new MySQL 5.7 features will help users keep their database secure.

Optimizer

We have rewritten large parts of the parser, optimizer, and cost model. This has improved maintainability, extend-ability, and performance.

GIS

Completely new in MySQL 5.7 and including InnoDB spatial indexes, use of Boost.Geometry, along with increased completeness and standard compliance.

 

   

I hope this was helpful and i appreciate if you would like, subscribe or share our posts. I it is just a click

clickhere

Similar Article  How to avoid using clear text passwords in MySQL
No Comments
Leave a Comment

%d bloggers like this: