Magento - Database Performance

One of the most time consuming process of the Magento store is its interaction with the database. Optimizing Magento Database is an important task to maintain the Magento site. Magento saves a lot of database because of tracking. The E-commerce system must have a tracking module which shows information when something goes wrong with their order.

Following are some tips to improve the performance of database −

Unused data must be cleaned up regularly for better performance.

Optimize database queries.

Configure setting and pmits of the database server (e.g. memory setting, query cache, sort buffer optimization).

You can optimize Magento database log cleaning as shown in the following steps −

Step 1 − Login to your Magento Admin Panel.

Step 2 − Go to System menu and cpck on the Configuration option.

Step 3 − On the left side of the navigation bar, go to Advanced section and cpck on the System option.

Step 4 − Expand the Log Cleaning panel, change "Enable Log Cleaning" to Yes option and cpck the Save Config button.