Magento database maintenance
Magento, like most modern websites, stores its information in a database. PHP is used to extract it and turn it into HTML, which your web browser then renders.
The larger your database is, the harder your server has to work searching through more records to find the correct information it needs in order to display a page to your web site user
The guide below details how you can perform Magento database maintenance using Magento’s admin panel or phpMyadmin
As always, make sure you backup your database before making any changes.
Did you know…
At Clook, one of our specialisms is providing Magento optimised hosting, if you’d like to find out more, please get in touch with us.
Clean your Magento database using the Magento admin panel
Log into the Magento admin panel
Log into your admin panel by visiting the admin URL
This is by default www.yourdomain.com/index.php/admin unless you specified otherwise when installing Magento
Navigate to System > Configuration
On the left hand menu, navigate to Advanced > System
Choose “Yes” in the “Enable Log Cleaning” dropdown box.
Complete the rest of the settings as you see fit. Here I’ve set log files to be deleted after 30 days and for the database clean to be run daily at 01:00
Clean your Magento database using cPanel and phpMyAdmin
Login to your cPanel account
Navigate to your login page for cPanel. This is normally your domain name or IP address followed by /cpanel
Click the phpMyAdmin link in the database section
In the top left area of the page, click on the relevant database
On the right hand window, search for the following and tick the box next to the table name:
Then scroll to the bottom of the page and you’ll see a dropdown box “With selected:”
Select “Empty” from the dropdown menu.
On the next page you’ll see the following warning
Confirm that the table names are correct and then click the “Yes” button on the right hand side of the page
It is not unusual to see large Magento databases decrease significantly in size (we’ve seen some decrease by over 70%!) after performing Magento database maintenance.
If you want your Magento store to keep running smoothly, you should perform a Magento database purge regularly. Consider creating a Cron job to do this for you.