Zitat von Federico Giannici <giann...@neomedia.it>:
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.janma
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
No, you can safely remove those. In the long term you should use a
different VFS backend than SQL though.
--
Jan Schneider
The Horde Project
https://www.horde.org/
--
imp mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: imp-unsubscr...@lists.horde.org
