JOOIM DB Cleaner is a free module for PrestaShop that helps reduce database size by safely removing old visitor statistics records and optionally clearing the faceted navigation cache table.
Features
- Deletes old records from the ps_connections table.
- Removes related records from ps_connections_source and ps_connections_page.
- Optionally clears the ps_layered_filter_block table.
- Displays the approximate database size.
- Stores logs of recent cleanup runs.
- Provides both CLI cron and HTTP cron execution protected by a token.
Requirements
The module is free and requires PrestaShop. No PHP or PrestaShop version detected.
Main features
Remove old statistics
Deletes old records from ps_connections and related tables.
Optional cache clearing
Can optionally clear the ps_layered_filter_block table.
Display database size
Displays the approximate database size.
Logs of recent cleanups
Stores logs of recent database cleanups.
Token-protected cron
Provides CLI cron and HTTP cron execution protected by a token.
Changelog
- Introduced automatic database cleaning feature.
- Enhanced database optimization algorithms.
- Added detailed performance reporting.
- Improved user interface for easier navigation.
- Ensured compatibility with PHP versions 8.1 to 8.3.