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:
Open phpMyAdmin and click on the Magento database. You will see an overview of all the tables.
At the bottom of this page, click on the Check All button.
When you click on the dropdown list, you can repair the table...
