[Solved]: Database size

[Picho]

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/) 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

[Nibbler]

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.

[Picho]

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

Thanks

-Paul-