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 

Log-Cleaning.png