do long delete/update and view progress?

[Bennett Haselton]

Is there any way to do a long update/delete on a table such that you can 
view the progress as the command runs, so that long before it's over, you 
have some idea of what the total running time will be?

The way I did it was to write a perl script that takes the total range of 
values for the primary key field in the table, divides that range into 
chunks, and then runs the update/delete command on each chunk at a time, 
printing out when it's done that chunk.  But that's a bit of a kludge.  Is 
there a built-in way?

	-Bennett

[EMAIL PROTECTED]     http://www.peacefire.org
(425) 497 9002
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]