forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Hercules24 on April 17, 2006, 09:40:09 pm

Title: How to avoid Detailed Hit Stats?
Post by: Hercules24 on April 17, 2006, 09:40:09 pm: Since I've upgraded to 144 I try to make a back up each week.
However I see that 1 of the 20 tables (hit stats) is growing very fast (over 6MB in 1 week)
I do want each file to say how many time it's been viewed, but I don't need the viewers IP, referrer adress etc.
What do I need to do?
Title: Re: How to avoid Detailed Hit Stats?
Post by: Nibbler on April 17, 2006, 09:48:10 pm: Disable the feature in config if you don't want it.
Title: Re: How to avoid Detailed Hit Stats?
Post by: Hercules24 on April 17, 2006, 09:55:18 pm: By switching the last 2 of these lines 2 No CPG won't be recording anymore detailed info in MySQL memory?
And is there a way to delete the current detailed stats in the MySQL dbase without losing the normal view counter?

Logging mode *** Normal All Off ( View logs )
Log ecards Yes No
Keep detailed vote statistics Yes No
Keep detailed hit statistics Yes No
Title: Re: How to avoid Detailed Hit Stats?
Post by: Nibbler on April 17, 2006, 10:07:13 pm: You can empty the hit stats table using phpmyadmin.
Title: Re: How to avoid Detailed Hit Stats?
Post by: Hercules24 on April 17, 2006, 10:23:46 pm: I can see an "empty garbage can" in PHPMyAdmin in the table hit stats containing 45K records.
Deleting the content of this table won't affect the regular number of views showed with my pictures?
My normal counters are like children to me :)
Title: Re: How to avoid Detailed Hit Stats?
Post by: Nibbler on April 17, 2006, 10:36:13 pm: It's fine, but make a backup first if you are not confident in using phpmyadmin.
Title: Re: How to avoid Detailed Hit Stats?
Post by: Hercules24 on April 17, 2006, 10:44:09 pm: Nibbler
Thank you very much for helping my out here.
MySQL is cleaned up again and I still got my regular stats up.
Problem Solved