query lock

------_=_NextPart_001_01C67628.2B596A8C
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

=20

I have a performance issue; I need help in fixing it.

=20

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?

=20

But two updates should follow synchronization.

=20

Also when the query decides to make temporary copy inorder to do
filesort, will it lock the tables for update?

=20

All your help is greatly appreciated.

=20

Thanks,

Ila.

=20

=20


------_=_NextPart_001_01C67628.2B596A8C--

Re: query lock

Hi Ila,

See

http://dev.mysql.com/doc/refman/4.1/en/ansi-diff-transaction s.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"
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.
>
>
>
>
>
--=20
Jan Theodore Galkowski (o°) =

jtgalkowski@alum.mit.edu
http://tinyurl.com/qty7d



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

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:ipalanisamy@consentry.com]
> Sent: Friday, May 12, 2006 6:57 PM
> To: win32@lists.mysql.com
> 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/win32?unsub=gcdmw-win32@m.gmane.org