|
Friday 09 January 2004 10:25:59 pm
I need help with just a little more performance tuning. My database is still small (just one product in the shop, still just testing), but the home page still takes 2-5 seconds to process:
Timing points:
Checkpoint Elapsed Rel. Elapsed Memory Rel. Memory
Module start 'content' 0.0000 sec 1.5819 sec 0.0000KB 0.0000KB
Module end 'content' 1.5819 sec 0.4871 sec 0.0000KB 0.0000KB
End 2.0690 sec 0.0000KB 0.0000KB
Total runtime: 2.0706 sec
Time accumulators:
Accumulator Elapsed Percent Count Average
Mysql Total
Mysql_queries 0.0081 sec 0.3128% 4 0.0020 sec
Looping result 0.0017 sec 0.0665% 3 0.0006 sec
ini_load
Load cache 0.0752 sec 2.8981% 7 0.0107 sec
Template Total 0.4768 sec 18.4% 1 0.4768 sec
Template load 0.0644 sec 2.4796% 1 0.0644 sec
Template processing 0.4098 sec 15.7848% 1 0.4098 sec
Template load and register function 0.0351 sec 1.3524% 2 0.0176 sec
override
Cache load 0.0544 sec 2.0946% 1 0.0544 sec
Total script time: 2.5961 sec I'm running ezpublish3.3-1, RedHat 9.0, apache 2.0.48, mysql 4.0.17, php 4.3.4 (memory_limit = 16M), and php accelerator 1.3.3r2 (phpa.shm_size - 16 made a big difference (.5 seconds saved in template processing) compared to the 15MB recommended on ez.no's documentation). The server is a 300Mhz Celeron with 264MB (that or thereabouts). Note that when I run ppa_cache_admin -mv as root, I get "No shm cache available with key 0x0c0deb00. The cache may not exist or you may have insufficient permissions to access it." I'm not convinced it's not running, though. Note also that the thing used to take 30-40 seconds. The fix? Reboot. I'm guessing the various attempts at installing postgresql, then mysql, plus a new apache meant I had multiple instances of some or all of those in memory, and the thing was thrashing. Now my vmstat shows no processes waiting and 99% of CPU time in idle, with 3564 pages of memory free. When I refresh a page, r becomes 1-2 for ~3 seconds, while CPU user time goes to 67-85% and system time to 11-19%, and cs goes to 167-285. I'm hoping to get a page to load in under 1 second, so I can have 2-5 connections at one time. Thank you for any suggestions.
Granite Horizon, Certified Developer of eZ Publish Web Solutions
Provider of the SaaS Solution Granite Horizon In The Cloud | http://granitehorizon.com/cloud
http://granitehorizon.com | +1 916 647 6350 | California USA | @granitegreg
Blog: http://granitehorizon.com/blog
|