Can MySQL 5.1 perform ACID transactions?
Yes. All current MySQL versions support transactions. The InnoDB storage engine offers full ACID transactions with row-level locking, multi-versioning, non-locking repeatable reads, and all four SQL standard isolation levels. The NDB storage engine supports the READ COMMITTED transaction isolation level only.