RE: mySQL: Table locking problems when non-index keys used

2004-04-23 Thread Dathan Vance Pattishall
[EMAIL 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 could

mySQL: Table locking problems when non-index keys used

2004-04-22 Thread ravi.ramachandra
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 colu

mySQL: Table locking problems when non-index keys used

2004-04-21 Thread ravi.ramachandra
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 ?

RE: Mysql Table locking

2003-02-17 Thread Alec . Cawley
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 >

Re: Mysql Table locking

2003-02-17 Thread Zak Greant
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

RE: Mysql Table locking

2003-02-17 Thread Rob
e RSA Smart Business 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,

Re: Mysql Table locking

2003-02-17 Thread Alec . Cawley
> 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 fo

Re: Mysql Table locking

2003-02-17 Thread Zak Greant
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: http://www.mysql.com/search/index.ph

Mysql Table locking

2003-02-17 Thread Rob
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 Inn

Mysql Table locking

2003-02-17 Thread Rob
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 Inn

MySQL table locking?

2003-02-12 Thread H. Scott Brown
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 loc