MySQL 8.0: New Lock free, scalable WAL design The Write Ahead Log (WAL) is one of the most important components of a database. All the changes to data files are logged in the WAL (called the redo log in InnoDB). This allows to postpone the moment when the modified pages are flushed to disk, still protecting from data losses.… Source: MySQL 8.0: New Lock free, scalable WAL design
MySQL 8.0: Optimizing Small Partial Update of LOB in InnoDB 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).… Source: MySQL 8.0: Optimizing Small Partial Update of LOB in InnoDB
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. … Source: INPLACE upgrade from MySQL 5.7 to MySQL 8.0
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.… Source: Creating Your Own Spatial Reference Systems in MySQL 8.0
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.… Source: Upgrading Spatial Indexes to MySQL 8.0
Copyright © 2024 | WordPress Theme by MH Themes
