Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: [Solved]: Database size  (Read 1711 times)

0 Members and 1 Guest are viewing this topic.

Picho

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 3
    • Digipaul.com photo gallery
[Solved]: Database size
« 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/) 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
« Last Edit: May 07, 2008, 10:06:04 am by Nibbler »
Logged

Nibbler

  • Guest
Re: Database size
« Reply #1 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.
Logged

Picho

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 3
    • Digipaul.com photo gallery
Re: Database size
« Reply #2 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-
Logged
Pages: [1]   Go Up
 

Page created in 0.015 seconds with 21 queries.