Date: Sun, 23 Mar 2008 19:17:27 -0400 From: Bill Moran <wmoran@potentialtech.com> To: Da Rock <rock_on_the_web@comcen.com.au> Cc: freebsd-questions@freebsd.org Subject: Re: OT: (Way OT) PHP and MySQL concurrency control using MyISAM tables Message-ID: <20080323191727.bd9c5237.wmoran@potentialtech.com> In-Reply-To: <1206313415.6973.78.camel@laptop2.herveybayaustralia.com.au> References: <1206313415.6973.78.camel@laptop2.herveybayaustralia.com.au>
next in thread | previous in thread | raw e-mail | index | archive | help
Da Rock <rock_on_the_web@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. -- Bill Moran http://www.potentialtech.com
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20080323191727.bd9c5237.wmoran>