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%'; > > > > _______________________________________________ > DBmail mailing list > [email protected] > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > -- ________________________________________________________________ Paul J Stevens pjstevns @ gmail, twitter, github, linkedin www.nfg.nl/[email protected]/+31.85.877.99.97 _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
