Aikesheng Open Source Community

Jul 18, 2019 · Databases

Understanding MySQL Metadata Locks and ALTER Table Delays with Foreign Keys

The article explains how MySQL metadata locks, especially SHARED_UPGRADABLE and SHARED_READ_ONLY locks acquired during ALTER TABLE on tables with foreign keys, can cause long wait times under concurrent write transactions, and shows how adjusting the max_write_lock_count variable resolves the issue.