Skip to main content

Waiting for query cache lock

Short Description

This state occurs while a session is waiting to take the query cache lock.

Detailed Description

This state occurs while a session is waiting to take the query cache lock. This can happen for any statement that needs to perform some query cache operation, such as an INSERT or DELETE that invalidates the query cache, a SELECT that looks for a cached entry, RESET QUERY CACHE, and so forth.

The Query Cache is deprecated at MySQL 5.7.20 and removed in MySQL 8.0

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.