Like stopping to ask for directions - There once was a girl named...
The Grrl / In Brief / Her Pictures / Her Roller Derby league September 2010
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
 
 
Thu, Feb. 8th, 2007 02:21 am
Like stopping to ask for directions

I've been brain-deep in work for the past couple of days, but Jeremy Cole made my night by showing me his latest patch for Mysql - a progress indicator!

The Progress_rows number indicates progress within a given step of executing the query. For instance, if you run a SELECT with a GROUP BY that can’t be done using an index, you will see two cycles of Progress_rows: once with a State of “Copying to tmp table” and once with “Sending data”.


Read more about it on Jeremy's blog

4CommentReply

scsi
scsi
Blorp
Thu, Feb. 8th, 2007 04:36 pm (UTC)

Hm, would be cooler if he did it while the mysql client was blocked waiting for the query to finish. Nothing makes me more nervous than seeing:

mysql> Huge scary query;
_ <-- blinking cursor for 5+ min.


ReplyThread
lisa
lisa
Lisa Phillips
Thu, Feb. 8th, 2007 05:47 pm (UTC)

well in this case you'd open up another connection and view the progress there.

but you're right. although maybe a blinking BOMB icon.


ReplyThread Parent
evan
Evan Martin
Thu, Feb. 8th, 2007 04:46 pm (UTC)

I never knew mysql was C++!


ReplyThread
llarian
llarian
The cat that walked by himself
Thu, Feb. 8th, 2007 06:48 pm (UTC)

huh, that's handy. I was thinking the other day while waiting on a huge "sending data" query that it would be nice to know when it was going to be finished.


ReplyThread