[prev in list] [next in list] [prev in thread] [next in thread] 

List:       nyphp-talk
Subject:    [nyphp-talk] check if table is locked
From:       Nicholas Hart <nhart () partsauthority ! com>
Date:       2011-01-12 14:43:16
Message-ID: AANLkTiksazHNG2H9VKaeP8iEFQRfiTG14mLU1-GPCC7_ () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


I have home-grown replication process (replicates AS400 to mysql) which can
sometimes take a long time to update/insert records in some very large and
busy tables.  If I could create two such tables and then lock one while
running apps against the other one, this would greatly improve performance
at peak times.  Does anyone know of a way in php or python to check if a
table is locked?  I suppose one option would be to update some field upon
locking one table and use this as a test.. this would add some overhead to
every app that uses these tables which I would like to avoid if possible.  I
am looking for the simplest solution/suggestion.  Thanks.

Best,
Nick

[Attachment #5 (text/html)]

I have home-grown replication process (replicates AS400 to mysql) which can=
 sometimes take a long time to update/insert records in some very large and=
 busy tables.=A0 If I could create two such tables and then lock one while =
running apps against the other one, this would greatly improve performance =
at peak times.=A0 Does anyone know of a way in php or python to check if a =
table is locked?=A0 I suppose one option would be to update some field upon=
 locking one table and use this as a test.. this would add some overhead to=
 every app that uses these tables which I would like to avoid if possible.=
=A0 I am looking for the simplest solution/suggestion.=A0 Thanks.=A0 <br>
<br>Best,<br>Nick<br><br><br>


_______________________________________________
New York PHP Users Group Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk

http://www.nyphp.org/Show-Participation

[prev in list] [next in list] [prev in thread] [next in thread]