From owner-freebsd-questions@FreeBSD.ORG Sun Mar 23 23:17:29 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id C4E35106564A for ; Sun, 23 Mar 2008 23:17:29 +0000 (UTC) (envelope-from wmoran@potentialtech.com) Received: from mail.potentialtech.com (internet.potentialtech.com [66.167.251.6]) by mx1.freebsd.org (Postfix) with ESMTP id 932628FC1B for ; Sun, 23 Mar 2008 23:17:29 +0000 (UTC) (envelope-from wmoran@potentialtech.com) Received: from working (c-71-60-127-199.hsd1.pa.comcast.net [71.60.127.199]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.potentialtech.com (Postfix) with ESMTPSA id 6B622EBC3B; Sun, 23 Mar 2008 19:17:28 -0400 (EDT) Date: Sun, 23 Mar 2008 19:17:27 -0400 From: Bill Moran To: Da Rock 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> X-Mailer: Sylpheed 2.4.7 (GTK+ 2.12.1; i386-portbld-freebsd6.2) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Cc: freebsd-questions@freebsd.org Subject: Re: OT: (Way OT) PHP and MySQL concurrency control using MyISAM tables X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 23 Mar 2008 23:17:29 -0000 Da Rock 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