If you want to improve the performance of the database used by your Magento store, there are some aspects to keep in mind:
Cleaning log files
Magento keeps certain tables for storing certain login information when a customer visits your site. They are stored in certain tables in the database and it is recommended that they be cleaned periodically. By default, Magento stores this data without cleaning it.
You can delete these files in several ways:
1. Clean the logs from the Magento administration panel
Log in to the Magento admin panel - System-> Configuration section
In the menu on the left locate the Advanced menu - click on System
From the panel select Log - and from the Enable Log Cleaning section select Yes
Select the number of days to store - ex 15 in the Save Log Days field
Click Save Config
This will lead to the cleaning of the above mentioned logs after 15 days.
2. You can delete them manually from phpMyAdmin
If you are familiar with working with databases, this is the fastest option and you can do multiple optimizations for multiple tables.
Log in to the cPanel and access phpMyAdmin
Identify the database used by your Magento application
dataflow_batch_export
dataflow_batch_import
log_customer
log_quote
log_summary
log_summary_type
log_url
log_url_info
log_visitor
log_visitor_info
log_visitor_online
report_viewed_product_index
report_compared_product_index
report_eventSelect the tables above and select Empty
A confirmation message will appear, click on Yes
Click on Structure - at the top of the page
Select the same tables and select Optimize
Many times if you have not performed such an operation so far, a 2GB database used by your Magento site can decrease in size by 75% eliminating these logs.
