Hi Mark,
At 09:15 16-05-2008, Marc Perkel wrote:
OK - I'm trying that. So innodb is better?
InnoDB supports transactions. The entire table is not locked as with
MyISAM when data is inserted, updated or deleted. That's better in
the case of a Bayes database. In general, there is a performance hit
when using InnoDB. You should however see better performance for Bayes.
In your original message, you mentioned that the db was being
corrupted. That shouldn't happen unless there was an incorrect
shutdown of the MySQL server. The hang you mentioned might be a
query waiting on a lock.
Regards,
-sm