Like stopping to ask for directions

[lisa]

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

Comments

[scsi]

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.

[lisa]

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.

[evan]

I never knew mysql was C++!

[llarian]

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.