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
_______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
