Ubuntu 10.10 64 bit VPS, 512Mb dedicated RAM. Mysql tuned so that sqltuner is completely happy. Even when I run one of those "hammer the server" load apps, used RAM never above 350Mb out of the 493 available. Load never exceeds 1.04 or so.
httpd.conf tuned as per all the guides for vps of that memory - amount of preforks, spares etc.
But for the FIRST load of Zen Cart, 1.39h, even a stock install, after having not visited for a while, it's taking ages.
First load examples:
Parse Time: 3.576 - Number of Queries: 50 - Query Time: 0.019723195953369
Parse Time: 6.645 - Number of Queries: 50 - Query Time: 0.02912563696289
Reload examples:
Parse Time: 0.096 - Number of Queries: 39 - Query Time: 0.0066126374511719
Parse Time: 0.163 - Number of Queries: 39 - Query Time: 0.0075072061309816
Subsequent reloads will be at this speed.
So, the mysql query speed is VERY fast, the subsequent page loads are fast. DNS lookup is off, IP to host conversion is off, I've been through all the guides and turned everything off, tweaked all the switches, tried different caching methods.
Bear in mind the server is tuned percetly, and Zen Cart is the ONLY application doing this. I installed a couple of PHP apps like phpbb and phpmyadmin, they run fine and don't exhibit this behaviour. But 3-6 seconds for initial page load is 2-5 seconds too long for most potential visitors.
I'm using suPHP but I've tried fast-cgi and cgi.
Stuck now, a weekend of tweaking has brought me nothing. Advice appreciated. Thanks.
Bookmarks