Skip to main content

Opening tables

Short Description

The thread is trying to open a table.

Detailed Description

The thread is trying to open a table. This should be a very fast procedure, unless something prevents opening. For example, an ALTER TABLE or a LOCK TABLE statement can prevent opening a table until the statement is finished. It is also worth checking that your table_open_cache value is large enough.

This is a regular table open call. System tables will have a wait state of Opening system tables.

How to reduce this wait

Not available yet. Contributions welcome.

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.