Execution time of mySQL statement

[Anon]

Hello All,

How can I get the execution time of a mySQL statement ?

Thank you for your help.
Best regards
TQLoc

[Anon]

check out BENCHMARK in the mysql manual

[Anon]

I mean, after submit php mysql_db_query, how can I get how many time this query takes ( By calling some php function ? ). ( if I make query by running mysql in telnet session, I always get this time).
Best regards,
TQLoc

[Anon]

I was lookin' for this mail and answers but there isn't any.

I think that best way to get execution time is to use some program execution functions like exec() or system().

Hamster.

[Anon]

I use the microtime() function to get an estimate of how long it takes.

$start_time = microtime();

Do MySQL query

$end_time = microtime();

Then I have a little procedure that prints
the time-difference between $start_time and $end_time.

Ofcourse, this is extra work, so it will take extra CPU time.