forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: VIPguard on December 17, 2008, 09:16:38 am

Title: My database is over quota...?
Post by: VIPguard on December 17, 2008, 09:16:38 am
Hi!

I have a little big problem, my database is over quota (149mg / 100mg) this cause a fatal error. My server provider can not lift my quota. What can I do to resolve that????

Thank's!!!!!
Title: Re: My database is over quota...?
Post by: Hein Traag on December 17, 2008, 09:53:53 am
Post a link to your cpg site. Also, which host are you with?
Title: Re: My database is over quota...?
Post by: VIPguard on December 17, 2008, 09:58:29 am
this is the link: http://www.vipguard.net/galeries/index.php
and I'm host by 1and1.com
Title: Re: My database is over quota...?
Post by: Hein Traag on December 17, 2008, 10:35:02 am
It shows a Fatal Error when i go to that address.
Title: Re: My database is over quota...?
Post by: VIPguard on December 17, 2008, 10:43:21 am
Yes this is my problem!
Title: Re: My database is over quota...?
Post by: François Keller on December 17, 2008, 11:31:29 am
wich tables are the bigest in your database ?
Title: Re: My database is over quota...?
Post by: VIPguard on December 17, 2008, 11:35:57 am
Coppermine
Title: Re: My database is over quota...?
Post by: Hein Traag on December 17, 2008, 11:42:04 am
Which tables of coppermine are the biggest..
Title: Re: My database is over quota...?
Post by: VIPguard on December 17, 2008, 11:44:17 am
it not only use one?
if not how can I identify?
Title: Re: My database is over quota...?
Post by: François Keller on December 17, 2008, 11:51:26 am
you must use a tool like phpmyadmin to see all tables used by coppermine in your database (they are 21 tables in a "normal" coppermine install)
Title: Re: My database is over quota...?
Post by: VIPguard on December 17, 2008, 12:19:30 pm
Table: cpg133_exif              Total 116 564 Ko
Table: cpg133_hit_stats       Total 32 043 Ko

The others are more small....
Title: Re: My database is over quota...?
Post by: Nibbler on December 17, 2008, 12:29:36 pm
You can empty the exif table and disable exif in config and you can empty the hit stats table and disable hit stats in config.
Title: Re: My database is over quota...?
Post by: VIPguard on December 17, 2008, 05:35:57 pm
What is the use of this two?
Title: Re: My database is over quota...?
Post by: Nibbler on December 17, 2008, 05:46:52 pm
http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#admin_logging_hitdetails
http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#admin_picture_thumb_advanced_exif
Title: Re: My database is over quota...?
Post by: VIPguard on December 17, 2008, 06:36:06 pm
Ok the exif is all information on a picture and the hit I suppose it's the number of hit each picture...

You are sure I can empty a db without problem... I don't know db... and I don't want lost all...

Do you have an other solution for my problem if I don't want to clear this db?
Title: Re: My database is over quota...?
Post by: Nibbler on December 17, 2008, 06:40:01 pm
Nobody is telling you to empty the db. You should empty just those two tables as suggested. If you don't know what you're doing make a backup first or ask your host to help you.
Title: Re: My database is over quota...?
Post by: VIPguard on December 17, 2008, 06:44:17 pm
Yes I understand, s'cuse my english is not very well...

But else to empty those 2 tables, other solution are possible or not? Like use 2 bd?
Title: Re: My database is over quota...?
Post by: Fabricio Ferrero on December 17, 2008, 07:54:32 pm
Quote
Like use 2 bd?
No, do as suggested ;)
Title: Re: My database is over quota...?
Post by: phill104 on December 17, 2008, 08:21:04 pm
Something sounds odd here to me. 1&1 provide 100MB of space for DB's and you have supposedly used 149MB. Deleting 116 564 Ko + 32 043 Ko is not going to equate to 49MB.

Given that you have 116k of exim data and assuming that every pic has exim data then you probably have around 1500 pics on your install?

Surely nowhere near enough to fill a 100MB database?

Title: Re: My database is over quota...?
Post by: VIPguard on December 17, 2008, 10:20:04 pm
22 174 lines in exif table
Title: Re: My database is over quota...?
Post by: Joachim Müller on December 20, 2008, 11:16:59 am
The show stopper probably is the stats table. You shouldn't have enabled stats recording in the first place if you have no idea on the impact. You should have emptied the stats on a scheduled basis. Ranting about the size of the exif table is invalid as well.

Now stop whining and do as suggested:

This thread looks like a parody of the bad joke of the type "Help, doctor: whenever I hit myself on the head with a baseball bat it hurts so badly". You know what the doctor will reply: "well, then don't hit yourself in the first place". :D