In article <[EMAIL PROTECTED]>,
Miles Thompson <[EMAIL PROTECTED]> wrote:
> I've not worked with InnoDb, but given that the web is a stateless space
> and all kinds of things can happen, I'd be very reluctant to lock a record
> until the very moment I'm updating it. In other words, when I have
I've not worked with InnoDb, but given that the web is a stateless space
and all kinds of things can happen, I'd be very reluctant to lock a record
until the very moment I'm updating it. In other words, when I have my batch
of updates and inserts ready to go, then I'd begin by transaction, exec
I could use some practical tips on doing transactions with InnoDB
tables in MySQL.
I want to grab and lock a record and do a whole load of related stuff,
then make sure everything is updated in a consistent way, something
like this skeleton:
BEGIN
SELECT * from blah WHERE something=n FOR UPDATE
3 matches
Mail list logo
