topic Re: query execution speed in Operating System - HP-UX

query execution speed

prem_4 — Mon, 16 Jun 2003 11:12:40 GMT

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.

Re: query execution speed

Tim Sanko — Mon, 16 Jun 2003 19:09:01 GMT

If they are being run from the command line,

try time, or times.

Re: query execution speed

Caesar_3 — Mon, 16 Jun 2003 19:16:48 GMT

Hello!

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

Caesar

Re: query execution speed

twang — Mon, 16 Jun 2003 21:20:40 GMT

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.

Re: query execution speed

Michael Steele_2 — Mon, 16 Jun 2003 21:27:45 GMT

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

Re: query execution speed

Michael Tully — Mon, 16 Jun 2003 21:28:02 GMT

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"

Re: query execution speed

prem_4 — Tue, 17 Jun 2003 08:30:20 GMT

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.