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.
ALTER TABLEForeign KeysMetadata Locks
0 likes · 7 min read