Skip navigation links

MySQL Forums :: MySQL Query Browser :: Query execution time message


Advanced Search

Re: Query execution time message
Posted by: Brian Papantonio ()
Date: March 02, 2007 01:14PM

I'm using MySQL QB over a remote connection to my home box (slow).

SELECT * FROM user_log;
15113 rows fetched in 5.3274s (0.1498s)

SELECT BENCHMARK(100000000, RAND());
1 row fetched in 0.0505s (13.2676s)


I believe the results are the following:
The first number is the time it took MySQL server to send the result set to the client.
The second number (in parens) is the time it took MySQL server to execute the query itself.

Options: ReplyQuote


Subject Written By Posted
Query execution time message Serhiy Gorpinich 10/31/2005 03:35AM
Re: Query execution time message James DAVIS 11/12/2005 08:37AM
Re: Query execution time message Al McNicoll 02/24/2006 06:51AM
Re: Query execution time message Ronald Bradford 02/08/2007 08:54PM
Re: Query execution time message Pankaj Yadav 02/26/2007 11:34PM
Re: Query execution time message Brian Papantonio 03/02/2007 01:14PM
Re: Query execution time message Robert Freeland 11/08/2007 01:09AM
Re: Query execution time message Marcelle Paisley 08/06/2008 04:53PM
Re: The Answer Chris Casto 05/21/2008 01:19PM
Re: The Answer Bill Lumberg 10/10/2008 09:42AM
Re: The Answer Mike Lischke 10/13/2008 01:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.