Re: OT: (Way OT) PHP and MySQL concurrency control using MyISAM tables

2008-03-26 Thread Bill Moran
In response to Da Rock [EMAIL PROTECTED]: [massive snip] I remember now exactly why I wanted MyISAM- you see the table locking is exactly what I need for the task. I just need to come up with a method to ensure what I send to the server does actually get written- or am I just being

Re: OT: (Way OT) PHP and MySQL concurrency control using MyISAM tables

2008-03-25 Thread Da Rock
On Sun, 2008-03-23 at 17:01 -0700, Patrick C wrote: MyISAM supports locking (like all engines) but not transactions. Without transactions, you can do a lock lock a table or tables, and unlock them, however you cannot roll back statements -- so if a statement down the line fails for some

OT: (Way OT) PHP and MySQL concurrency control using MyISAM tables

2008-03-23 Thread Da Rock
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

Re: OT: (Way OT) PHP and MySQL concurrency control using MyISAM tables

2008-03-23 Thread Bill Moran
Da Rock [EMAIL PROTECTED] 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

Re: OT: (Way OT) PHP and MySQL concurrency control using MyISAM tables

2008-03-23 Thread Da Rock
On Sun, 2008-03-23 at 19:17 -0400, Bill Moran wrote: Da Rock [EMAIL PROTECTED] 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

Re: OT: (Way OT) PHP and MySQL concurrency control using MyISAM tables

2008-03-23 Thread Patrick C
MyISAM supports locking (like all engines) but not transactions. Without transactions, you can do a lock lock a table or tables, and unlock them, however you cannot roll back statements -- so if a statement down the line fails for some reason there is no way to rollback and undo past statements

Re: OT: (Way OT) PHP and MySQL concurrency control using MyISAM tables

2008-03-23 Thread Paul Schmehl
--On March 24, 2008 9:03:35 AM +1000 Da Rock [EMAIL PROTECTED] 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