I would not recommend going to MyISAM tables. We have used them here
ourselves and they pose no real problem. The only thing is that they do
not support some database specific features. These features (foreign
keys etc) will be probably be needed in future releases of DBMail.
Currently DBMail runs on MyISAM-tables without any problem, but in the
future this might not be the case.
Ilja
Chris Nolan wrote:
Hi all,
I've been using DBMail since version 1.0 with great success in an
environment with about 10 users and about 20 GB of mail (stored
permanently and pulled down via IMAP) all up.
I'm looking to deploy DBMail for a much larger installation (about 200
users) with a minimum of mail each (retreived via POP3). Previously,
I've used MySQL with InnoDB tables and have noticed that the setup blurb
recommends InnoDB tables due to the amount of data to be stored. My
experience with MyISAM indicates that it has no problems with large
amounts of data as long as there aren't problems with OS-imposed size
limitations, so I'm ignoring that part of the setup doc.
My question is whether any of the gentle readers of the list have
deployed DBMail on MySQL using MyISAM tables. Given that MyISAM is
extremely quick with INSERTs that occur at the end of the table and
allows readers to continue while this is happening (and the maintanence
run would happen when no one was using the thing), I'd be interested to
see if it's worth using MyISAM, even if it is just for the space saving
qualites.
Regards,
Chris
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
IC&S
Stadhouderslaan 57
3583 JD Utrecht
PGP-key:
http://www.ic-s.nl/keys/ilja.txt
