Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
cancel
Showing results for 
Search instead for 
Did you mean: 

query execution speed

prem_4
Occasional Advisor

query execution speed

is there any way to obtain the execution speed of the queries executed in mysql so that i can use it to store i a table and use it measure performance.

6 REPLIES
Tim Sanko
Trusted Contributor

Re: query execution speed

If they are being run from the command line,

try time, or times.
Caesar_3
Esteemed Contributor

Re: query execution speed

Hello!

If you use oracle you have tools for check
performances of the sql and other operation in the DB.

Caesar
twang
Honored Contributor

Re: query execution speed

No yet, I don't see mysql have such management function yet. As tim mentioned you might need to measure it's perf using command line collected statistics.
Michael Steele_2
Honored Contributor

Re: query execution speed

Look into Oracle's

a) 'cost-based optimizer'.
b) sql trace
c) tkprof
d) SQL analyze
e) autotrace
f) explain plan
g) optimizer_mode
h) dbms_stats
Support Fatherhood - Stop Family Law
Michael Tully
Honored Contributor

Re: query execution speed

Use the 'time' or 'timex' command for this type of performance gathering. You could easily wrap it up into a shell script. See the man pages for the details on the commands.


regards
Michael
"When I have trouble spelling, it's called fat finger syndrome"
Anyone for a Mutiny ?
prem_4
Occasional Advisor

Re: query execution speed

hi !
thanx all for replying!
but if i have to use time,times or timex,.. how can i fetch it from a c program.
is there a function in C , perl etc to get the execution time.