QPS doubled at a time

After upgrading MySQL from 5.0.49 to 5.1.68, the QPS doubled;

650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131229/2111425108-0.png "title =" 1.png" alt = "155624252.png"/>

After review the applications of all domains, the conclusion is that the QPS of the application is basically not changed. Where does this strange QPS come from? Later, it was found that querycache was enabled when it was 5.0. After the upgrade, since the read/write ratio of this database is basically not much different and the original QC hit rate is lower than 20%, QC was disabled, the querycache hit is not included in com_select, so it makes a problem :)

QC hit:

650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131229/2111422F8-1.png "title =" 2.png" alt = "155641939.png"/>

This article is from "MIKE's old blog" blog, please be sure to keep this source http://boylook.blog.51cto.com/7934327/1298758