Magento is one of the most widely used ecommerce platforms in the world. Since it’s open source, providing robust flexibility and the ability for extensive customization, it requires ongoing maintenance at both the application level and the database level.
If you have a Magento site or are thinking of building on Magento, maintaining your database and following best practices for ongoing support and monitoring is crucial to maximizing your revenue and preventing security risks.
These are some best practices to ensure your e-commerce site built on Magento thrives.
Do You Need A Magento Database Cleanup?
Your website’s database requires regular maintenance and optimization so you can provide an excellent user experience for your customers.
One of the most important reasons to conduct a Magento cleanup is to increase the speed of your ecommerce site. With more options for consumers to purchase online than ever before, website speed should be a top priority for every business owner. Even a 1-second delay in page speed can lead to a 7% decrease in conversions. Additionally, page speed is an important ranking factor and can affect your website’s ranking position in Google’s search results.
One of the major causes of a slow down of your website is due to a sluggish database. You can check your website speed using tools like Google’s PageSpeed Insights, Pingdom Tools, or GTMetrix to find out if this is affecting your site.
After running one of these tests, if you see that your website speed is underperforming, these are some ways you can run a Magento database cleanup and increase its performance.
Clean Your Logs
When you need a Magento database cleanup, start with your site’s logs. If you haven’t already done so, you can set up automatic log cleaning in your admin panel. In the system menu, navigate to configurations. Click system under the advanced section. Here, you’ll be able to enable log cleaning and set the number of days you’d like to keep the log before it’s cleaned. This will help your database stay at a manageable size automatically.
You can also clean your Magento database logs manually with PHPMyAdmin. Select the tables you want to clean, specifically with dataflow, log, and report file paths, then select empty. However, manual database cleaning is only recommended if you’re familiar with database management and have a full backup of your site before going through with it.
If you don’t have a need for database logging, you can turn it off with certain extensions that will prevent logging functions. There are also tools created for developers that will perform an entire database dump; however, this should only be used by professionals.
Install Monitoring Tools
After you’ve cleaned up your Magento database, there are a few steps you can take to keep on top of any problems before they begin to pile up. Certain AMP Application Monitoring Programs will alert you via email or your admin panel when there’s an issue.
New Relic is a premium paid option that monitors database queries and identifies which ones are running the slowest. Once you’re aware of the database queries that are taking the longest, you can take steps to fix it. It will also keep track of the applications you use on your website and let you know which ones are slowing your website down.
Pingdom’s server monitor tool keeps track of CPU, network, disk, memory, and process data issues. You can configure notifications so that you’re alerted via email or text when major problems arise that require your attention.
Within your hosting architecture, logging tools like Nagios help to detect server and database issues. Nagios is especially valuable for identifying security threats, scaling, and integration with third-party solutions.
Perform Scheduled and Preventative Maintenance
Check your Magento admin panel regularly to receive notifications when a new update is available. Staying on top of updates is an important part of Magento cleanup so your website will remain secure and running smoothly.
Before you run an update, make sure you have a fresh backup of your files and your database. It’s always a good idea to backup your database regularly, especially before making any changes. Store it off of your server so there’s no decrease in website performance.
It’s also a best practice to run an update when your ecommerce store has fewer visitors on the site. You can check the number of visitors in the real time data menu of Google Analytics.
If you’re running Magento 1, check for updates under the manage existing extensions menu. Select the most recent version and click on commit changes.
If you’re using Magento 2, go to system in your dashboard. Select web setup wizard and choose the Magento version you want to upgrade to. Follow the prompts to go through the readiness check and create the database before it’s upgraded.
If you’re considering upgrading from Magento 1 to Magento 2, we can help. Get in touch with one of our experts by filling in the form to the right.
You can also use tools like the Magento Cleanup Tool that will help optimize your website, as shown in this video.
Caching is an excellent way to speed up your website. There are cache options offered natively in Magento, and you can also use third-party applications to further improve caching functions. To use the cache function within the Magento dashboard, navigate to System and then Cache Management. Enable all options for best results.
Browser caching is another form that can be used to speed up your site by adding expire headers and enable gzip compression. Many of the free speed tools mentioned above will mention if one of these is causing your site to lose speed.
Do you need help auditing your Magento website’s health? Are you considering re-platforming to Magento 2? Our experts can help. Fill in the form to the right and we’ll be in touch with you as soon as possible.
The Accelerate Agency was the recipient of the Rocket Award from Magento in 2018. We have completed over 100 Magento 2 implementations and we have the most experience with Magento’s Cloud Environment in the world.