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
signature.asc
Description: OpenPGP digital signature
