If you have a Magento CE 1.X webshop then that means it might also be old by now. Does it runs and loads slower with each passing day?
This slow-down could be due to the size of your Magento database. The size of the database can depend on alot of factors, including number of products in your webshop. With time, Magento database also ends up collecting alot of junk logs and un-necessary data. The bloated database can eat-up alot of disk-space of your server and it can slow down your webshop's frontend and backend. A slow webshop is never good for sales and business. Therefore, it is highly recomened that you regularly clean-up your Magento database. There are many easy ways to do that.

We will explain a few of them in this post today. If you are a developer then you can use one of the first 2 methods. If you are a non-technical webshop administrator then go for the third option. Make sure that you take a back-up of your database before running any script of queries on it.

1. Via SSH
Login to the server where your Magento webshop is hosted and then navigate to your Magento root directory using 'cd' command. From Magento root directory, you can run following command:

php -f shell/log.php clean

This will run the standard log clea-up script in Magento. You can also setup a cron job to do this periodically and automatically.

2. Via PHPMyAdmin
If you have database access then open it in PHPMyAdmin and run following query:

TRUNCATE dataflow_batch_export;
TRUNCATE dataflow_batch_import;
TRUNCATE log_customer;
TRUNCATE log_quote;
TRUNCATE log_summary;
TRUNCATE log_summary_type;
TRUNCATE log_url;
TRUNCATE log_url_info;
TRUNCATE log_visitor;
TRUNCATE log_visitor_info;
TRUNCATE log_visitor_online;
TRUNCATE report_viewed_product_index;
TRUNCATE report_compared_product_index;
TRUNCATE report_event;

Magento CE 1.X log cleanup sql query

Once run successfully, it will display a success message like this:

You can also select following database tables manually and at the bottom you can select ‘Empty’ from the drop-down ‘With selected and click 'Yes'. This will clear all these tables.


3. Automatic log cleaning
You can also setup automatic cleanup of logs from Magento backend.
Login to your Magento CE 1.X backend > go to System > Configuration > Advance > System > Log cleaning > Enable Log Cleaning = Yes > Setup time and frequency for this clean-up > Save config.

It can also send you error notification emails if there are any problems with the clean-up. We recommend you set it to clean the database atleast once every month.

Following tables are cleaned up by this automatic feature:

By doing this simple database clean-up, you can decrease the size of your database by upto 70%. Lighter database performs faster and faster webshops sell more.

Feel free to contact Hungersoft if your Magento webshop is still running slow. We are experts at Magento speed optimization and can speed-up any webshop.

Live chat: cookie consent required

Copyright © Hungersoft 2019

· Terms & Conditions · Privacy policy