Re: [Dbmail] dbmail_headervalue

[Reindl Harald]

correct




got rid millions of records forever that way

Am 14.12.2014 um 18:10 schrieb Jorge Bastos:

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

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)

signature.asc
Description: OpenPGP digital signature

_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail