> From: Duane Hill [mailto:du...@duanemail.org] > > Hello Giampaolo, > > Wednesday, August 3, 2011, 4:09:57 PM, you wrote: > > > > Did you create the bayes tables via the mysql script shipped with SA? > It > > creates tables with TYPE=MyISAM, so I guess this may be why you > didn't see > > any transaction associated to queries. > > > This is from the sql/README.bayes file: > > > ... > > There is also a MySQL specific storage driver available to provides a > > small boost in performance. It requires version 4.1 or above of the > > MySQL database software to work properly. In addition, it provides > > rollback on error functionality if you create your bayes database > > table using the InnoDB storage engine (ie s/MyISAM/InnoDB/ on the > > bayes_mysql.sql file). WARNING: Using this module with a version of > > MySQL < 4.1 could have unexpected results. To use the MySQL 4.1+ > > specific module set your bayes_store_module directive accordingly: > > I used the supplied MySQL tables. However, I changed the DB type from > MyISAM to InnoDB.
Mmm. This may is weird because AutoCommit is explicitly turned off at connect time. See Mail::SpamAssassin::BayerStore::MySQL:_connect_db . > Not only that, the default database and table types are set to utf-8. > > -- > Best regards, > Duane mailto:du...@duanemail.org
