[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]