Home ⟩ About Fruition ⟩ Blog ⟩ Magento Logs – How to Reduce your Magento Database Size

Magento Logs – How to Reduce your Magento Database Size

Posted on October 2, 2012 • Written by Brad Anderson

For busy Magento sites the log files bloat the database in a matter of minutes. The largest Magento logs are typically log_url_info, log_visitor_info, and log_url. This posts will walk you through how to minimize your Magento logs to keep your database size reasonable while not loosing an unnecessary amount of information.

Set your Magento Crons to Reduce the Database Size

Option 1. Clear the Magento Dabase Logs – The first option is to set the Magento crons to run frequently to clear these tables out.

Use Amazon RDS for Your Magento Logs

Option 2. Edit Magento to use Amazon RDS.
This requires some development work. Fruition just completed this for a client and will post a full right up soon.

Written by Brad Anderson

Brad Anderson is the Executive Director and Founder of Fruition. Brad’s focus is supporting Fruition’s team to enable sustainable growth and excellent client satisfaction (EBITDA growth). With a strong statistical background, Brad built Fruition’s in-house software that is used to manage client success.