Why one reading query lock another one?
Posted by:
Yan Yan
Date: August 15, 2010 11:21PM
Hi all,
When I do some query join the tables with MyISAM engine. The select query entered into the "copying to tmp table" status, MySQL will use the filesort. Then other queries(they are all the reading query) will be locked by this one.
Of course, we should do some optimizationes to avoid this case.
But I just want to know why one select query locked another select query.( As I know, the lock for reading should not affect the ohter reading)
thanks for your help!
Subject
Views
Written By
Posted
Why one reading query lock another one?
4530
August 15, 2010 11:21PM
1692
August 17, 2010 08:23AM
1965
August 18, 2010 12:00AM
1735
September 06, 2010 03:21PM
1662
September 06, 2010 08:26PM
1517
September 06, 2010 09:18PM
1591
September 07, 2010 02:17AM
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.