OT: (Way OT) PHP and MySQL concurrency control using MyISAM
wmoran at potentialtech.com
Sun Mar 23 16:17:29 PDT 2008
Da Rock <rock_on_the_web at comcen.com.au> wrote:
> I know this is not quite the list for these things, but I tried the PHP
> list and got no reply whatsoever. In fact, I don't think anyone's home
> cause the entire list is silent...
> I'm trying to setup a system using web apps in PHP using MySQL as the
> backend database, only this time I need transaction services. According
> to the PHP manual if a transaction is served for MySQL it can come back
> as committed even though it may not. So what I'm trying to accomplish is
> develop some row level locking with the PHP script.
> I enquired about setting up a servlet (for want of a better term) with
> PHP, something that will serve the requests of the rest of the app. To
> be honest though, I'm not entirely sure how to approach this.
Wow. That's one crazy attempt at a workaround.
The correct solution is to use the correct tool for the job. Either
install PostgreSQL and use it instead, or use InnoDB tables.
More information about the freebsd-questions