Thursday, November 21, 2002 07:05 AM
To provide the best performance, the default type of MySQL tables does not support transactions. To use transactions, you should work with innoDB type of tables.
CREATE TABLE my_table(
-- columns list
) TYPE = InnoDB;
I also had to modify "my.cnf" file. The steps are very well described in MySQL manual.