MySQL Engineering Blogs
Geographic Spatial Reference Systems in MySQL 8.0
MySQL 8.0.11 comes with a catalog of 5108 spatial reference system (SRS) definitions, and 479 of these are geographic. We usually just refer to them by SRID, but in this blog post we’ll dive into the details and try to understand the definition itself.…
MySQL 8.0: MVCC of Large Objects in InnoDB
In this article, I’ll explain about the multi version concurrency control (MVCC) of large objects (LOBs) design in the MySQL InnoDB storage engine. MySQL 8.0 has a new feature that allows users to partially update large objects, including the JSON documents. …
Replication Test Coverage in MySQL 8.0
In the Replication QA team, we have been continuing to improve test coverage for Replication and Group Replication primarily to ensure that we support the newest and latest offerings of MySQL Server 8.0 such as Generated Columns, Set Persist, User Roles, and User Management DDLs that are now...
Changes in MySQL 8.0.11 (General Availability)
The MySQL Development team announced the General Availability of MySQL 8.0 on April 19th, 2018. Here we follow up with references to worklogs that were added in 8.0.11. Note the jump in version number from 8.0.4 (RC2) to 8.0.11 (GA) explained here.…
MySQL User Camp, Bangalore – 27th April, 2018
MySQL User Camp is a forum where MySQL Engineers and community users come together to connect, collaborate, and share knowledge. This year’s first MySQL User Camp was held on 27th April 2018, at Oracle India Pvt Ltd, Kalyani Magnum Infotech Park, Bangalore with an excellent turnout of 60...
MySQL 8.0: InnoDB Introduces LOB Index For Faster Updates
To support the new feature Partial Update of JSON documents, InnoDB changed the way it stored the large objects (LOBs) in MySQL 8.0. This is because InnoDB does not have a separate JSON data type and stores JSON documents as large objects.…
MySQL Cluster Manager 1.4.6 released!
MySQL Cluster Manager 1.4.6 is now available for download from My Oracle Support. Overview In MCM 1.4.6, the list backups command has been extended with a new –agent option for listing agent backups created with the backup agents command. mcm> list backups...
MySQL 8.0: InnoDB now supports Instant ADD COLUMN
Instant DDL has been one of the most requested InnoDB features for a very long time. With ever larger and rapidly growing datasets the ability to do DDL instantly is a must have feature in any web scale database. Developers constantly need to add new columns to meet the constantly changing...
MySQL Community Server
- Connector/Net 6.9
- Connector/Net 6.10
- MySQL for Visual Studio 1.2
- Connector/C++ 1.1
- MySQL Cluster 7.5
Which backup features do you require for your MySQL database backups?
"The Documents contained within this site may include statements about Oracle's product development plans. Many factors can materially affect Oracle's product development plans and the nature and timing of future product releases. Accordingly, this Information is provided to you solely for information only, is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle.