PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 8:09 PM
To: [EMAIL PROTECTED]
Subject: mySQL: Table locking problems when non-index keys used
Friends,
Sorry to post this question again. I got a message saying that the
server couldn't transfer this message to some groups
Friends,
Sorry to post this question again. I got a message saying that the server couldn't
transfer this message to some groups. Also I didn't get any response to this
question.
We are using mysql 4.0.17 with innodb option. In a query, when a WHERE clause
contains a non-indexed
Hi Friends,
We are using mysql 4.0.17 with innodb option. In a query, when a WHERE clause
contains a non-indexed columns, it locks the entire table instead of row lock. Is
there any solution apart from building index on each query key ? Is there a solution
in any of the later versions ?
Hi all,
Can I just check, does MySql v.3.23.52 do table locking or row locking? If
it only does table locking, are there any versions of mysql that do row
locking?
Thanks
---
Rob
**
Rob Cherry
mailto:[EMAIL PROTECTED]
+27 21 447 7440
Jam Warehouse RSA
Smart Business
Hi all,
Can I just check, does MySql v.3.23.52 do table locking or row locking? If
it only does table locking, are there any versions of mysql that do row
locking?
Thanks
---
Rob
**
Rob Cherry
mailto:[EMAIL PROTECTED]
+27 21 447 7440
Jam Warehouse RSA
Smart Business
On Mon, Feb 17, 2003 at 11:00:37AM +0200, Rob wrote:
Hi all,
Can I just check, does MySql v.3.23.52 do table locking or row locking? If
it only does table locking, are there any versions of mysql that do row
locking?
Detailed in the fine manual:
Can I just check, does MySql v.3.23.52 do table locking or row locking?
If
it only does table locking, are there any versions of mysql that do row
locking?
Always Read The Fine Manual:
From http://www.mysql.com/doc/en/Locking_methods.html:
Currently MySQL only supports table locking for
Innovation
http://www.jamwarehouse.com
**
-Original Message-
From: Zak Greant [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 11:10 AM
To: Rob
Cc: [EMAIL PROTECTED]
Subject: Re: Mysql Table locking
On Mon, Feb 17, 2003 at 11:00:37AM +0200, Rob wrote:
Hi all
On Mon, Feb 17, 2003 at 11:22:27AM +0200, Rob wrote:
Thanks
It would appear that MySql does table locking. Then I would like to
ask the following:
Hi Rob,
I think that you missed some important details.
Taken from the manual:
MySQL only supports table locking for ISAM/MyISAM and
It would appear that MySql does table locking. Then I would like to ask
the
following:
From what I've read,
it would seem that SELECTS get a lower priority than INSERTS and UPDATES,
meaning that if all 30 users
insert into that table at the same time (given the way the stress test is
Hello, list,
I'm having a weird issue with table locking. I'm running MySQL 3.23 on a
Win2k server, used for eCommerce applications.
All settings appear to be in order, that is, KeepAlive is 30, connection
pooling is on, with a timeout of 30.
The tables in any given database seem to remain
11 matches
Mail list logo