Greetings!

Just a note on a problem we encountered recently.

New versions of MySQL (the one supplied as default in RH7.3?)
come with the InnoDB transactional database core enabled as
default.

The problem with this is that Midgard doesn't know anything
about transactions. Since Midgard doesn't do SQL commits,
InnoDB's periodic rollback commands cause random stuff to
disappear from the Midgard database.

Easy fix for this is to disable InnoDB from MySQL with the
following instructions:

--------
If you do not want to use transactional InnoDB tables, add 
a line skip-innodb to the [mysqld] section of init parameters 
in your my.cnf or my.ini.
--------

At some point in future it would be nice to make Midgard
transaction-aware, but this is not really an issue at the
moment.

/Bergie

-- 
Henri Bergius                           [EMAIL PROTECTED]
Consultant Partner                      Tel: +358-20-198 6032
Nemein Oy                               http://www.nemein.com


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to