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 6 (307 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 6 (285 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 6 (286 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

harald.leithner at itronic

Jul 31, 2013, 2:27 AM

Post #4 of 6 (47 views)
Permalink

Re: Housekeeping dbmail_headervalue [In reply to]

Hi Paul,

if you have time, it would be great if you can add these two queries to
dbmail-utils on headercheck/repair.

---
delete from dbmail.dbmail_headername where id not in (select headername_id
from dbmail.dbmail_header) limit 50000;

delete from dbmail.dbmail_headervalue where id not in (select
headervalue_id from dbmail.dbmail_header) limit 50000;
---

limit would be a great idea, because first time executions could took
really long if you have 1.2M unconnected headervalues.

thx

Harald

Am 15.05.2012, 17:14 Uhr, schrieb ITronic Harald Leithner
<harald.leithner [at] itronic>:

> 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

--
Harald Leithner

ITronic
Vogelweidplatz 12, 1150 Wien, Austria
Tel: +43-1-786 23 88
Fax: +43-1-98 52 077
Mobil: +43-699-123 78 4 78
Mail: leithner [at] itronic | itronic.at
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

paul at nfg

Jul 31, 2013, 10:56 AM

Post #5 of 6 (44 views)
Permalink

Re: Housekeeping dbmail_headervalue [In reply to]

On 07/31/2013 11:27 AM, Harald Leithner wrote:
> Hi Paul,
>
> if you have time, it would be great if you can add these two queries to
> dbmail-utils on headercheck/repair.

I know, it's on my TODO. It's just not that high on the list. And I
would prefer to combine this with a clean-up of the header-cache setup
that will include the whitelisting we discussed.

--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin

* Premium Hosting Services and Web Application Consultancy *

www.nfg.nl/info [at] nfg/+31.85.877.99.97
________________________________________________________________
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

harald.leithner at itronic

Jul 31, 2013, 11:15 AM

Post #6 of 6 (44 views)
Permalink

Re: Housekeeping dbmail_headervalue [In reply to]

Good to known, whitelist would be great, I checked my unconnected values
and found 12M of them^^

But no hurry on this the workaround seams to work fine.

Am 31.07.2013, 19:56 Uhr, schrieb Paul J Stevens <paul [at] nfg>:

> On 07/31/2013 11:27 AM, Harald Leithner wrote:
>> Hi Paul,
>>
>> if you have time, it would be great if you can add these two queries to
>> dbmail-utils on headercheck/repair.
>
> I know, it's on my TODO. It's just not that high on the list. And I
> would prefer to combine this with a clean-up of the header-cache setup
> that will include the whitelisting we discussed.
>
>
>

--
Harald Leithner

ITronic
Vogelweidplatz 12, 1150 Wien, Austria
Tel: +43-1-786 23 88
Fax: +43-1-98 52 077
Mobil: +43-699-123 78 4 78
Mail: leithner [at] itronic | itronic.at
_______________________________________________
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