|
|
Posted by Ahmed Saad on 07/12/05 18:43
On 7/11/05, x <shamubro@gmail.com> wrote:
> Since we can see the time cost each time we query MySQL through MySQL
> console (such as 75 rows in set (0.01 sec)), so I am wondering there is
> already an existing function which will return the value...
I think you are confusing two things: mysql server and mysql
command-line client.
The time cost is calculated at the client side in mysql command-line
client. It's not retrieved from the server but rather calculated with
the help of three functions defined in mysql.cc: start_timer,
end_timer, mysql_end_time (all are internal functions that don't have
anything to do with the server). It's done more or less the way you
would normally do it in php: (1) take down current time (2) do the
query (3) take down time again and calculate the difference.
-ahmed
Navigation:
[Reply to this message]
|