as title states, in my database various queries appear in the slow
queries log, but when I run them manually they run 10x faster.
for example a relatively simple select query with several order
by params takes often up to 100 seconds in log(yes table is very
big)... but when I run it myself on the same DB it takes 2 seconds or
I've examined the server's performance and there
doesn't seem to be a particular slowdown or bottleneck at the time,
nor are many queries taking long time at that period but just the one.
how can I begin to analyze such a problem?
thanks for the help