[imp] Very large tables

[Jan Schneider]

Zitat von Federico Giannici <giannici at neomedia.it>:

> On 08/29/17 12:53, Arjen de Korte wrote:
>> Citeren Federico Giannici <giannici at 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/