MySQL Forums
Forum List  »  Performance

Re: Eliminate filesort in update query
Posted by: Matzz -
Date: September 25, 2014 05:48AM

Bug ID 74049 (I sent it before but my message was somehow blocked by forum).

Subquery with limit in update doesn't work. Mysql doesn't support it.
I tried to join select query with update query but it produce lots of deadlocks. Even though it was faster than update with filesort (135 poll operations per second).
Last but not least, I tried SELECT FOR UPDATE, it was the fastest way (250 poll operations per second).

Thank you

Options: ReplyQuote


Subject
Views
Written By
Posted
2471
September 23, 2014 02:48AM
1002
September 23, 2014 09:59PM
933
September 24, 2014 01:25AM
978
September 24, 2014 08:40PM
Re: Eliminate filesort in update query
975
September 25, 2014 05:48AM
916
September 26, 2014 04:39PM
967
October 01, 2014 06:49AM
982
October 03, 2014 10:09PM
1015
October 04, 2014 03:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.