cancel
Showing results for 
Search instead for 
Did you mean: 

CE1.9.2.1 - log.php script is not cleaning log tables

CE1.9.2.1 - log.php script is not cleaning log tables

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.

2 REPLIES

Re: CE1.9.2.1 - log.php script is not cleaning log tables

Hi

 

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.

 

Regards,

Andy

Problem solved? Click Accept as Solution!
www.iwebsolutions.co.uk | Magento Small Business Partner

Re: CE1.9.2.1 - log.php script is not cleaning log tables

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.

 

Melbourne | Australia - priyan.d@webdesignace.com.au
My Magento 1x Shop