- Magento Basics Tutorial
- Magento - Home
- Magento - Overview
- Magento - Installation
- Magento - Architecture
- Magento Store Setup
- Magento - Product Overview
- Magento - Setup Languages
- Magento - Setup Contact
- Magento - Setup Categories
- Magento - Setup Products
- Magento - Setup Inventory
- Magento - Setup Taxes
- Magento - Setup Shipping Rates
- Magento - Setup Payment Plans
- Magento - Setup Payment Gateway
- Magento - Setup Payment Methods
- Magento - Setup Currencies
- Magento - Setup Check Out Options
- Magento - Setup Paypal Payment
- Magento - Setup Google Checkout
- Magento - Setup Store Live
- Magento Order Processing
- Magento - Orders Life Cycle
- Magento - Setup Order Options
- Magento - Setup Order Emails
- Magento - Create Orders
- Magento - Manage Orders
- Magento System Setup
- Magento - Setup Customers
- Magento - Setup Google Analytics
- Magento - Setup Pretty URLs
- Magento - Setup Youtube Video
- Magento - Setup Facebook Likes
- Magento - Setup Translation
- Magento - Setup System Theme
- Magento - Setup Page Title
- Magento - Setup Page Layout
- Magento - Setup New Pages
- Magento - Setup CMS
- Magento - Setup Newsletter
- Magento Optimization
- Magento - Site Optimization
- Magento - Profiling
- Magento - Database Performance
- Search Engine Optimization
- Magento Useful Resources
- Magento - Questions and Answers
- Magento - Quick Guide
- Magento - Useful Resources
- Magento - Discussion
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 limits 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 click on the Configuration option.
Step 3 − On the left side of the navigation bar, go to Advanced section and click on the System option.
Step 4 − Expand the Log Cleaning panel, change "Enable Log Cleaning" to Yes option and click the Save Config button.