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 time, selects and non interfering inserts can run at the same time
[/quote]


so i ask in mailinglist
because i can't get my multiple selects 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 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 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 (SELECT/UPDATE) is "locked"
-->what's up?
-->
-->_________________________________________________________________
-->与联机的朋友进行交流,请使用 MSN Messenger:
http://messenger.msn.com/cn
-->
-->
-->--
-->MySQL General Mailing List
-->For list archives: http://lists.mysql.com/mysql
-->To unsubscribe:
-->http://lists.mysql.com/[EMAIL PROTECTED]




-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]


_________________________________________________________________
享用世界上最大的电子邮件系统― MSN Hotmail。 http://www.hotmail.com



-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to