[Solved]: Database size [Solved]: Database size
 

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]

Main Menu

[Solved]: Database size

Started by Picho, May 06, 2008, 09:34:03 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

Picho

May 06, 2008, 09:34:03 PM Last Edit: May 07, 2008, 10:06:04 AM by Nibbler
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

#1
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.

Picho

#2
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-
Print
Go Up Pages1
User actions