Re: dbmail_headervalue

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: [email protected] [mailto:[email protected]] On
> Behalf Of Reindl Harald
> Sent: domingo, 14 de Dezembro de 2014 17:03
> To: [email protected]
> 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)
>