What do you (OP, not Lars) mean by "transaction"?
Cause there's user space transactions that run over long periods that don't necessarily rely on actual transactions in the db sense, then there are real transactions, i.e. atomic transactions, which require something like innodb or PostgreSQL etc... to work.
