You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@manifoldcf.apache.org by Shigeki Kobayashi <sh...@g.softbank.co.jp> on 2012/10/05 07:31:01 UTC
Does Simple History Report accumulated into DB forever?
Hi.
I have a question about Simple History Report.
AS MCF crawls whatever, data of simple history report is recorded into DB.
Does each of the data have expiration? Or history data is accumulated in DB
forever?
I run MCF on MySQL with InnoDB tables. I have concerened about data files
getting too big.
I wonder what evreyyone does to prevent DB from running out of a storage
Regards,
Shigeki
Re: Does Simple History Report accumulated into DB forever?
Posted by Karl Wright <da...@gmail.com>.
Simple history will grow indefinitely. The data is associated to
connections, so deleting a connection will clean up its associated
history.
If you want to delete history records manually, to save disk space,
that is also fine. There are no database integrity constraints that
will be violated if you do this.
Karl
On Fri, Oct 5, 2012 at 1:31 AM, Shigeki Kobayashi
<sh...@g.softbank.co.jp> wrote:
>
> Hi.
>
> I have a question about Simple History Report.
>
> AS MCF crawls whatever, data of simple history report is recorded into DB.
> Does each of the data have expiration? Or history data is accumulated in DB
> forever?
>
> I run MCF on MySQL with InnoDB tables. I have concerened about data files
> getting too big.
> I wonder what evreyyone does to prevent DB from running out of a storage
>
> Regards,
>
> Shigeki