MySQL MyISAM table locking
Asked Answered
C

1

11

Does a MySQL MyISAM table gets locked when records are deleted from it?

Charge answered 23/12, 2009 at 7:13 Comment(0)
B
17

MyISAM tables supports table level locking, and yes, a write lock is employed when deleting (or insert & updating) records.

For more info, see Internal Locking Methods

Borsch answered 23/12, 2009 at 7:24 Comment(0)

© 2022 - 2024 — McMap. All rights reserved.