Book Image

Magento 2 Development Cookbook

Book Image

Magento 2 Development Cookbook

Overview of this book

With the challenges of growing an online business, Magento 2 is an open source e-commerce platform with innumerable functionalities that gives you the freedom to make on-the-fly decisions. It allows you to customize multiple levels of security permissions and enhance the look and feel of your website, and thus gives you a personalized experience in promoting your business.
Table of Contents (13 chapters)
12
Index

Optimizing the database and MySQL configurations


The Magento applications use a database to store all the data, including products, customers, orders, and more. The database is the central storage of all the data that is available in the Magento instance. Scaling Magento to multiple frontend servers is not that hard but scaling the database is much harder because the data is something that needs to be in sync.

In this recipe, we will see how we can optimize the database and the MySQL server.

Getting ready

Ensure that you have access to a database client where you can do some queries to your database. In this recipe, we will use phpMyAdmin.

How to do it...

In the first part of this recipe, we will optimize the table structures of the Magento database. Take a look at the following steps:

  1. Open phpMyAdmin and click on the Magento database. You will see an overview of all the tables.

  2. At the bottom of this page, click on the Check All button.

  3. When you click on the dropdown list, you can repair the table...