How to clean DB from old logs in Magento 1.x

How to clean DB from old logs in Magento 1.x

Using MySQL

truncate log_customer;
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;

login to shell(SSH) 
go with root/shell folder.

execute the below command inside the shell folder
 
php -f log.php clean
 
enter this command to view the log data's size

php -f log.php status

This method will help you to clean the log data's very easy way.