Some (fairly) simple step-by-step instructions to ensure your Magento Belfast 2 store is running the best it can.
While most of these options should only require access to Admin panel, most are dependent on your web server running specific software to allow them to work. Check with your hosting provider that Elasticsearch and Varnish are enabled and running.
Clear Database Logs
The first step to keeping a Magento install lean and fast is to remove or clear down the sometimes excessive log tables that accumulate in Magento. This can be completed through the Magento Admin Panel and doesn't require technical knowledge.
- Click into System > Configuration
- On the left hand menu click into Advanced > System
- Under System expad the "MySQL Message Queue Cleanup" section
- Set the values for all the values as required.
- Click "Save Config"
You can use a value of "1", this will keep messages in the logs for a maximum of one minute before they are cleared out. Be careful not to change this value to "0" This will stop the logs being cleared completely, not reduce them.
Enable Elasticsearch
Elasticsearch is a powerful and highly scalable distributed search engine that is used by high-volume sites such as eBay, Wikipedia and GitHub. The implementation of Elasticsearch includes both search suggestions and recommendations.
For this to work you will need to have your web server pre-configured with Elasticsearch
- Click into Stores > Settings > Configuration
- On the left hand menu click into Catalog > Catalog
- Expand "Product Search"
- Scroll to "Search Engine" and change to the recommended Elasticsearch option
- Click "Save Config"
Flat Catalogue Tables
Magento includes the option to generate "flat" product and category tables. What this does is create additional tables for the products and categories which don't use the standard Entity-Attribute-Value (EAV) set-up. EAV is great for making a scalable applicaton, but it can be cumbersome process when loading lots of values.
Flat tables help by creating dynamic tables that are indexed to include just the attribute-values needed and reducing the number of SQL queries. The bigger the Magento website the bigger the impact using Flat tables will have.
- Click into Stores > Settings > Configuration
- On the left hand menu click into Catalog > Catalog
- Expand the "Storefront" section
- Set "Use Flat Catalog Category" and "Use Flat Catalog Product" to "Yes".
- Click "Save Config"
You will be prompted to update your store's Cache. Follow the instructions.
Varnish Caching
Varnish is a caching tool that works as an additional layer between the web server and the user. Adobe recommend using Varnish with your Magento install.
For this to work you will need to have your web server pre-configured with Varnish
- Click into Stores > Configuration > Advanced > System > Full Page Cache
- Set "Caching Application" to Varnish Cache
My Magento Expertise
If you are planning a new e‑commerce store, considering a platform upgrade or looking for ongoing Magento support, I can provide the expertise you need. Based in Northern Ireland and working with clients locally and internationally, I deliver solutions that help businesses grow.
More Magento posts
—
Magento database structure
The database structure of Magento is designed to store and manage various aspects of an e-commerce website, including products, orders, customers, and more. Understanding the Magento database structure is crucial…
—
Accessibility in ecommerce websites
In the digital age, where online shopping has become an integral part of our lives, ecommerce websites hold the key to business success. Amidst the rush to create visually appealing…
—
Using Magento to get small businesses online
For small businesses aiming to establish a formidable online presence and drive sales, Magento emerges as a powerful e-commerce platform offering a suite of features tailored to their needs. Scalability…
Continue reading "Using Magento to get small businesses online"
—
How can I speed-up my Magento website?
Speed optimisation is crucial for a Magento website as it directly impacts user experience, conversions, and search engine rankings. You should prepare your server so it is set-up to use…