How to fix MySQL TRUNCATE TABLE blocking queries in other databases

This could be caused by the query cache.

To fix this without restarting MySQL disable the query cache by running the following query:
SET GLOBAL query_cache_size = 0;
Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on whatsapp