Collin Moore Posted August 1, 2015 Share Posted August 1, 2015 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.42MySQL version: 5.5.5-10.0.20-MariaDB Link to comment Share on other sites More sharing options...
Crystal V Posted August 1, 2015 Share Posted August 1, 2015 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. Link to comment Share on other sites More sharing options...
paulcallender@talk21.com Posted August 1, 2015 Share Posted August 1, 2015 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. Link to comment Share on other sites More sharing options...
Adlago Posted August 1, 2015 Share Posted August 1, 2015 If you share your forum link may have an idea. Link to comment Share on other sites More sharing options...
Collin Moore Posted August 2, 2015 Author Share Posted August 2, 2015 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. Link to comment Share on other sites More sharing options...
Rhett Posted August 2, 2015 Share Posted August 2, 2015 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.