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

be*****@peacefire.org http://www.peacefire.org
[phone]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw