阅读背景:

MySQL慢查询 - “等待查询缓存锁定”

来源:互联网 

I am running a simple query on a simple table on the same machine as the server running 5.5. It is taking 22sec to return ~7000 rows from a 20 million row table. Upon profiling most of the time is taken up by multiple "Waiting for query cache lock". What is "Waiting for query cache lock" and why is this query taking so long? Is it something with the way I set up the server?I am running a simple query on a simple table o




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: