Serious Performance Issues

[Collin Moore]

Currently running 4.0.9 with a dedicated server for both the web application (4 core/7 GB) and database (2 core/7GB/SSD). Both are located in the same colo, but we are experiencing page load times from 9 to 25 seconds. Even had times where hitting 90 seconds.

We have tried clearing the cache. Optimize the database to the best our our abilities. We have increased both the web app and db resources with no visible results. Outside of just restarting both the app and db (which only helps for a short time), nothing seems to improve the speed.

Any ideas or suggestions on what to do?

Other data:

• php version: 5.4.42
• MySQL version: 5.5.5-10.0.20-MariaDB

[Crystal V]

4.0.10 was supposed to have several performance fixes. We're now on 4.0.11 with 4.0.12 coming out soon-ish.

[paulcallender@talk21.com]

Its easy to blame the software but page loads regularly 9-25 secs sounds like the server has run out of a resource, probably "sitting on the disk" either because there's a problem with the disk drive or another process has runaway on memory and everything's paging in and out disk-memory. Do you have any performance monitoring tools on the server? Munin service monitor is good; Nodequery does the basics.

Do you have Telnet-SSH access? If so, simply running the command top may give some insight.

The other possibility is massive database corruption but if it reboots and runs fine for a bit, makes this unlikely. Worth a check though.

And the other possibility is a PHP Injection attack and your server is unknowingly sending millions of spam emails out or something.....but ironically it doesn't have a massive performance hit of its own, this one.

[Adlago]

If you share your forum link may have an idea.

[Collin Moore]

Its easy to blame the software but page loads regularly 9-25 secs sounds like the server has run out of a resource, probably "sitting on the disk" either because there's a problem with the disk drive or another process has runaway on memory and everything's paging in and out disk-memory. Do you have any performance monitoring tools on the server? Munin service monitor is good; Nodequery does the basics.

Performance monitoring on both servers. The DB rarely ever goes above 2% CPU usage and pretty steady at 800 MB (11%). Performance on the app server is very similar, nothing above 10% on memory or CPU. We did have an issue when the app server ran out of allocated hard drive space, but we resolved that quickly.

[Rhett]

If you are running a separate DB server, ensure you are using an internal high speed link between the servers for the DB connection

 

The first thing to do however is upgrade to 4.0.11, there are many performance bugs fixed in 4.0.11 from what you are running now.