[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
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
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 ?