Re: 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
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iEYEARECAAYFAlSNwtwACgkQhmBjz394AnktbwCfUpHYOMmyfZsxoCFvGlrEqAUF
zKIAnAjwKzsB9lRmyS+Q7ABG8pIzUNEX
=1OiP
-----END PGP SIGNATURE-----