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: HELP!! MYSQL Database Question??  (Read 1621 times)

0 Members and 1 Guest are viewing this topic.

tcr1016

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
HELP!! MYSQL Database Question??
« 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.
Logged

tfischer

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 75
    • Fischersplace Photo Gallery
Re: HELP!! MYSQL Database Question??
« Reply #1 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
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: HELP!! MYSQL Database Question??
« Reply #2 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.023 seconds with 19 queries.