Hi, I didn't think it was "hot". I have seen this argument a few times before, comparing apples and oranges and suggesting that dbmail does it the wrong way and should change. Yes dbmail has a niche and it excels in situations where filesystem-based mail systems can't cut it, and that's why I'm using it. For those who think filesystem-based mail systems are better for them, I say go for it! Not everyone has the same requirements.
To address your two points though: I have found that since linux kernel 2.6 series, LVM snapshots have caused system lockups. I used it happily in the 2.4 series. Besides that, I did mention *impact-free*. Adding a snapshot and reading from a snapshot severely impacts the speed of the running system. Yes you get a clean backup, but the hard disk is being placed under a huge read strain, not to mention the extra COW load for every write to the filesystem. I believe that dbmail on MySQL requires the use of InnoDB, which I believe (or has this recently changed?) does not support Full Text Index. Maybe using something like Sphinx as a bolt-on would be handy for doing IMAP searches. I generally sync all my emails to my desktop machine and do any searches on the local copies. Then searches don't impact the servers :) On Fri, 2009-12-11 at 01:00 +0100, Daniel Urstöger wrote: > I do not want to add to this quite "hot" situation, but there are two things > worth mentioning: > > > * I'd like to see impact-free daily backups for filesystem-based > > systems. With dbmail, just have a slave replica you can pause > > replication on to get a perfect snapshot, with no impact on the live > > database during the backup duration. > > That is actually possible, not with the same features, but one could use the > snapshot features from LVM to achieve that. > Create and mount that snapshot on your backup box and well, do with it > whatever you like. > > The other thing I think is worth mentioning is especially about MySQL: the > Full Text Index ( FTI ) is quite bad for searches, > if you reach a certain amount of data, also looking through all the records > without any index is quite slow. > I have no comparison of flat file storage compared with database stored > messages, but for MySQL there is soon to be a new search / index technology > available, > which hopefully will also get implemented in dbmail (?), called sphinx > search. > I have used it lately (beta version) in a project and the speed compared to > MySQL with FTI was quite remarkable. _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
