Just read what you quoted - the sql result is part of it. :-)
-------- Ursprüngliche Nachricht -------- Von: Jorge Bastos <mysql.jo...@decimal.pt> Gesendet: 20. Dezember 2014 00:22:13 MEZ An: 'DBMail mailinglist' <dbmail@dbmail.org> Betreff: Re: [Dbmail] dbmail_headervalue Reindl, Tell me, i'm curious to know which headername do you have, can you share? I'm curious. > -----Original Message----- > From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On > Behalf Of Jorge Bastos > Sent: domingo, 14 de Dezembro de 2014 18:23 > To: 'DBMail mailinglist' > Subject: Re: [Dbmail] dbmail_headervalue > > Hum, > > Fact is I have garbage in headername table also, i have things that ARE > NOT headers, but they are there (garbage!): > > +--------------------------------------------------+ > | headername | > +--------------------------------------------------+ > | "x-copyrighted-material | > | #content-transfer-encoding | > | #content-type | > | /m | > | 0 | > | 0/x-total-score | > | 1 | > | 2 | > | 2/x-brightmail-tracker | > | 2/x-total-score | > > So yes, the header_cache_readonly = yes will help on this. > I'm going to delete the garbage headername's like this one's and leave > only the "x-......" and a few extra one's that I know that are needed, > and then apply the header_cache_readonly = yes, and after, truncate the > headervalue's and dbmail-util -by it. > > > -----Original Message----- > > From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On > > Behalf Of Reindl Harald > > Sent: domingo, 14 de Dezembro de 2014 17:21 > > To: dbmail@dbmail.org > > Subject: Re: [Dbmail] dbmail_headervalue > > > > correct > > > > keep in mind that "header_cache_readonly = yes" will prevent from > > adding any headers again - i removed all, inserted the needed > manually > > in headernames and than rebuilt > > > > got rid millions of records forever that way > > > > Am 14.12.2014 um 18:10 schrieb Jorge Bastos: > > > So, > > > > > > Truncate dbmail_headername; > > > Truncate dbmail_headervalue; > > > Dbmail-util -by > > > > > > During this time only IMAP will compaint since it won't have > headers > > > to show, but there's no problem to have IMAP users connecting > during > > > this time, when the re-fill is finish, everything will look normal > > > on imap clients, right? > > > > > >> -----Original Message----- > > >> From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] > > On > > >> Behalf Of Reindl Harald > > >> Sent: domingo, 14 de Dezembro de 2014 17:03 > > >> To: dbmail@dbmail.org > > >> Subject: Re: [Dbmail] dbmail_headervalue > > >> > > >> > > >> > > >> Am 14.12.2014 um 17:59 schrieb Jorge Bastos: > > >>> I have allot, I mean, millions of lost records in the > > >>> dbmail_headervalue table. > > >>> > > >>> About 72 million lost records, with dbmail-util it cannot handle > > >>> it > > >> in > > >>> a workable time. > > >>> > > >>> Is it safe to truncate the table, and dbmail-util -by it? > > >> > > >> yes and you should consider "header_cache_readonly = yes" and > > cleanup > > >> "dbmail_headername" too - maybe that alone will be enough to get > > >> rid of 90% > > >> > > >> MariaDB [dbmail]> select * from dbmail_headername; > > >> +--------+-------------------+ > > >> | id | headername | > > >> +--------+-------------------+ > > >> | 183 | cc | > > >> | 8 | content-type | > > >> | 1 | date | > > >> | 2 | from | > > >> | 62 | importance | > > >> | 44 | in-reply-to | > > >> | 3 | message-id | > > >> | 9 | mime-version | > > >> | 111813 | newsgroups | > > >> | 380 | priority | > > >> | 47 | references | > > >> | 38 | reply-to | > > >> | 68 | status | > > >> | 6 | subject | > > >> | 69 | thread-index | > > >> | 179 | thread-topic | > > >> | 7 | to | > > >> | 109464 | x-msmail-priority | > > >> | 111823 | x-msoesrec | > > >> | 109408 | x-priority | > > >> | 111825 | x-ref | > > >> +--------+-------------------+ > > >> 21 rows in set (0.00 sec) > > > _______________________________________________ > DBmail mailing list > DBmail@dbmail.org > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail -- Reindl Harald (mobile) the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / CISO / Software-Development +43 (676) 40 221 40 http://www.thelounge.net _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
