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.
President & Founder, Tru Family Dental
Marketing, Dependable Cleaners
President, Frame Destination
President & Founder, Family Travel Association