How to Clean log in Magento for database maintenance & site performance ?
Log cleaning gives dramatic improvement in site performance. Manage DB through log cleaning decrease DB size which gives better site performance. There are 2 ways to perform cleaning log in magento database.
- Through Magento Admin Panel
- Through phpMyAdmin
1. Cleaning log through administrator interface
Log on to your Magento Admin Panel. Go to System => Configuration. On the left side under Advanced click on System (Advanced = > System). You will see Log Cleaning option.
Under Log Cleaning, change Enable Log Cleaning to Yes and configure the Save Log for 15 days.
2. Log cleaning with phpMyAdmin
select the check box for the following tables:
log_customer
log_quote
log_summary
log_summary_type
log_url log_url_info
log_visitor log_visitor_info
log_visitor_online
At the bottom of the page, Click the drop down combo Box named Selected list, & select Empty. This will truncate all of the selected tables.
0 Comment(s)