Am 17.03.2014 15:37, schrieb Paul J Stevens: > On 17-03-14 15:21, Reindl Harald wrote: >> http://git.dbmail.eu/paul/dbmail/commit/?h=dbmail_3_1&id=81f5abec7052ed1a95c5b87bd1c3bd0fc839de3f >> >>> set header_cache_readonly to 'yes' to prevent new >>> unknown header-names from being cached >> >> great! >> > Sorry, but no! it very much depends on the clients used. Outlook uses > different headers than thunderbird, etc. > > Assuming you don't support hand-crafted search queries (some clients > undoubtedly do allow it): > > Received is not needed for normal usage. > Most headers that start with 'X-' can be deleted, but not all. > > Headers used by Outlook (afaik): > > References X-Ref X-Priority X-MSMail-Priority X-MSOESRec Newsgroups > > Thunderbird: > > From To Cc Subject Date Message-ID Priority X-Priority References > Newsgroups In-Reply-To Content-Type > > So at the very least keep: > Cc > Content-Type > Date > From > In-Reply-To > Message-ID > Newsgroups > Priority > References > Subject > To > X-MSMail-Priority > X-MSOESRec > X-Priority > X-Ref > > This is just headers used in FETCH. But other headers I'm sure will be > used by other clients and/or during SEARCH. > > Point of the patch is that at least no more headernames will be added. > If things works now, they will continue to work. You can start removing > headernames you are confident are never used (such as Received, and most > X- headers not mentioned). Just removing Received will typically remove > a *lot* of headervalue rows. > > But be advised: removing rows from dbmail_headername will cascade to a > lot of rows in dbmail_headervalue. > > So test before running stuff like: > delete from dbmail_headername where headername in ('Received', > 'X-ListName', ...); > > I would delete headernames one by one. Or if this is too slow and you > are certain about the headernames you need: > > 1) truncated dbmail_header, dbmail_headername, dbmail_headervalue > 2) insert headernames you know you need (like the list above) > 3) run dbmail-util -by
thanks for feedback, the query below i assume would be safe but as always a second or third opinion can't be wrong, about delete performance i don't need to care because the machine is fast as hell, some of them are in my mysql-history the first ones are %word% for things i think never be relevant use dbmail; delete from dbmail_headername where headername like 'x_%' or headername like '%abuse%' or headername like '%apparently%' or headername like '%bounce%' or headername like '%campaign%' or headername like '%exchange%' or headername like 'helpdesk%' or headername like '%java%' or headername like '%linkedin%' or headername like '%list-%' or headername like '%newsticker%' or headername like '%original%' or headername like '%pool%' or headername like '%precedence%' or headername like '%presedence%' or headername like '%resent%' or headername like '%return%' or headername like '%scanner%' or headername like '%spam%' or headername like '%univie%' or headername like '%virus%' or headername like 'attn%' or headername like 'bounces%' or headername like 'breadcrumbid%' or headername like 'mailing-%' or headername like 'mail-reply-%' or headername like 'recipient_%' or headername like 'resent-%' or headername like 'x-abuse%' or headername like 'x-account-%' or headername like 'x-amavis-%' or headername like 'x-amazon-%' or headername like 'x-aol%' or headername like 'x-apple-%' or headername like 'x-assp-%' or headername like 'x-authenticated-%' or headername like 'x-av-%' or headername like 'x-banan%' or headername like 'x-bawag%' or headername like 'x-bigfish%' or headername like 'x-bounce%' or headername like 'x-broadcast-%' or headername like 'x-bugzilla-%' or headername like 'x-byjm-data%' or headername like 'x-cam%' or headername like 'x-care2-%' or headername like 'x-cloud%' or headername like 'x-clx%' or headername like 'x-cm-%' or headername like 'x-copfilter%' or headername like 'x-cron-%' or headername like 'x-ctch-%' or headername like 'x-direct%' or headername like 'x-disclaim%' or headername like 'x-dynect%' or headername like 'x-ec-%' or headername like 'x-egroups%' or headername like 'x-email%' or headername like 'x-emv-%' or headername like 'x-enigmail%' or headername like 'x-envelope%' or headername like 'x-envelope-helo%' or headername like 'x-epwebmail%' or headername like 'x-eventbrite%' or headername like 'x-evnnet-%' or headername like 'x-face%' or headername like 'x-fb- %' or headername like 'x-fbridge%' or headername like 'x-feedback-%' or headername like 'x-felis-%' or headername like 'x-forefront%' or headername like 'x-forwarded%' or headername like 'x-gfi-%' or headername like 'x-gmx%' or headername like 'x-grey%' or headername like 'x-http-user-agent%' or headername like 'x-iadb%' or headername like 'x-in-dnswl%' or headername like 'x-inf-%' or headername like 'x-ing-%' or headername like 'x-ironport%' or headername like 'x-klm%' or headername like 'x-kse%' or headername like 'x-linetec%' or headername like 'x-linkedin%' or headername like 'x-m1-%' or headername like 'x-mail2%' or headername like 'x-mailer%' or headername like 'x-mailgun%' or headername like 'x-mailing%' or headername like 'x-mailman%' or headername like 'x-mailru%' or headername like 'x-mdr%' or headername like 'x-mimedefang%' or headername like 'x-ms-exchange%' or headername like 'x-mw-%' or headername like 'x-nai%' or headername like 'x-no-%' or headername like 'x-notification%' or headername like 'x-organization%' or headername like 'x-origin%' or headername like 'x-ovh%' or headername like 'x-perlmx-%' or headername like 'x-php%' or headername like 'x-pmx-%' or headername like 'x-qmail%' or headername like 'x-qq-%' or headername like 'x-redhat%' or headername like 'x-report%' or headername like 'x-rm-%' or headername like 'x-rocket%' or headername like 'x-roving%' or headername like 'x-sa-%' or headername like 'x-sanitize%' or headername like 'x-secure%' or headername like 'x-smtp%' or headername like 'x-smtpcom-%' or headername like 'x-source%' or headername like 'x-spf-%' or headername like 'x-spread%' or headername like 'x-starscan%' or headername like 'x-stayfriends%' or headername like 'x-tbone%' or headername like 'x-tele2-%' or headername like 'x-tm_%' or headername like 'x-tm-%' or headername like 'x-touris%' or headername like 'x-tpg-%' or headername like 'x-tpg%' or headername like 'x-track%' or headername like 'x-tug%' or headername like 'x-tumblr%' or headername like 'x-typo3%' or headername like 'x-ui%' or headername like 'x-universal%' or headername like 'x-unsent%' or headername like 'x-unsubscribe%' or headername like 'x-uri%' or headername like 'x-user%' or headername like 'x-virtual%' or headername like 'x-vr-%' or headername like 'x-webhouse%' or headername like 'x-willhaben%' or headername like 'x-yahoo%' or headername like 'x-ymail%' or headername like 'x-yml%';
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
