Does TRANSACTION/COMMIT/ROLLBACK only work on certain MySQL engines such as InnoDB?
The only storage engine ("table type") that supports transactions with the standard MySQL 5.x distributions is InnoDB.  MyISAM and the others do not support transactions.   

http://dev.mysql.com/doc/refman/5.5/en/ansi-diff-transactions.html