mysql

Projected Spatial Reference Systems in MySQL 8.0

2018-05-28 KENNETH 0

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.… Source: Projected Spatial Reference Systems in MySQL 8.0

Geographic Spatial Reference Systems in MySQL 8.0

2018-05-25 KENNETH 0

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.… Source: Geographic Spatial Reference Systems in MySQL 8.0

No Image

MySQL 8.0: MVCC of Large Objects in InnoDB

2018-05-22 KENNETH 0

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.  … Source: MySQL 8.0: MVCC of Large Objects in InnoDB

No Image

Changes in MySQL 8.0.11 (General Availability)

2018-05-18 KENNETH 0

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.… Source: Changes in MySQL 8.0.11 (General Availability)

No Image

MySQL 8.0: InnoDB Introduces LOB Index For Faster Updates

2018-05-15 KENNETH 0

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.… Source: MySQL 8.0: InnoDB Introduces LOB Index For Faster Updates