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