My message was not quite finished, sadly there isnt an App for that ;) > 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.
Which distro are you using? I havent had any snapshot related problems yet, but maybe that is related to how much data you have? The snapshots I create rately have more then 20GB of data. And I don't want to point out a better distro for you but I see this mailing list as quite a nice source of knowledge and of exchange ... So I just want to know to learn from :) > 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 :) It does require transactions, so for MySQL you are quite tied to innodb, unless you want to try something more experimental. It would be nice of customers to act like you, but usually they don't. Though I really liked that Thunderbird 3 now even heavily suggest syncing to local disk. Sphinx for searches would be awesome! The new release is even compatible to the MySQL client / libraries. So no API to fiddle with, but still needs quite some work, I guess ... > >> >> _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
