query execution speed

[prem_4]

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.

[Tim Sanko]

If they are being run from the command line,

try time, or times.

[Caesar_3]

Hello!

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

Caesar

[twang]

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]

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

[Michael Tully]

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"

[prem_4]

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.