Magento stores a lot of logging information in the database tables prefixed with log_e.g. log_visitor_info, log_url_info, etc. As with Magento’s session files, if not handled properly, these tables will grow out of control and hinder performance.
Magento has automated log cleaning functionality built in, but it is not enabled by default. Here’s how to turn it on.
- Firstly you need make sure Magento’s cron system is running.
If you are unsure about this, see this article on setting up cron (scheduled tasks).
- Once cron is enabled and running, simply enable log cleaning via the admin:
System > Configuration > Advanced > System > Log Cleaning
As per the screenshot below, I like to save 1 days logs, and perform the cleaning at 4:00am each morning.