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
--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
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:
]
--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
i've noticed that, when a thread sending data
an update is first locked then other select is locked
From: xuefer tinys [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
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
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