What do the time values in the MySQL query browser mean? I'm
getting

0 rows fetched in 0.0007s (4.3616s)

on a query that's taking too long. What do the two time values
mean?

(This is on an otherwise-idle machine, and the MySQL server really
is going compute-bound for several seconds. I have an inefficient
nested query, and I'm working on speeding it up. When I can
get a SHOW PROCESSLIST in from another query browser, I usually
see a status of "Freeing items".)

John Nagle

On Tue, 10 Jun 2008 11:38:16 -0700, John Nagle wrote:
> What do the time values in the MySQL query browser mean? I'm
> getting
>
> 0 rows fetched in 0.0007s (4.3616s)
>
> on a query that's taking too long. What do the two time values
> mean?

The first is the amount of time it took mysql to send however many rows
it is, the second however many seconds it took to run the query.

--
186,000 Miles per Second. It's not just a good idea. IT'S THE LAW.

Peter H. Coffin wrote:
> On Tue, 10 Jun 2008 11:38:16 -0700, John Nagle wrote:
>> What do the time values in the MySQL query browser mean? I'm
>> getting
>>
>> 0 rows fetched in 0.0007s (4.3616s)
>>
>> on a query that's taking too long. What do the two time values
>> mean?
>
> The first is the amount of time it took mysql to send however many rows
> it is, the second however many seconds it took to run the query.

OK, that makes sense.

John Nagle

On 11 Jun, 03:01, "Peter H. Coffin" <hell...@ninehells.com> wrote:
> On Tue, 10 Jun 2008 11:38:16 -0700, John Nagle wrote:
> > What do the time values in the MySQL query browser mean? *I'm
> > getting
>
> > * *0 rows fetched in 0.0007s (4.3616s)
>
> > on a query that's taking too long. *What do the two time values
> > mean?
>
> The first is the amount of time it took mysql to send however many rows
> it is, the second however many seconds it took to run the query.
I've often wondered that. Where did you find that documented Peter?

On Wed, 11 Jun 2008 05:05:34 -0700 (PDT), Captain Paralytic wrote:
> On 11 Jun, 03:01, "Peter H. Coffin" <hell...@ninehells.com> wrote:
>> On Tue, 10 Jun 2008 11:38:16 -0700, John Nagle wrote:
>> > What do the time values in the MySQL query browser mean? *I'm
>> > getting
>>
>> > * *0 rows fetched in 0.0007s (4.3616s)
>>
>> > on a query that's taking too long. *What do the two time values
>> > mean?
>>
>> The first is the amount of time it took mysql to send however many rows
>> it is, the second however many seconds it took to run the query.
> I've often wondered that. Where did you find that documented Peter?

It was one of several answers that are scattered through the mysql.com
forums, most of which don't seem to be correct. This interpretation at
least matches sensible guesses. The first number goes up when the number
of rows increases, by experiment.

--
64. I will see a competent psychiatrist and get cured of all extremely
unusual phobias and bizarre compulsive habits which could prove to
be a disadvantage.
--Peter Anspach's list of things to do as an Evil Overlord