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?
Disable the feature in config if you don't want it.
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
You can empty the hit stats table using phpmyadmin.
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 :)
It's fine, but make a backup first if you are not confident in using phpmyadmin.
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