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: MySQL DB growing to fast  (Read 2884 times)

0 Members and 1 Guest are viewing this topic.

blablabla

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 35
MySQL DB growing to fast
« on: January 10, 2006, 04:03:18 pm »

I'm not sure what's going on lately. I have almost 13 000 pictures online and DB is starting to get bigger really fast. After adding 100-200 pictures in last few weeks, it changed from 10 MB to 15 MB. What could be the reason for this  :-\ I really don't know much about MySQL so I would really appreciate if anyone can help. I would like to have a gallery with over 25 000 pictures but if it continues to grow like this it can couse a lot of problems  :'(
« Last Edit: January 11, 2006, 11:08:58 am by GauGau »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: MySQL DB growing to fast
« Reply #1 on: January 10, 2006, 04:20:43 pm »

make sure you're not logging too much stuff - a blind guess is that the db isn't growing abnormally fast because of new pics, but because your logs explode due to a lot of traffic. Post a link to your site and a screenshot of your logging settings. A screenshot of the phpMyAdmin screen that shows the table sizes might help as well.
Logged

blablabla

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 35
Re: MySQL DB growing to fast
« Reply #2 on: January 10, 2006, 04:51:32 pm »

all settings are on, i guess that was the problem.
is it safe to delete that table in db after disableing logging or is there any other way to clean this ?

« Last Edit: January 10, 2006, 11:28:44 pm by GauGau »
Logged

Abbas Ali

  • Administrator
  • Coppermine addict
  • *****
  • Country: in
  • Offline Offline
  • Gender: Male
  • Posts: 2165
  • Spread the PHP Web
    • Ranium Systems
Re: MySQL DB growing to fast
« Reply #3 on: January 10, 2006, 06:27:35 pm »

The screen shot of phpmyadmin clearly shows that cpg132_hit_stats table is eating up 11.7MB space out of 15.5MB. So if hit stats doesn't mean much to you turn it off completely i.e. turn "Logging Mode" off.
Logged
Chief Geek at Ranium Systems

blablabla

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 35
Re: MySQL DB growing to fast
« Reply #4 on: January 10, 2006, 08:39:56 pm »

I did that, is it safe to delete that table now ?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: MySQL DB growing to fast
« Reply #5 on: January 10, 2006, 11:25:36 pm »

back it up first (create a dump both of structure and content), then empty it (instead of deleting it). If this fails, restore the backup.
Logged

blablabla

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 35
Re: MySQL DB growing to fast
« Reply #6 on: January 11, 2006, 10:25:15 am »


it's working  :D
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 20 queries.