Mailing List Archive: DBMail: users

Housekeeping dbmail_headervalue

Index | Next | Previous | View Threaded

leandro at texnet

May 15, 2012, 8:08 AM

Post #1 of 3 (244 views)
Permalink

Housekeeping dbmail_headervalue

Hello,
am I wrong or there is no dbmail-util procedure to delete headervalues
no more connected to messages?

After deleting some users directly from the dbmail_database and running
the dbmail-util -ay housekeeping utility, I noticed the
dbmail_headervalue table size remains pretty the same.

If I run manually the query:

select count(*) from dbmail_headervalue where id not in ( select
headervalue_id from dbmail_header );

I discovered a large number of no more connected header values.

Almost the same if I check the headernames with the query:

select count(*) from dbmail_headername where id not in ( select
headername_id from dbmail_header );

Leandro

_______________________________________________
DBmail mailing list
DBmail [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

h.reindl at thelounge

May 15, 2012, 8:11 AM

Post #2 of 3 (229 views)
Permalink

Re: Housekeeping dbmail_headervalue [In reply to]

yes this is a missing piece in dbmail-util and should be
done manually this time because this table had 80% of all
recods here some weeks ago

Am 15.05.2012 17:08, schrieb leandro:
> Hello,
> am I wrong or there is no dbmail-util procedure to delete headervalues
> no more connected to messages?
>
> After deleting some users directly from the dbmail_database and running
> the dbmail-util -ay housekeeping utility, I noticed the
> dbmail_headervalue table size remains pretty the same.
>
> If I run manually the query:
>
> select count(*) from dbmail_headervalue where id not in ( select
> headervalue_id from dbmail_header );
>
> I discovered a large number of no more connected header values.
>
> Almost the same if I check the headernames with the query:
>
> select count(*) from dbmail_headername where id not in ( select
> headername_id from dbmail_header );
>
> Leandro
>
> _______________________________________________
> DBmail mailing list
> DBmail [at] dbmail
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

--

Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
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

Attachments:

signature.asc (0.26 KB)

harald.leithner at itronic

May 15, 2012, 8:14 AM

Post #3 of 3 (229 views)
Permalink

Re: Housekeeping dbmail_headervalue [In reply to]

Hi Leandro,

there is already a good solution for this:
http://www.gossamer-threads.com/lists/dbmail/users/31530#31530

But I think Paul has other things to develop, may you could write the code
that do this?

bye

HArald

Am 15.05.2012, 17:08 Uhr, schrieb leandro <leandro [at] texnet>:

> Hello,
> am I wrong or there is no dbmail-util procedure to delete headervalues
> no more connected to messages?
>
> After deleting some users directly from the dbmail_database and running
> the dbmail-util -ay housekeeping utility, I noticed the
> dbmail_headervalue table size remains pretty the same.
>
> If I run manually the query:
>
> select count(*) from dbmail_headervalue where id not in ( select
> headervalue_id from dbmail_header );
>
> I discovered a large number of no more connected header values.
>
> Almost the same if I check the headernames with the query:
>
> select count(*) from dbmail_headername where id not in ( select
> headername_id from dbmail_header );
>
> Leandro
>
> _______________________________________________
> DBmail mailing list
> DBmail [at] dbmail
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads