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;
How to fix MySQL TRUNCATE TABLE blocking queries in other databases
- April 14, 2019
- 3:27 pm