When was mysql 5.5 released

Tutorial 4. MySQL Programs 5. Security 7. Backup and Recovery 8. Optimization 9. Language Structure Globalization Data Types Functions and Operators SQL Statement Syntax Storage Engines High Availability and Scalability Replication Partitioning Stored Programs and Views Connectors and APIs Extending MySQL MySQL Workbench Licenses for Third-Party Components B.

Restrictions and Limits F. Maksud dan Tujuan. Thus, each company has its own methods for assigning the version name to the software. When the new features in software and programs have introduced, fixes bugs, patched security holes, then version number increased that indicates those improvements. The latest support for working with MySQL is version number v5. 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. It is available from April and ends the support in April When you are going to install MySQL in your system, you must have to choose the version and distribution format to use. 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. Data 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. Atomic 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.

After MySQL 8. 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.

Character Set Support: The default character set now changed from latin1 to utf8mb4. In sorting json values, now each value is represented by variable-length part of sort key instead of a fixed 1K size.

Data Type Support: In data type specifications, it can support the use of expressions as default values. Optimizer Enhancement: This version added optimizer enhancement such as invisible indexes, descending indexes, support the creation of a functional index. It can use constant folding for comparison between a column and a constant value.

The MySQL 8. A relational database management system, MySQL has been an issue in the ongoing dispute between Oracle , which intends to buy Sun, and the European Union, which has expressed antitrust concerns about the deal.

Sun Microsystems maintains a commercial version of MySQL, though the code itself is open source and independent developers contribute to it. Curry did not estimate a time when the software would be production ready, but said the new release system should speed the development process. Here are the latest Insider stories. More Insider Sign Out. Sign In Register. Sign Out Sign In Register.