Bug #510 | UPDATE infinite loop? | ||
---|---|---|---|
Submitted: | 26 May 2003 13:36 | Modified: | 27 May 2003 4:50 |
Reporter: | [ name withheld ] | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: MyISAM storage engine | Severity: | S3 (Non-critical) |
Version: | 4.0.12 | OS: | Windows (MS Windows) |
Assigned to: | CPU Architecture: | Any |
[26 May 2003 13:36]
[ name withheld ]
[27 May 2003 4:50]
Alexander Keremidarski
Sorry, but the bug system is not the appropriate forum for asking support questions. Your problem is not the result of a bug. For a list of more appropriate places to ask for help using MySQL products, please visit http://www.mysql.com/support/ Thank you for your interest in MySQL. It is rather expected behaviour as this query must first order your whole table BY RAND() then pick up 10000 and just then perform UPDATE on them. > I let it run for 20 minutes, stopped it and... With large table it can take hours and even days. To estimate how long it will take simply run SELECT with same WHERE, ORDER BY and LIMIT clauses. SELECT COUNT(*) WHERE criteria1 > 19 AND criteria2 != "zzz" order by rand() limit 10000; This type of questions belongs to general list at mysql@lists.mysql.com not to Bugs Database. Please post here only if you have fully repeatable test case.