470,604 Members | 2,024 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,604 developers. It's quick & easy.

do long delete/update and view progress?

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
(425) 497 9002
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 1710

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Brian Roberts | last post: by
1 post views Thread by Lisa Tang | last post: by
reply views Thread by Michael Widenius | last post: by
14 posts views Thread by php newbie | last post: by
16 posts views Thread by Philip Boonzaaier | last post: by
16 posts views Thread by robert | last post: by
10 posts views Thread by nano2k | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.