MySQL DB growing to fast MySQL DB growing to fast
 

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

Main Menu

MySQL DB growing to fast

Started by blablabla, January 10, 2006, 04:03:18 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

blablabla

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  :'(

Joachim Müller

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.

blablabla

#2
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 ?


Abbas Ali

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.
Chief Geek at Ranium Systems

blablabla

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

Joachim Müller

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.

blablabla