Am 19.03.2014 12:50, schrieb Paul J Stevens: > dbmail.conf now adds a new options 'header_cache_readonly = yes|no', > Setting it to 'yes' will prevent addition of new rows to the > dbmail_headername table. You can now start pruning that table, without > having to worry about new messages re-adding those rows
thank you! that is great - below numbers after limit that to 21 headers and doing a "optimize table" after running dbmail-util Database: 7,38 GB Data: 7,10 GB Keys: 282,65 MB Database: 7,20 GB Data: 7,04 GB Keys: 168,76 MB ALTER TABLE `dbmail_header` ENGINE=InnoDB ROW_FORMAT=COMPRESSED; ALTER TABLE `dbmail_headername` ENGINE=InnoDB ROW_FORMAT=COMPRESSED; ALTER TABLE `dbmail_headervalue` ENGINE=InnoDB ROW_FORMAT=COMPRESSED; MariaDB [dbmail]> select * from dbmail_headername order by headername; +--------+-------------------+ | id | headername | +--------+-------------------+ | 183 | cc | | 8 | content-type | | 1 | date | | 2 | from | | 62 | importance | | 44 | in-reply-to | | 3 | message-id | | 9 | mime-version | | 111792 | newsgroups | | 380 | priority | | 47 | references | | 38 | reply-to | | 68 | status | | 6 | subject | | 69 | thread-index | | 179 | thread-topic | | 7 | to | | 109464 | x-msmail-priority | | 111802 | x-msoesrec | | 109408 | x-priority | | 111804 | x-ref | +--------+-------------------+ 21 rows in set (0.00 sec)
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
