a curated list of database news from authoritative sources

July 30, 2021

July 29, 2021

Supabase Reports and Metrics

We're exposing a full set of metrics in your projects, so that you can build better (and faster) products for your users.

July 28, 2021

July 27, 2021

Announcing Vitess 11

On behalf of the Vitess maintainers, I am pleased to announce the general availability of Vitess 11. Major Themes # In this release, Vitess Maintainers have made significant progress in several areas, including Benchmarking, VTAdmin, Schema Tracking, Online DDL, and Performance improvements. While Schema Tracking is experimental, we’re very excited to have Gen4 planner evolving as well. Please take a moment to review the Release Notes. Please read them carefully and report any issues via GitHub.

July 26, 2021

MySQL Data Locks: Mapping 8.0 to 5.7

As of MySQL 8.0, performance_schema.data_locks shows InnoDB data locks. Before MySQL 8.0, you must SET GLOBAL innodb_status_output_locks=ON and ruminate on the output of SHOW ENGINE INNODB STATUS. The image below (click to see full size) shows how the former maps to the latter for three record locks and one table lock on table t.

Information Schema tables INNODB_LOCKS and INNODB_LOCK_WAITS are deprecated as of MySQL 5.7 and removed as of MySQL 8.0. They are better than nothing, but “Persistence and Consistency of InnoDB Transaction and Locking Information” cautions their usage. Moreover, INNODB_LOCKS only shows locks blocking other transactions, which makes it unsuitable to examine InnoDB row locking without a blocking transaction.

July 22, 2021

July 21, 2021