RE: query lock

I may not have the best answer for this question, but I would recommend
using InnoDB instead of MyISAM.

Cheers.

LucEnt

> -----Original Message-----
> From: Ilavajuthy Palanisamy [mailto:[email protected]]
> Sent: Friday, May 12, 2006 6:57 PM
> To: [email protected]
> Subject: query lock
>
> Hi,
>
>
>
> I have a performance issue; I need help in fixing it.
>
>
>
> I have a query which takes considerable amount of time,
> during this time any update on the table involved in the
> query gets locked.
>
> Similarly the queries are waiting till the update is over.
>
> Is there a way to make both (queries and updates) to go in
> parallel in case of MYISAM tables?
>
>
>
> But two updates should follow synchronization.
>
>
>
> Also when the query decides to make temporary copy inorder to
> do filesort, will it lock the tables for update?
>
>
>
> All your help is greatly appreciated.
>
>
>
> Thanks,
>
> Ila.
>
>
>
>
>
>



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]