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: Thu, 7 Aug 2003 11:39:34 -0700
Check you mysqld server veriable thread_concurrency. I'm not sure that this will solve your problem since your problem has changed from a select locking to concurrent selects.
-->-----Original Message----- -->From: xuefer tinys [mailto:[EMAIL PROTECTED] -->Sent: Thursday, August 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 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
_________________________________________________________________
免费下载 MSN Explorer: http://explorer.msn.com/lccn/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]