For MYISAM tables selects cause table locks while INNODB does row level
locking.
Now if your select is taking a long time you might want to look at your
index schema. If that does not work for you then split up your data.
-->-Original Message-
-->From: xuefer tinys [mailto:[EMAIL PROTECTE
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
