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
