Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: MySQL 4 vs MySQL 5  (Read 5175 times)

0 Members and 1 Guest are viewing this topic.

Forgott3n

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 13
  • Coppermine User
    • C3Studios
MySQL 4 vs MySQL 5
« on: July 27, 2008, 05: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

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: MySQL 4 vs MySQL 5
« Reply #1 on: July 27, 2008, 09:03:40 am »

How large is the performance loss for Coppermine to use MySQL 5 over MySQL 4?
Unknown.
What are the suggested changes to the my.cnf file to ensure the fastest page loads?
There are no suggested changes from our side.
We're running rather slowly.
Posting a link to your gallery might help more than posting the server hardware details.

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

Forgott3n

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 13
  • Coppermine User
    • C3Studios
Re: MySQL 4 vs MySQL 5
« Reply #2 on: July 27, 2008, 06: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

  • Guest
Re: MySQL 4 vs MySQL 5
« Reply #3 on: July 27, 2008, 06:12:58 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

Forgott3n

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 13
  • Coppermine User
    • C3Studios
Re: MySQL 4 vs MySQL 5
« Reply #4 on: July 28, 2008, 03: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

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 13
  • Coppermine User
    • C3Studios
Re: MySQL 4 vs MySQL 5
« Reply #5 on: July 28, 2008, 03: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

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: MySQL 4 vs MySQL 5
« Reply #6 on: July 28, 2008, 06:14:50 am »

Turn random thumbs off - they have the most severe impact on resources consumption
Logged
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 20 queries.