Support Forum Project Downloads FAQ Documentation About Demo Tutorials Blog Plugins
July 04, 2009, 05:14:51 pm *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Maintenance release cpg1.4.25 - upgrade recommended
The Coppermine development team is releasing an update for Coppermine in order to fix an issue with http uploads that could occur in particular versions of PHP.The fix is not security-critical, so if your gallery is running fine with cpg1.4.23 or cpg1.4.24 you don't need to upgrade. If you are running an older version than cpg1.4.23, you must update to this latest version as soon as possible because of the security impact (the past few maintenance releases before cpg1.4.24 all were security-related).
[more]
   Home   Help Search Board rules Login Register  
forum.coppermine-gallery.net > Support > cpg1.4.x Support > cpg1.4 miscellaneous > Topic: MySQL 4 vs MySQL 5
Pages: [1]   Go Down
« previous next »
  Send this topic  |  Print  
Author Topic: MySQL 4 vs MySQL 5  (Read 912 times)
0 Members and 1 Guest are viewing this topic.
Forgott3n Topic starter
Coppermine newbie

Gender: Male
Posts: 13

Coppermine User


WWW
« on: July 27, 2008, 04:54:37 am »
Hello,

We've recently upgraded MySQL on a server from 4 to 5 to maximize on efficiency for vBulletin. How large is the performance loss for Coppermine to use MySQL 5 over MySQL 4? What are the suggested changes to the my.cnf file to ensure the fastest page loads? We're running rather slowly.

Also, does Coppermine support XCache or APC?

Server details below:

Processor: Dual Opteron 246
Memory: 4GB DDR Registered ECC
Hd1: 120GB 7200RPM SATA / 8MB Cache
Hd2: 120GB 7200RPM SATA / 8MB Cache
RemoteBackup: 50GB Remote Backup
OS: Linux - CentOS 4
ControlPanel: cPanel / Web Host Manager
(+Fantastico/XController)
Apache 2.2.9 (Unix)
PHP 5.2.6
MySQL 5.0.51a-community
Logged
Joachim Müller
Administrator
Coppermine addict
*****
Gender: Male
Germany Germany

Posts: 43469


aka "GauGau"


WWW
« Reply #1 on: July 27, 2008, 08:03:40 am »
Quote from: Forgott3n on July 27, 2008, 04:54:37 am
How large is the performance loss for Coppermine to use MySQL 5 over MySQL 4?
Unknown.
Quote from: Forgott3n on July 27, 2008, 04:54:37 am
What are the suggested changes to the my.cnf file to ensure the fastest page loads?
There are no suggested changes from our side.
Quote from: Forgott3n on July 27, 2008, 04:54:37 am
We're running rather slowly.
Posting a link to your gallery might help more than posting the server hardware details.

Quote from: Forgott3n on July 27, 2008, 04:54:37 am
Also, does Coppermine support XCache or APC?
Coppermine was not designed for the using with particular cache modules or similar. There is no query caching in coppermine. Simple answer is "no". I'm not even aware of the names you mentioned - in fact I'm just guessing that those are database query caches.
Logged
Don't contact me over PM or email unless I asked you to. Instead: post on the proper board. All unrequested messages will be ignored!
Forgott3n Topic starter
Coppermine newbie

Gender: Male
Posts: 13

Coppermine User


WWW
« Reply #2 on: July 27, 2008, 05:01:13 pm »
http://gallery.avrilbandaids.com

APC and XCache are modules you can load into Apache that will cache PHP and MySQL.

http://www.php.net/apc
http://xcache.lighttpd.net/
Logged
Nibbler
Dev Team member
Coppermine addict
****
Gender: Male
United Kingdom United Kingdom

Posts: 19030



WWW
« Reply #3 on: July 27, 2008, 05:12:58 pm »
Quote from: Forgott3n on July 27, 2008, 05:01:13 pm
APC and XCache are modules you can load into Apache that will cache PHP and MySQL.

They are PHP extensions and don't have anything to do with Apache or MySQL. Coppermine doesn't use them actively but will benefit from having the opcode cache enabled. Your site does not even load so I can't offer any specific advice, just check for previous discussions about performance. Make sure the MySQL query cache is enabled, it may have got disabled when you updated MySQL.
Logged
Deny everything.
Forgott3n Topic starter
Coppermine newbie

Gender: Male
Posts: 13

Coppermine User


WWW
« Reply #4 on: July 28, 2008, 02:26:13 am »
I implore you to take another look at the link, we had a bit of downtime today and the gallery is now loading.
Logged
Forgott3n Topic starter
Coppermine newbie

Gender: Male
Posts: 13

Coppermine User


WWW
« Reply #5 on: July 28, 2008, 02:38:22 am »
Sorry for the double-post, I couldn't spot an edit button.

I ran a pingdom load test:

http://tools.pingdom.com/fpt/?url=gallery.avrilbandaids.com&treeview=0&column=objectID&order=1&type=0&save=true
Logged
Joachim Müller
Administrator
Coppermine addict
*****
Gender: Male
Germany Germany

Posts: 43469


aka "GauGau"


WWW
« Reply #6 on: July 28, 2008, 05:14:50 am »
Turn random thumbs off - they have the most severe impact on resources consumption
Logged
Don't contact me over PM or email unless I asked you to. Instead: post on the proper board. All unrequested messages will be ignored!
Pages: [1]   Go Up
  Send this topic  |  Print  
forum.coppermine-gallery.net > Support > cpg1.4.x Support > cpg1.4 miscellaneous > Topic: MySQL 4 vs MySQL 5
 « previous next »
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.9 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!
Page created in 0.102 seconds with 20 queries.