[EMAIL PROTECTED]
-->Sent: Thursday, August 07, 2003 10:24 AM
-->To: [EMAIL PROTECTED]
-->Subject: 1 query lock all others query
-->
-->when i show processlist
-->1 of my queries is "sending data" (SELECT ...)
-->while others queries (SE
when i show processlist
1 of my queries is "sending data" (SELECT ...)
while others queries (SELECT/UPDATE) is "locked"
what's up?
_
与联机的朋友进行交流，请使用 MSN Messenger: http://messenger.msn.com/cn
--
MySQL General Mailing List
For list a
07, 2003 11:18 AM
-->To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
-->Subject: RE: 1 query lock all others query
-->
-->but one guy in #mysql said:
-->[quote]
-->with myisam tables if an update is running everything else is
blocked,
-->multiple selects are allowed to run at the same t
i've once noticed it
it has been 8 but i remove it now, problem still exists
From: "Dathan Vance Pattishall" <[EMAIL PROTECTED]>
To: "'xuefer tinys'" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>
Subject: RE: 1 query lock all others query
Date: T
i've noticed that, when a thread "sending data"
an "update" is first "locked" then other "select" is locked
From: "xuefer tinys" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: 1 query lock all others query
lects run at the same time.
From: "Dathan Vance Pattishall" <[EMAIL PROTECTED]>
To: "'xuefer tinys'" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: RE: 1 query lock all others query
Date: Thu, 7 Aug 2003 10:59:46 -0700
For MYISAM tables
