View Single Post

   
  #1 (permalink)  
Old 06-13-2008, 02:59 PM
John Nagle
 
Posts: n/a
Default Meaning of MySQL query browser time values

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
Reply With Quote