forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: blablabla on January 10, 2006, 04:03:18 pm

Title: MySQL DB growing to fast
Post by: blablabla 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  :'(
Title: Re: MySQL DB growing to fast
Post by: Joachim Müller 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.
Title: Re: MySQL DB growing to fast
Post by: blablabla 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 ?

Title: Re: MySQL DB growing to fast
Post by: Abbas Ali 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.
Title: Re: MySQL DB growing to fast
Post by: blablabla on January 10, 2006, 08:39:56 pm
I did that, is it safe to delete that table now ?
Title: Re: MySQL DB growing to fast
Post by: Joachim Müller 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.
Title: Re: MySQL DB growing to fast
Post by: blablabla on January 11, 2006, 10:25:15 am

it's working  :D