List:General Discussion« Previous MessageNext Message »
From:xuefer tinys Date:August 8 2003 2:42am
Subject:RE: 1 query lock all others query
View as plain text  
i've noticed that, when a thread "sending data"
an "update" is first "locked" then other "select" is locked


>From: "xuefer tinys" <xuefer@stripped>
>To: dathan@stripped, mysql@stripped
>Subject: RE: 1 query lock all others query
>Date: Fri, 08 Aug 2003 02:31:14 +0800
>
>i've once noticed it
>it has been 8 but i remove it now, problem still exists
>
>
>>From: "Dathan Vance Pattishall" <dathan@stripped>
>>To: "'xuefer tinys'" <xuefer@stripped>,<mysql@stripped>
>>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:xuefer@stripped]
>>-->Sent: Thursday, August 07, 2003 11:18 AM
>>-->To: dathan@stripped; mysql@stripped
>>-->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" <dathan@stripped>
>>-->>To: "'xuefer tinys'" 
>><xuefer@stripped>,	<mysql@stripped>
>>-->>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:xuefer@stripped]
>>-->>-->Sent: Thursday, August 07, 2003 10:24 AM
>>-->>-->To: mysql@stripped
>>-->>-->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/mysql?unsub=1
>>-->>
>>-->>
>>-->>
>>-->>
>>-->>--
>>-->>MySQL General Mailing List
>>-->>For list archives: http://lists.mysql.com/mysql
>>-->>To unsubscribe:
>>http://lists.mysql.com/mysql?unsub=1
>>-->>
>>-->
>>-->_________________________________________________________________
>>-->享用世界上最大的电子邮件系统― 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/mysql?unsub=1
>

_________________________________________________________________
免费下载 MSN Explorer:   http://explorer.msn.com/lccn/  

Thread
1 query lock all others queryxuefer tinys7 Aug
  • RE: 1 query lock all others queryDathan Vance Pattishall7 Aug
RE: 1 query lock all others queryxuefer tinys7 Aug
  • RE: 1 query lock all others queryDathan Vance Pattishall7 Aug
RE: 1 query lock all others queryxuefer tinys7 Aug
RE: 1 query lock all others queryxuefer tinys8 Aug