MySQL 4 vs MySQL 5

[Forgott3n]

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

[Joachim Müller]

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.

[Forgott3n]

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/

[Nibbler]

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.

[Forgott3n]

I implore you to take another look at the link, we had a bit of downtime today and the gallery is now loading.

[Forgott3n]

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

[Joachim Müller]

Turn random thumbs off - they have the most severe impact on resources consumption