on 04/27/2005 09:58 AM Oskar said the following:
You see - tables are locked and the only way to fix it is restarting MySQL.

Could you tell me what am I doing wrong, please?

I suspect that your scripts may be exiting once in a while with unfinished transactions due to bugs or errors that make it end prematurely. With persistent connections you need to rollback unfinished transations by the end of the script.

The solution of Metabase (portable database abstraction package) is to implicitly register a shutdown function that clean any pending transactions:



Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP

PHP Reviews - Reviews of PHP books and other products

Metastorage - Data object relational mapping layer generator

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to