[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