Reindl, Thanks, i just wanna to have a more consistant ideia of the headers to use.
> -----Original Message----- > From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On > Behalf Of Reindl Harald > Sent: sábado, 20 de Dezembro de 2014 12:36 > To: dbmail@dbmail.org > Subject: Re: [Dbmail] dbmail_headervalue > > > Am 20.12.2014 um 10:33 schrieb Jorge Bastos: > > Oh hum :) > > > > Do you have: > > > > Date > > Subject > > From > > To > > Sent > > uhm i posted what i have and it's in every quote of that thread > > > > >> 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) > > > Question is, the ones that end up with null in the sort column i > think > > are garbage also, am i right? :) > > the only relevant question is if mail cliets are using a header for > sorting, display, threading and so on in the list view > > > "Reindl Harald (mobile)" <h.rei...@thelounge.net> wrote: > > 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
