NYCPHP Meetup

[Nicholas Hart]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20110112/63b45e89/attachment.html>