I'm using Mysql Server 5.6.15 and i have a huge database with many complex queries.
it seems that when I run the query the first time it takes X amount of time.
when I execute it again it takes less then X time. which means that something was cached.
I want to be able to performance test my queries in order to improve them regardles of caching.
is there a way to disable all caching types in mysql in order for me to properly test the execution time of my queries?
any information regarding the issue would be greatly appreciated.