MySQL Single Query Benchmarking Strategies
Posted
by Pepper
on Stack Overflow
See other posts from Stack Overflow
or by Pepper
Published on 2010-05-21T16:15:37Z
Indexed on
2010/05/21
16:20 UTC
Read the original article
Hit count: 232
mysql
|Performance
Hello,
I have a slow mySQL query in my application that I need to re-write. The problem is, it's only slow on my production server and only when it's not cached. The first time I run it, it will take 12 seconds, then anytime after that it'll be 500 milliseconds.
Is there an easy way to test this query without it hitting the query cache so I can see the results of my refactoring?
Thanks!
© Stack Overflow or respective owner