back on my workstation.... why in the world do you think that this is a matter of hope? dbmail will NEVER remove all records even if you remove a message via POP3/IMAP - it will always only delete references and the rest is the job of dbmail-util
* delete 20000 messages * you will not notice load * call "dbmail-util -c -t -u -b -p -d -y" * call it 3 times * on the last 2 times you will note HEAVY IO-LOad and that is why dbmail-util is called via crond on each proper setup in the night to not raise up system-load at business time for remove unused data Am 23.06.2012 15:37, schrieb cl445: > > Hmm... this solution isn't really statisfing. Making a dirty delete and hope > that the command-line tool will clean it up... > > > Reindl Harald-2 wrote: >> >> >> >> Am 23.06.2012 12:29, schrieb cl445: >>> >>> What is the best way to delete an user from dbmail in SQL? Is there a >>> cascading delete for dbmail_users? >> >> after remove it from "dbmail_users" all messages are orhpaned >> and cleaned by dbmail-util - i am not sure if you have to >> remove the records from "dbmail_aliases" manually, my backend does >> >> >> >> _______________________________________________ >> DBmail mailing list >> DBmail@dbmail.org >> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail >> >> > -- Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / CISO / Software-Development p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
