Re: query lock

Hi Ila,

See

   http://dev.mysql.com/doc/refman/4.1/en/ansi-diff-transactions.html

We really need more information (like version of MySQL and specific
tables and query would help), but a step in the right direction is to
make the table InnoDB storage type rather than MyISAM.  That may not
suffice depending upon what's going on.  Is the table properly
normalized?

 - Jan


On Fri, 12 May 2006 17:56:54 -0700, "Ilavajuthy Palanisamy"
<[email protected]> said:
> 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.
>
>
>
>
>
-- 
Jan Theodore Galkowski   (o°)                    
 [email protected]
 http://tinyurl.com/qty7d



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