FPC Warmer logs allocate too much space in database. How to solve this?

FPC Warmer logs allocate too much space in database. How to solve this?

Sometimes, data in the amasty_fpc_activity table may pile up and take a lot of space, which can cause certain performance issues on your website. To prevent this, it is recommended to regularly clear the Activity Log.

You can do this manually or set up automatic cleaning. Here’s how to manage both methods:

1. To manually clear the table, go to the Admin Panel, navigate to Amasty > Full Page Cache Warmer > Activity Log and press the Clear Log button.


Alternatively, you can clear the Activity Log directly from the Magento database. Simply execute the following SQL query:

TRUNCATE TABLE amasty_fpc_activity;

2. To enable automatic cleaning, navigate to Amasty > Full Page Cache Warmer > Configuration and activate the Activity Log Full-Cleaning option. It will automatically clean all the records that are available at the time of cleaning by Cron. The cron schedule can be set in Full-Cleaning Schedule option within the same configuration area.
.



Please note: if the Activity Log Full-cleaning feature is enabled, the Activity Log will be completely cleared by Cron. If Activity Log is used as Queue Generation Source we recommend you configure the Log cleanup run after the Queue Generation Schedule run.

Additionally, if customer activity is not used as an active Queue Generation Source for the warmer queue generation, it is possible to disable the log on the Full Page Cache Warmer configuration page:

      • Related Articles

      • Does Full Page Cache Warmer work with a Load Balancer?

        The Full Page Cache Warmer extension does not explicitly cache any pages. Instead, it crawls the pages with certain parameters and triggers the existing Magento caching mechanisms (Built-In cache, Varnish, Fastly, etc.) to cache these pages. ...

      • How can I know that the Full Page Cache Warmer extension is working?

        To check whether the extension is working, you may generate the queue and start the warming process in System > Amasty FPC Warmer > Warmer Queue. After that, the links should start populating the warmer log at in System > Amasty FPC Warmer > Warmer ...

      • Does the Full Page Cache Warmer extension work with Fastly?

        The Full Page Cache Warmer extension is compatible with Fastly CDN. After the warming is done, upon visiting the page, you can check the cache status of the page in the X-Cache parameter. If it contains HIT, MISS/HIT, HIT/MISS, HIT the pages are ...

      • How many pages the Full Page Cache Warmer extension warms per hour?

        It is hard to provide the exact number of pages that the Full Page Cache Warmer extension can warm per hour as the warming speed fully depends on the server performance. However, you may get the approximate number of pages by dividing 3600 (an hour ...

      • How to Configure the FPC Warmer Extension?

        To ensure the FPC Warmer extension automatically warms pages on your website, you need to set up a valid warming schedule. Follow these steps for proper configuration: 1. Set the Queue Max Size First, estimate how many pages should be warmed based on ...