Aug 28, 2024 · Databases

Understanding Implicit Locks in MySQL InnoDB

This article explains what implicit locks are in MySQL InnoDB, how to identify their presence on primary and secondary index records, the conditions under which they appear, and the process by which they are converted into explicit locks that can be inspected via performance_schema.

DatabaseLocksImplicitLockInnoDB

0 likes · 9 min read

Understanding Implicit Locks in MySQL InnoDB

dbaplus Community

Jul 2, 2024 · Databases

What’s New in MySQL 9.0 Innovation Edition? Key Features and Improvements

MySQL 9.0 Innovation Edition, released on July 1, 2024, introduces major changes such as the removal of the mysql_native_password plugin, new PREPARE support for event statements, expanded Performance Schema tables, JSON‑formatted EXPLAIN ANALYZE output, Windows installer fixes, and several MySQL Shell enhancements.

InnovationEditionMySQLShellPerformanceSchema

0 likes · 4 min read

What’s New in MySQL 9.0 Innovation Edition? Key Features and Improvements