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]
