forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: tcr1016 on April 19, 2008, 04:02:55 am

Title: HELP!! MYSQL Database Question??
Post by: tcr1016 on April 19, 2008, 04:02:55 am

I am installing oppermine and need to know if it uses alot of MYSQL space? My web host only allows 100mb of MYSQL space. Does the gallery store data in the MYSQL or just in the total webspace?? My webspace is 400G. Do I need more MYSQL or is 100mb more than enough? Where is all the users, pics, and thumbnails stored??

Thank you for your help.

Title: Re: HELP!! MYSQL Database Question??
Post by: tfischer on April 19, 2008, 05:45:02 am

Pics (including thumbnails) are stored in your webspace (albums folder).  Pretty much everything else is stored in the database.  But you'd have to have a pretty huge gallery with large captions on each picture to begin to eat up that space...

-Tim

Title: Re: HELP!! MYSQL Database Question??
Post by: Joachim Müller on April 19, 2008, 12:50:11 pm

Let me give you an example of the mySQL resources consumption: on my personal gallery with 13636 files in 318 albums and 31 categories with 308 comments viewed 557889 times the mySQL tables take up 76 MB. Coppermine stores the files you upload on the webspace. Only the path to the file is stored in the database, which are only a few bytes per record. However, the setup your webhost provides is ridiculous: 400 GB of webspace is a huge number that doesn't work well with such a small sized mySQL database.