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

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

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

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 ?

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

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

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:

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 for

RE: Mysql Table locking

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

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 and

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

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