sys.schema_table_lock_waits

Aikesheng Open Source Community

May 17, 2023 · Databases

Diagnosing and Resolving DDL Blocking in MySQL Using sys.schema_table_lock_waits

This article explains how to identify when a MySQL DDL operation is blocked, locate the blocking session using the sys.schema_table_lock_waits view, and resolve the issue by enabling necessary instruments and killing the appropriate connection, with examples for MySQL 5.7 and 8.0.