Hi!
[color=blue][color=green][color=darkred]
>>>>> "Bennett" == Bennett Haselton <bennett@peacef ire.org> writes:[/color][/color][/color]
Bennett> Is there any way to do a long update/delete on a table such that you can
Bennett> view the progress as the command runs, so that long before it's over, you
Bennett> have some idea of what the total running time will be?
Bennett> The way I did it was to write a perl script that takes the total range of
Bennett> values for the primary key field in the table, divides that range into
Bennett> chunks, and then runs the update/delete command on each chunk at a time,
Bennett> printing out when it's done that chunk. But that's a bit of a kludge. Is
Bennett> there a built-in way?
For the moment this is not possible.
We do have plans to add in MySQL 5.x a way for the server to give the
client progress notifications for slow commands which could be used
for progess bars etc, but this is still at least 3-5 months in the
future.
--
Michael Widenius <monty@mysql.co m>
MySQL AB, CTO
Helsinki, Finland
Are you MySQL certified? www.mysql.com/certification
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw