User title: Psi Webmaster
Member since Jul 2004 ·
157 posts · Location: Atlanta, Georgia, USA
Group memberships: Members
Subject: Database performance
As Yves knows (as he frequents my board), the Psi Forum performance is horrible since its been moved to a new server. The new server is faster, and in fact all other parts of the Psi website, including those which use a database, run an order of magnitude faster. Except for the forum which can sometimes take upwards of 5, 10, more seconds to build the page. Sometimes it will timeout. This seems to be sporadic, right now I'm getting 2.7-4s page load time, which is ok. (A "light" db page outside of the Forum can load in under a second easy).
Can anyone point me to PHP, mySQL or Apache tuning information which might apply to my issue? I know that UNB really thrashes the database (50 queries to generate a page sometimes), so that is probably the choke point. But as I said, my other db apps run fine. I don't know what might be different about UNB, aside from the heavy usage. But even as heavy as it is, something else is going on.
System:
3Ghz Intel 1GB RAM (neither approaching full load)
CentOS 4.3
Kernel: 2.6.9-22.EL
Apache 1.3.36
PHP 4.4.2
mySQL 4.1.19