Like stopping to ask for directions

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

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.

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.

evan
Evan Martin

	Thu, Feb. 8th, 2007 04:46 pm (UTC)

I never knew mysql was C++!

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.