I’m seeing a lot of “Waiting on query cache mutex” threads when I’m running a lot of small updates on a particular table (InnoDB).
When this happens all the DBs on the server basically grind to a halt. I’ve disabled the query cache on the server entirely for the time being and this prevents them from completely grinding to a halt when the update is running, but has had a significant impact on query response times the rest of the time.
Is it feasible to disable the query cache whilst running the updates and re-enable as soon a it’s completed or is there some alternate solution?
Thanks a lot