In this article I will explain the partial update optimizations for smaller (LOBs) in InnoDB. Small here qualifies the size of the modification and not the size of the LOB. For some background information about the partial update feature, kindly go through our previous posts on this (here, here and here).…
INPLACE upgrade from MySQL 5.7 to MySQL 8.0
MySQL 8.0 General Availability was announced in April and it comes with a host of new features. The overview about the new features and improvements made in MySQL 8.0 can be found in the following blog.
The server can be upgraded by performing either an INPLACE upgrade or LOGICAL upgrade. …
Creating Your Own Spatial Reference Systems in MySQL 8.0
MySQL 8.0.11 comes with a catalog of 5108 spatial reference systems (SRSs). 4628 projections (flat maps), 479 geographic (ellipsoidal) representations of Earth, and one Cartesian all-purpose abstract plane (SRID 0). And if for some reason that isn’t enough, we can create our own.…
Upgrading Spatial Indexes to MySQL 8.0
MySQL has had spatial indexes for many years, but they have all been Cartesian (X and Y coordinates) indexes. MySQL 8.0 adds support for geographic (latitude-longitude) indexes. In an earlier blog post, I described how the feature works. In this post, we’ll go into the details of how to upgrade from 5.7 to 8.0 if you have spatial indexes.…
Projected Spatial Reference Systems in MySQL 8.0
MySQL 8.0.11 comes with a catalog of 5108 spatial reference system (SRS) definitions. In a previous post, we covered the definitions of geographic SRSs. In this post we’ll go into the details of projected SRSs. (If you haven’t done so already, I suggest you read the previous post first.)
Projected SRSs are flat, Cartesian coordinate systems created by projecting points on (an oblate spheroidal model of) Earth onto a flat surface.…
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. …
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.…
Making MySQL Easier to Use – Our New Server Usability Guidelines
As well adding new features, our goal in the server team is to make MySQL easier to use. We try to design features with the goal of making a net improvement on usability. However, the actual definition of usable server software is not so straight-forward.…
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.…