coppermine-gallery.com/forum

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: Niecher on February 23, 2013, 11:40:52 AM

Title: Physical Memory Usage
Post by: Niecher on February 23, 2013, 11:40:52 AM
I have two questions:


thank you very much

Original Post (http://forum.coppermine-gallery.net/index.php/topic,75987.msg366648.html#msg366648)
Title: Re: Physical Memory Usage
Post by: phill104 on February 23, 2013, 03:26:27 PM
Not quite sure what you mean by "How much memory" as that depends on so many things it is hard to quantify. Different server setups use different amounts to run the same application then you have so many other variables to take into account. Even 2 images of the same dimensions can use different memory amounts to process. If this question is about hosting then some hosts (Such as Bytemark who kindly host this site for us - http://www.bytemark.co.uk/) sell their virtual server packages based on memory per customer and 256kb is all that is needed for a low traffic VPS running 4 CPG installs on 4 domains.

Your second question that is better answered by Google as is is not a simple answer.

As you speak Spanish and English so well we have had a request from a user to place a sticky on the Spanish forums advising Spanish visitors that we currently have no moderator and that if they do not get a response to post in the English or German forums. It would be fantastic if you could write something simple up for us that we could add as a stick. Sadly our old moderator, Fabri, has not visited for a very long time.
Title: Re: Physical Memory Usage
Post by: Niecher on February 23, 2013, 05:48:18 PM
I found this on google:

"If we need transactions, foreign keys and locks, we have to choose InnoDB. Instead, we choose MyISAM in those cases in which predominate SELECT queries to database."

"MySQL InnoDB gives a transactional storage engine (ACID compliant) capabilities commit (confirmation), rollback (cancellation) and failover. InnoDB does locking on row level and also provides functions consistent non-locking read Oracle style in SELECT statements. These features increase performance and the ability to manage multiple simultaneous users. No need for lock escalation in InnoDB because row level locks take up very little space. InnoDB also supports FOREIGN KEY constraints. in SQL Query even within the same query can freely mix InnoDB type tables with other tables. "

I can choose the storage engine in my database, then what is the best option for coppermine gallery?

Quote from: Phill Luckhurst on February 23, 2013, 03:26:27 PM
As you speak Spanish and English so well we have had a request from a user to place a sticky on the Spanish forums advising Spanish visitors that we currently have no moderator and that if they do not get a response to post in the English or German forums. It would be fantastic if you could write something simple up for us that we could add as a stick. Sadly our old moderator, Fabri, has not visited for a very long time.

I actually use the English translator of google.

But yes, I can write a sticky in Spanish. I'll open a thread in the Spanish forum and you turn that into a sticky thread.

Title: Re: Physical Memory Usage
Post by: Niecher on February 23, 2013, 07:05:27 PM
I made the post, but edit the title by mistake I put copperpine.  ::)

http://forum.coppermine-gallery.net/index.php/topic,76032.0.html
Title: Re: Physical Memory Usage
Post by: ΑndrĂ© on February 23, 2013, 07:32:03 PM
Quote from: Niecher on February 23, 2013, 07:05:27 PM
I made the post, but edit the title by mistake I put copperpine.  ::)

http://forum.coppermine-gallery.net/index.php/topic,76032.0.html
Corrected typo, set sticky. Thank you!


Regarding the MySQL engine, as far as I know Coppermine doesn't use any InnoDB specific commands, so I don't know if there's a benefit if you use it instead of MyISAM.
Title: Re: Physical Memory Usage
Post by: Niecher on February 23, 2013, 08:11:08 PM
Thank you André.

I asked this question about the storage engine of the database, because when I installed coppermine gallery some time ago the storage engine of the database was the default MyISAM and all the tables were created in this type.

Lately on my server, they are making many changes and one of them is the default storage engine is now InnoDB.

For example if I do a fresh install of coppermine now, in a new database, all tables are created InnoDB.

Then I thought that perhaps this difference could be important.
Title: Re: Physical Memory Usage
Post by: phill104 on February 23, 2013, 09:00:21 PM
Many thanks for your Spanish message, that is a great help.

As for the change I would not worry about it. We have seen many sites with the hosts running both. As long ad the host set things up well it is unlikely you will notice any difference.