[horde] mysql as a db backend and table types

[Andrew Morgan]

On Tue, 5 Jul 2005 liamr at umich.edu wrote:

> Just a quick survey of the table type used by the other people using MySQL as a
> prefs / session store.  MyISAM?  InnoDB?
>
> We're using InnoDB because we believe we were getting table corruption due to
> the table level locking used by MyISAM (instead of the row level locking that
> is offered by InnoDB), but we're also wondering if InnoDB is contributing to
> the 2gb memory limit errors we're seeing with our sessions table.
>
> So... what do other large installations use as their DB backend for prefs and
> sessions?  If not some form of MySQL table (ie another rdbms), why?

We use MyISAM, but it wasn't a conscious decision to do so.  I just used 
the default database type when setting up our Horde stuff so long ago.  We 
haven't had any problems, but we are still running Horde2/IMP3, not the 
latest stuff.

 	Andy