Skip to main content

Table lock

Short Description

Table level lock

Detailed Descriptionโ€‹

MySQL uses table level locking for MyISAM, memory and merge tables. This allows access by only one session, making them more suitable for a read-only or single user application.

For information about table lock indicators, see Section 8.11.1, โ€œInternal Locking Methodsโ€.

How to reduce this waitโ€‹

Not available yet. Contributions welcome.

MySQL Docs - Internal Locking Metods

Search onlineโ€‹

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.