On 08/29/17 12:53, Arjen de Korte wrote:
Citeren Federico Giannici <giann...@neomedia.it>:
Hi!
We are using Horde as WebMail for a few hundreds of users.
In the last months I have noticed that the disks load (two SSD in
RAID1) is grown a lot. We use MySQL (actually MariaDB) as DB. I looked
at the tables and have noticed that there are two very large tables:
- horde_vfs: 24G size, 74 thousands records
- horde_imap_client_message: 12G size, 6 million records!
Are these sizes and number of records "normal"?
Neither are purged automatically, so this may be normal.
Is there any mechanism to purge old records from these tables? Or they
will grow forever?
You can use 'imp-query-imap-cache --lifetime <seconds>' to trim
'horde_imap_client_message'. Nothing will be lost, anything not in the
cache will be retreived from the IMAP server again, possibly causing a
slight delay.
Oh!
I didn't noticed that command.
I seems it's just what we were looking for...
Regarding 'horde_vfs', it really depends on what is in there. It can be
used for several things. Attachments and drafts can be stored there
before sending and you may wish to trim very old entries. But it can
also be used for more permanent storage, in which case trimming is
probably not such a good idea. Things will be permanently lost, so be
careful here, as it will p*ss off your users if you remove things they
actually use.
Looking at the DB contents, it seems that this table is used at 99,9%
for email composition, so I think we could safely delete the records
older than a day.
The question is: can we safely simply delete entries from the horde_vfs
table (filtering for vfs_path = ".horde/imp/compose")? No references
will be broken in some other table?
Thanks
--
imp mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: imp-unsubscr...@lists.horde.org
