![]() The latest support for working with MySQL is version number v5.8. It contains many essential changes, including new features added and removed, fixed bugs and security issues, etc. This version contains the release history from MySQL 8.0 to MySQL 8.0.21. It is available from April 2018 and ends the support in April 2026. When you are going to install MySQL in your system, you must have to choose the version and distribution format to use. You can install MySQL in two ways, where first is a development release, and the second is General Availability (GA) release. The development release provides the newest feature and is not recommended to use in production. The General Availability (GA) release, also known as production or stable release, is mainly used for production. Therefore, you must have to decide the most recent General Availability release. Let us see what is new in MySQL 8.0 version. The following features are added in MySQL 8.0 version:ĭata Dictionary: It incorporates the transactional data dictionary to stores information about the database objects. Previous versions stored data in metadata files and non-transactional tables.Ītomic DDL Statement: It is an Atomic Data Definition Language statement that combines storage engine operations, data dictionary updates, and binary log associated with a DDL operation into a single atomic transaction. Upgrade Procedures: Previously, the installation of the new MySQL version automatically upgrade the data dictionary table at the next startup, and then DBA is expected to invoke mysql_upgrade command manually for completing the upgrading process. ![]() ![]() After MySQL 8.0.16, it is not dependent on the DBA to invoke mysql_upgrade command for completing the up-gradation process. Security and account management: There is some enhancement added to improve the security and provide it to enable greater DBA flexibility in account management. Resource Management: Now, MySQL allows you to create and support resource groups, assign threads to a particular group so that it can execute according to the resource available for the group. Group attributes can control its resource consumption by threads in the group. Table Encryption Management: Now, table encryption is managed globally by defining and enforcing encryption defaults. The default_table_encryption variable or DEFAULT ENCRYPTION clause defines encryption default when creating a schema and general tablespace. InnoDB enhancements: The InnoDB enhancement were added in auto-increment counter, index tree corruption, memcached plugin, InnoDB_deadlock_detect, tablespace encryption feature, storage engine, InnoDB_dedicated_server, zlib library, and many more.Ĭharacter Set Support: The default character set now changed from latin1 to utf8mb4. The new character set has many new collations, including utf8mb_ja_0900_as_cs. JSON Enhancements: The following enhancements or additions are introduced in the MySQL’s json functionality: Inline path (->) operator, json aggregate functions JSON_ARRAYAGG() and JSON_OBJECTAGG(), utility function JSON_PRETTY(), JSON_STORAGE_SIZE()(, JSON_STORAGE_FREE(). In sorting json values, now each value is represented by variable-length part of sort key instead of a fixed 1K size.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |