25Feb/083
Mysql SQL_NO_CACHE Benchmark Problem
I have been trying to benchmark the sql calls to mysql from an application without success. Even when I set the SELECT statement to SQL_NO_CACHE, the results seemed to be still cached. Apparently, Linux does its own caching of disk reads also. That was giving me incorrect benchmark results if I hit the same data twice.
For those using Linux kernel 2.6.16 or higher, you can clear Linux cache with the following command.
echo 3 > /proc/sys/vm/drop_caches
Unfortunately for me, I am stuck on 2.5.xx and will have to figure out another method.
April 28th, 2012 - 05:29
loool… that is an awesome idea!
March 19th, 2012 - 20:46
Nice post. I learn one thing tougher on completely different blogs everyday. It’ll always be stimulating to read content material from different writers and apply a bit of one thing from their store. I’d favor to make use of some with the content on my weblog whether you don’t mind. Natually I’ll provide you with a link in your net blog. Thanks for sharing.
November 15th, 2011 - 21:03
Just desire to say your article is as surprising. The clarity in your post is just nice and i can assume you are an expert on this subject. Well with your permission let me to grab your RSS feed to keep up to date with forthcoming post. Thanks a million and please carry on the gratifying work. Thanks friend!