On Mar 2, 2012, at 11:52 AM, Reindl Harald wrote:
Am 02.03.2012 17:29, schrieb Mailinglist:
I won't be storing for long term and won't require backing up either.
It's more for custom php to query the emails that I receive.
The influx of email will only grow over time. Writing perl scripts to
look at flat txt files I feel will be too much over head on the
server.
Where in a db it will be organized and easy to query for information.
In my perspective any ways. Unless I'm convinced otherwise
you are wrong if you think you can grab in the dbmail-database
like in any normal db - there is no record containing the whole
message, they are splitted in messageblocks
starting with dbmail3 they are splittet in mimeparts so that
every single attachment/mime-part is only stored once in the
whole databae independent how many messages are linked with it
this makes it even much harder to grab directly in the database
but it is a hughe improvement since on our server the whole
mailstorage after the uügrade was 20% smaller as before
imagine you are sending a mail with a 5 MB attachment
to 5 users on your server - in conventional mailsystems
you need 30 MB + overhead on disk (1 copy for the sent
message in your imap account), in dbmail you have
5 MB + some reference-records and even that can be combined
with innodb-compression in recent mysql-versions
in numbers this means on our server currently:
total mailsize: 9 GB
dbmail-database: 5 GB
Well, nevermind, I assumed it would be something that could be viewed
easily. Any one have any other suggestions?
