[UPHPU] Sessions - Revisit to MySQL Locking

Ken Snyder ksnyder at coremr.com
Wed Aug 15 16:23:53 MDT 2007


Chad Sollis wrote:
> Thank you gentlemen,
>
> The locks are occurring naturally by mysql, as you noted, I'm not 
> calling any of the lock functions, but rather the table type is MyISAM 
> which locks on write/delete.
Yes.  The article I mentioned talks about row "locking" in the sense of 
using a transaction between the read and the write so that no other 
writes can happen between the initial read and write.  And it points out 
that php locks the session file for each request.  Locking only when 
needed can speed up applications, especially if they are AJAX heavy.

Have fun.

- Ken


More information about the UPHPU mailing list