471,092 Members | 1,498 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

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 1722

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 Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.