Re: Locking mysql tables with PHP

Wouter van Vliet wrote:

I may be wrong here, but doesn't PHP let MySQL retain the locks when you've connected with the mysql_pconnect(); function? (persistent connect, I would expect locks to get released on a disconnect, which usually happens on a page refresh (new mysql_connect() call).

That is only a side effect, more a bug than feature as it breaks temporary table functionality. And it cannot be relied upon as the persistent connection can end anytime.