September 2024 Summaries

This article discusses B-trees and their use in database management systems (DBMSs). It explains how B-trees work, why databases use them for indexes, and the impact of primary key choice on index performance. The article also introduces a variant of B-trees called B+trees, which are commonly used in MySQL indexes. It highlights the benefits of using sequential keys as opposed to random or UUID keys for better query performance. Additionally, it touches upon the buffer pool feature in InnoDB that helps improve query performance by caching frequently accessed pages in memory.

PlanetScale now supports instant deployment requests for eligible schema changes, reducing runtime to near-instantaneous completion. This feature is optional per request and still offers Online DDL as the default and safest strategy. Instant deployments are available for certain MySQL ALTER TABLE statements and table or view modifications. However, they are not revertible and may cause a multi-second lock on migrated tables under specific workloads.