Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: [Solved]: Database size  (Read 2011 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.018 seconds with 19 queries.