I had a table with ~0.5M rows and tried to exec simple query, something like
UPDATE table SET col1=-90 + RAND()*90, col2=-180+RAND()*360 WHERE col1=9999
but result was
ERROR 1297 (HY000): Got temporary error 233 'Out of operation records in transaction coordinator (increase MaxNoOfConcurrentOperations)' from NDBCLUSTER
Ok, I have MaxNoOfConcurrentOperations=100000
and slightly more than 100000 rows which satisfy where condition, so i have changed this query:
UPDATE table SET col1=-90 + RAND()*90, col2=-180+RAND()*360 WHERE col1=9999 ORDER BY ID LIMIT 100000
and got same error. And same error whith LIMIT 1000
.
I have updated rows using query with LIMIT 100
in loop, but I think that it bad solution.
Why MySQL Cluster behave in such way? How can I just update many rows in single table?
Aucun commentaire:
Enregistrer un commentaire