i am aware, thanks for the warning! most important: does anybody see something in that list which may make better to keep
on my testserver i start now playing around with stress-testing http://git.dbmail.eu/paul/dbmail/commit/?h=dbmail_3_1&id=3dc82d0455b6e87f3f6b63ba101a16ca1faddf70 Am 17.03.2014 17:11, schrieb Paul J Stevens: > Like I said, below query is going to take a very, very long time to run. > And while it's running it's keeping a write lock on the > dbmail_headervalue table, essentially blocking all message insertions. > > On 17-03-14 16:54, Reindl Harald wrote: >> >> 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
