Log Cleaning
Magento 1.X stores several logs in the Magento database related to visitors of your site. A few of these tables are:
- log_url
- log_url_info
- log_visitor
- log_visitor_info
If these tables get very large, they can slow down your frontend and backend considerably (when you hit several hundred thousand rows). To clean these manually, you can do so via the MYSQL command line with a query like this –
delete from log_url;delete from log_url_info;delete from log_visitor;delete from log_visitor_info;
With these cleared, you should lower the retention period via System->Advanced->System