On Tue, 13 May 2008, Michael Mayer wrote:
[EMAIL PROTECTED] wrote:
My question is: does the schema that comes with DBMail already have
indexing defined in it or do I have to do my own indexing and optimization?
Yes, there are indexes - I just checked it with my db (the structure works,
so it should not be too outdated). But especially the messages table seems to
be over-indexed. That costs storage as well as insert/update performance. No
problem with my little mail server, but at a larger scale it might cause
trouble.
Unlikely, unless you have more writes than reads, which would be rather
unusual for most applications. :)
You should also think about installing a MySQL cluster and/or use MySQL
Proxy. Caching will help a lot with read performance.
I'd avoid MySQL cluster - last time I checked it it was slow to the pain,
not to mention the distinctly dodgy recovery modes when a node goes down.
Round-robin replication is probably a better solution if you need to scale
to multiple servers. Or you could just go PostgreSQL and do proper star
topology replication with a bit of pl/perl and trigger magic.
Anyway, the original poster said there is only one server being used, so
all this replication/clustering is irrelevant in this particular case.
Gordan
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
