Hi! >>>>> "Bennett" == Bennett Haselton <[EMAIL PROTECTED]> writes:
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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]
