forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Picho on May 06, 2008, 09:34:03 pm

Title: [Solved]: Database size
Post by: Picho on May 06, 2008, 09:34:03 pm

Hi,

I don't know do I any problem but I am thinking that my mysql size is a quite big and I am wondering how I can compress or decrease it (if I can...).

My webpage's (http://www.digipaul.com/album/ (http://www.digipaul.com/album/)) statistics are:

5367 files in 136 albums and 15 categories with 1592 comments viewed 2997490 times

So there is not so many pics but database size is 167 MB  :-\

In config there are these settings:

Logging mode: normal
Log ecards: yes
Keep detailed vote statistics: no (i changed this last month from yes -> no)
Keep detailed hit statistics: no (i changed this last month from yes -> no)

So... is my database size abnormal or normal? and if it's abnormal, how i can compress (or something) it?

Regards

-Paul-

ps. Coppermine version is 1.4.18

Title: Re: Database size
Post by: Nibbler on May 06, 2008, 10:08:43 pm

Check on it using phpmyadmin. That will tell you what is using the space. If your hit_stats table is large you can simply empty it. If it's something else then post what. You can also run an 'optimize' on the tables while you are in phpmyadmin.

Title: Re: Database size
Post by: Picho on May 07, 2008, 01:18:04 am

It's now ok.. It was hit_stats table and I just empty it and optimized database (145 MB smaller database now  :) ).

Thanks

-Paul-