From owner-freebsd-questions@FreeBSD.ORG Mon Mar 24 00:09:12 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 99841106566C for ; Mon, 24 Mar 2008 00:09:12 +0000 (UTC) (envelope-from pauls@utdallas.edu) Received: from smtp3.utdallas.edu (smtp3.utdallas.edu [129.110.10.49]) by mx1.freebsd.org (Postfix) with ESMTP id 7704E8FC24 for ; Mon, 24 Mar 2008 00:09:12 +0000 (UTC) (envelope-from pauls@utdallas.edu) Received: from [192.168.2.102] (cpe-24-175-90-48.tx.res.rr.com [24.175.90.48]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by smtp3.utdallas.edu (Postfix) with ESMTP id 6EE2D65527; Sun, 23 Mar 2008 19:09:11 -0500 (CDT) Date: Sun, 23 Mar 2008 19:09:15 -0500 From: Paul Schmehl To: Da Rock , freebsd-questions@freebsd.org Message-ID: In-Reply-To: <1206313415.6973.78.camel@laptop2.herveybayaustralia.com.au> References: <1206313415.6973.78.camel@laptop2.herveybayaustralia.com.au> X-Mailer: Mulberry/4.0.8 (Mac OS X) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Cc: 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: Mon, 24 Mar 2008 00:09:12 -0000 --On March 24, 2008 9:03:35 AM +1000 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. > > Any ideas would be very welcome. > Following list etiquette, I'm replying to you and the list. I believe that postgresql has transaction locking. You might consider using it instead. Mysql is supposed to have transaction locking in version 5.1, but I haven't tested it and don't know how robust it is. Paul Schmehl (pauls@utdallas.edu) Senior Information Security Analyst The University of Texas at Dallas http://www.utdallas.edu/ir/security/