1) go to magento root then in shell/ directory
2) execute "php -f log.php status"
(in my case Data size is 150 MB)
3) execute "php -f log.php clean"
4) execute again "php -f log.php status" for checking the cleaning action.
(it should show a decreased size from 150 MB, but it doesn't.
Well I truncated manually all the tables inside the databases and checking again the status it is decreased to 164 kb. This is a bug, this file is not cleaning the log tables. By the way I already reported in Bug List. Thank you.
DId you check the number of rows in each of the tables because the clean method will not just get rid of all rows. Specifically url and visitor cleaning are done in batches of 100 records so if you have many it will take a while to reduce.
Also, you will not actually see a reduction in space after running the script.
This is because mysql innodb tables do not release the space created when you delete rows. Truncating the tables does release the space which is what you have seen in your case.
Try with '--days'
php -f log.php clean --days 1
At the moment, My issue is cron.php not handling cleaning log event. Have done everything in Admin Panel, Cron Job is running fine but still no trace of log cleaning event in `cron_schedule` table.