On 26-02-14 17:23, Gray, Patrick wrote:
> Just counted how many headervalues are in my dbmail_headervalue table.
>
>
>
> It looks to be somewhere arund 32 million.
>
>
>
> Could the sheer amount of the headervalues be causing dbmail-util to sit
> there and not appear to be doing anything?
I might trigger a very long running query.
Consider doing something like:
get all headernames starting with 'x-':
select id from dbmail_headername where headername like 'x-%';
for each of those ids:
begin;
delete from dbmail_headername where id=<id>;
commit;
but do not do:
select from dbmail_headername where headername like 'x-%';
because that will run a very long time, and will trigger a write-lock on
both the dbmail_headername and dbmail_headervalue tables, blocking
insertion of new messages.
--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, github, linkedin
www.nfg.nl/i...@nfg.nl/+31.85.877.99.97
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
