Skip to main content

System lock

Short Description

The thread is going to request or is waiting for an internal or external system lock for the table.

Detailed Description

The thread is going to request or is waiting for an internal or external system lock for the table. If this state is being caused by requests for external locks and you are not using multiple mysqld servers that are accessing the same MyISAM tables, you can disable external system locks with the --skip-external-locking option. However, external locking is disabled by default, so it is likely that this option will have no effect. For SHOW PROFILE, this state means the thread is requesting the lock (not waiting for it).

How to reduce this wait

Not available yet. Contributions welcome.

MySQL Docs - General Thread States

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.