mysql - transaction processing question

2004-07-06 Thread bruce
hi... if i process multiple subsequent sql where the later statements might be dependent on the completion of the former/earlier sql statement, will this cause a problem... ie: $dbh-do(SET AUTOCOMMIT=0); eval { $dbh-do(insert into foo(Name,Vorname,Konto) values ('Ehmann','Andres',710235434));

Transaction processing

2002-10-08 Thread Simon Windsor
Hi I've been using mysql for a couple of years now, and until now had no real need of transactions. The could list recommend BDB or InnoDB to implement transatcions. On a small system, which one is faster, and handles load better ? Do they both offer foreign key constraints ? Do they fix

Distributed Transaction Processing

2001-03-12 Thread Martin Cameron
Has anyone contemplated using MySQL for DTP through a cluster of machines where the transactions are related to critical financial transactions. For example, in a commerce situation where a customer withdraws from one account and deposits into another, DTP ensures that all computers commit