Re: Sort_merge_passes increasing at 38 per minute...
Hi,
I can only guess, but it sounds like two transactions try to update the same row and one of them therefore has to wait for the other. Is this plausible? Does more than one connection update the same row?
Hope this helps,
Jørgen Løland
Software Engineer, MySQL, Oracle
jorgenloland.blogspot.com
Subject
Views
Written By
Posted
2748
December 18, 2011 09:15AM
954
December 19, 2011 06:55AM
1008
December 19, 2011 07:36AM
Re: Sort_merge_passes increasing at 38 per minute...
1145
December 20, 2011 03:10AM
1000
December 20, 2011 04:07PM
1085
December 21, 2011 02:58AM
1264
December 21, 2011 07:25PM
987
December 22, 2011 02:34AM
1414
December 22, 2011 11:53PM
1111
December 23, 2011 07:14AM
1014
December 24, 2011 08:58AM
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.