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.
Option 1. Clear the Magento Dabase Logs – The first option is to set the Magento crons to run frequently to clear these tables out.
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.
Brad Anderson is the Founder and CEO 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.
President & Founder, Tru Family Dental
Marketing, Dependable Cleaners
President, Frame Destination
President & Founder, Family Travel Association