magento clear the database log

Magneto website:fridge-magnet-online-shop

Set magento automatically empty the database log log magento thin speed.
  Some time to look at the magento database, found a huge database change. This is caused magento itself will not clear the log by default. Bloated magento database in the log for us to do a backup move is very convenient for our servers also no good. In addition to these records log magento table can manually empty the can also set the magento own timing empty the database log files.  Set magento automatically empty the log method is as follows.
  1) log on to your magento background to enter the System> Configuration 2) in the left column to enter the Advanced> System 3) Open the Log Cleaning  
4) Set the "save log, and days to a value, this unit is days, I feel empty just  once a few days 5) is set to activate automatically empty log settings
    
Set in to view your magento site less time automatic operation, after all, your server will consume. 

Added:

To manually empty the log table, the reference to clear the table below, if phpmyadmin more easily pay attention to your table prefix, do not directly paste the following code to avoid coding errors caused by, the best the phpmyadmin operation or handwritten code.

TRUNCATE `log_quote`;
 TRUNCATE `log_summary`.;
 TRUNCATE `log_summary_type`;
 TRUNCATE `log_url`;
 TRUNCATE `log_url_info`;
 TRUNCATE `log_visitor`;
 TRUNCATE `log_visitor_info`;
 TRUNCATE `log_visitor_online`;
 TRUNCATE `report_event`;
 TRUNCATE `report_event_types`;


My Magneto website:MINI-fridge-magnet |foot locker