0 and
hide = 0
ORDER BY rd.created_at ASC limit 350, 25
Notice the only one that actually executing is the first select. all
others including the insert are locked. Why would the 3rd query a
select be locked by the first query another select.
On Aug 28, 2008, at 10:07
; wrote:
On Wed, Aug 27, 2008 at 8:21 PM, Jose Estuardo Avila
<[EMAIL PROTECTED]> wrote:
Hi, I've been trying to find information on how myisam handles
locks. I
though myisam had locking only on writes and not on reads.
No, readers block writers. This true of any system that only
Hi, I've been trying to find information on how myisam handles locks.
I though myisam had locking only on writes and not on reads. For some
reason and after a lot of digging i've been seeing that some
queries(albeit bad queries) cause other queries to hang even though
they are selects is th