Optimize Your PrestaShop Database for Enhanced Performance

Is your PrestaShop store experiencing sluggish performance? It might be time for a database cleanup! As your online store grows, the database accumulates unnecessary data, affecting site speed and user experience.

Why Clean Up Your PrestaShop Database?

Many PrestaShop sites unknowingly retain outdated, redundant data after upgrades, leading to an overloaded database. This adversely impacts site speed and, consequently, user satisfaction and conversions. Regularly cleaning your PrestaShop database is crucial for maintaining optimal performance and boosting sales.

How to Clean Up PrestaShop Database

Step 1: Create a database backup

Before initiating any cleanup, ensure you create a backup through phpMyAdmin. This precautionary step prevents accidental data loss.

• Navigate to phpMyAdmin and select your website's database.
• Go to the "Export" tab, choose "SQL" format, and click "Go" to save the exported file.

Step 2: Delete connections statistics report

Clearing connections statistics is essential for database health.

Execute the following SQL commands in the "SQL" tab:

TRUNCATE TABLE ps_connections;

TRUNCATE TABLE ps_connections_source;

TRUNCATE TABLE ps_connections_page;

Step 3: Delete database logs

Remove unnecessary logs from the database.

Execute SQL Query: TRUNCATE TABLE ps_log;

Continue with similar steps for other sections such as page not found errors, referrer statistics, store search statistics, mail logs, and expired product prices. Ensure to follow precise SQL commands for each category.

Step 4: Delete the content of the "ps_pagenotfound" table

The "ps_pagenotfound" table stores data related to “page not found” errors (404 errors). To maintain a clean database, execute the following SQL query:

TRUNCATE TABLE ps_pagenotfound;

This step ensures that irrelevant data from 404 errors is removed, promoting a smoother database operation.

Step 5: Delete the statistics report for referrers

Clearing referrer statistics is essential for a clutter-free database. Execute the following SQL commands to achieve this:

TRUNCATE TABLE ps_referrer;

TRUNCATE TABLE ps_referrer_shop;

TRUNCATE TABLE ps_referrer_cache;

By removing referrer statistics, you optimize your database for improved performance.

Step 6: Delete your store search statistics

Run the following command to truncate the "ps_statssearch" table:

TRUNCATE TABLE ps_statssearch;

This step eliminates unnecessary search statistics, contributing to a more efficient database.

Step 7: Delete mail log

Execute the SQL query below to clear the mail log from the "ps_mail" table:

TRUNCATE TABLE ps_mail;

Removing mail logs helps free up space in the database, ensuring optimal functionality.

Step 8: Delete expired product prices

To maintain accurate pricing information, execute the following SQL commands:

DELETE FROM `PREFIX_specific_price` WHERE `to` != '0000-00-00 00:00:00' AND `to` < NOW();

DELETE FROM `PREFIX_specific_price_rule WHERE `to` != '0000-00-00 00:00:00' AND `to` < NOW();

Note: Replace "PREFIX" with your database prefix, for example, "ps_specific_price."

Step 9: Remove temporary images

Using your hosting or FTP credentials, log in and navigate to the "PRESTASHOP_ROOT/img/tmp" folder. Delete all files in this folder to remove temporary images.

Removing temporary images contributes to freeing up storage space and streamlining database performance.

Step 10: Delete Smarty cache database

Clear Smarty cache for optimal performance:

TRUNCATE TABLE ps_smarty_cache;

TRUNCATE TABLE ps_smarty_last_flush;

TRUNCATE TABLE ps_smarty_lazy_cache;

These steps ensure a thorough cleanup of your PrestaShop database, promoting efficient operation and contributing to enhanced website performance. Regularly scheduling these cleanups is essential for the long-term health of your online store's database.

Simplify Database Cleanup with Super Speed Module

Manually cleaning your PrestaShop database can be tedious. Introducing our Super Speed module! This ultimate tool streamlines the cleanup process, allowing you to clear connection logs, page views, discount codes, abandoned carts, and guest data effortlessly.

Say goodbye to manual cleaning and supercharge your database maintenance with the Super Speed module! Ensure your PrestaShop store operates at its best by scheduling regular cleanups following our comprehensive guide.

 DOWNLOAD SUPER SPEED NOW