ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Apache processes using a lot of CPU time

February 13, 2009 1:05pm

Subscribe [3]
  • #1 / Feb 13, 2009 1:05pm

    berkeley

    32 posts

    We launched our new site this week - getting around 1000 visitors a day. Our sysadmin has pointed out that the server is highly loaded at the moment. The apache processes seem to be using a lot of CPU time and more RAM than he would expect it to be using. Is there any guidance you can point us to on server settings, etc? We use quite a few “if” statements for related entries, but do not have many templates and around 200 entries. We are running 1.6.5 Build:  20081031 (upgrading imminently!) Any help you can give would be most gratefully received. Thanks in advance

  • #2 / Feb 13, 2009 4:20pm

    Sue Crocker

    26054 posts

    Hi, berkeley.

    We use quite a few “if” statements for related entries, but do not have many templates and around 200 entries. We are running 1.6.5 Build:  20081031 (upgrading imminently!) Any help you can give would be most gratefully received. Thanks in advance

    How many are quite a few?

    We do have a few articles you could look at:

    EEWiki:// Reduce Queries

    EEWiki:// Optimize EE

    The problem could very well be your template. You could create a new template with no EE tags, just some static Hello World content, and see what that template does to the server.

  • #3 / Feb 16, 2009 8:39am

    berkeley

    32 posts

    Hi Sue

    Thanks for your swift reply and apologies for my delay in responding, time difference and weekend got in the way! Thanks for the links we will go through them and make some adjustments. In the meantime, below is an edited version of a template showing the EE code (most html and lots of divs removed), and this is a link to a live page:
    http://www.jiscdigitalmedia.ac.uk/stillimages/advice/copyright-and-digital-images/
    As you will see, the page itself loads quickly, but if you remove the last segment (so you are left with jiscdigitalmedia.ac.uk/stillimages/advice/ ) it takes a long time to resolve. We don’t expect many people to do this and jiscdigitalmedia.ac.uk/stillimages/advice/ is not a link we promote or want people to use, so have set up a redirect (shown below) to take them to the stillimages/index page if they do, but it still takes a long time to redirect and I was wondering if perhaps this was part of the problem. Would “enable strict URLs” help? Many thanks.

    {assign_variable:my_weblog="stillimages"}
    {assign_variable:my_template_group="stillimages"}
    
    {if segment_2 == 'advice' AND segment_3 ==''}
    {redirect="{my_template_group}/index"}
    {/if}
    ....
    {embed="includes/.simplesearchform"}
    ....
    <div id="breadCrumb">{exp:weblog:entries rdf="off" limit="1"
    disable="categories|custom_fields|member_data|pagination|trackbacks"}{exp:char_limit
     total="160"}You are here: <a href="http://{homepage}">Home</a> > <a href="http://{path=stillimages/index}">Still images</a> > {title}{/exp:char_limit}
    {/exp:weblog:entries}</div>
    ....
    {exp:weblog:entries weblog="{my_weblog}"}
    <h1>{title}</h1>
    Published in: {categories weblog="{my_weblog}" show_group="3" show_empty="no" backspace="2" style="linear"}
    <a href="http://{path={my_template_group}/docs}">{category_name}</a> | 
    {/categories}
    
    Tags: {categories weblog="{my_weblog}" show_group="4" show_empty="no" backspace="2" 
    <a href="http://{path=tags}">{category_name}</a> | 
    {/categories}
    
    <h3>Summary</h3>
    <p>{summary}<br />
    {body}<br />
    {if extended}{extended}{/if}<br />
    ....<br />
    {exp:weblog:entries weblog="stillimages"}<br />
    {lg_social_bookmarks title="{title}" permalink="{path=stillimages/advice/{url_title}}"}<br />
    <ul class="bookmarks"><br />
    {social_sites}<br />
    <li><br />
    <a href="http://{social_site_url}" title="Bookmark on: {social_site_name}">_/themes/cp_global_images/lg_social_bookmarks/favicons/{social_site_img_url}_<span>Bookmark on {social_site_name}</span>_</a><br />
    </li><br />
    {/social_sites}<br />
    </ul><br />
    {/lg_social_bookmarks}<br />
    {/exp:weblog:entries}<br />
    ....<br />
    {if relatedstillimages1}</p><h3>Related still images advice</h3>
    <p><ul class="relatedList"><br />
    {/if}<br />
    {related_entries id="relatedstillimages1"}<br />
    {if status != "closed"}<br />
    <li><a href="http://{title_permalink=">{title}</a></li><br />
    {/if}<br />
    {/related_entries}<br />
    {related_entries id="relatedstillimages2"}<br />
    {if status != "closed"}<br />
    <li><a href="http://{title_permalink=">{title}</a></li><br />
    {/if}<br />
    {/related_entries}<br />
    {related_entries id="relatedstillimages3"}<br />
    {if status != "closed"}<br />
    <li><a href="http://{title_permalink=">{title}</a></li><br />
    {/if}<br />
    {/related_entries}<br />
    {if relatedstillimages1}<br />
    </ul><br />
    {/if}</p>
    
    <p>{if relatedmovingimages1}</p><h3>Related moving images advice</h3>
    <p><ul class="relatedList"><br />
    {/if}<br />
    {related_entries id="relatedmovingimages1"}<br />
    {if status != "closed"}<br />
    <li><a href="http://{title_permalink=">{title}</a></li><br />
    {/if}<br />
    {/related_entries}<br />
    {related_entries id="relatedmovingimages2"}<br />
    {if status != "closed"}<br />
    <li><a href="http://{title_permalink=">{title}</a></li><br />
    {/if}<br />
    {/related_entries}<br />
    {related_entries id="relatedmovingimages3"}<br />
    {if status != "closed"}<br />
    <li><a href="http://{title_permalink=">{title}</a></li><br />
    {/if}<br />
    {/related_entries}<br />
    {if relatedmovingimages1}<br />
    </ul><br />
    {/if}</p>
    
    <p>{if relatedaudio1}</p><h3>Related audio advice</h3>
    <p><ul class="relatedList"><br />
    {/if}<br />
    {related_entries id="relatedaudio1"}<br />
    {if status != "closed"}<br />
    <li><a href="http://{title_permalink=">{title}</a></li><br />
    {/if}<br />
    {/related_entries}<br />
    {related_entries id="relatedaudio2"}<br />
    {if status != "closed"}<br />
    <li><a href="http://{title_permalink=">{title}</a></li><br />
    {/if}<br />
    {/related_entries}<br />
    {related_entries id="relatedaudio3"}<br />
    {if status != "closed"}<br />
    <li><a href="http://{title_permalink=">{title}</a></li><br />
    {/if}<br />
    {/related_entries}<br />
    {if relatedaudio1}<br />
    </ul><br />
    {/if}</p>
    
    <p>{if relatedcrossmedia1}</p><h3>Related cross-media advice</h3>
    <p><ul class="relatedList"><br />
    {/if}<br />
    {related_entries id="relatedcrossmedia1"}<br />
    {if status != "closed"}<br />
    <li><a href="http://{title_permalink=">{title}</a></li><br />
    {/if}<br />
    {/related_entries}<br />
    {related_entries id="relatedcrossmedia2"}<br />
    {if status != "closed"}<br />
    <li><a href="http://{title_permalink=">{title}</a></li><br />
    {/if}<br />
    {/related_entries}<br />
    {related_entries id="relatedcrossmedia3"}<br />
    {if status != "closed"}<br />
    <li><a href="http://{title_permalink=">{title}</a></li><br />
    {/if}<br />
    {/related_entries}<br />
    {if relatedcrossmedia1}<br />
    </ul><br />
    {/if}</p>
    
    <p>{if relatedtraining1}</p><h3>Related training courses</h3>
    <p><ul id="trainingList"><br />
    {/if}<br />
    {related_entries id="relatedtraining1"}<br />
    {if status != "closed"}<br />
    <li><a href="http://{title_permalink=">{title}</a> <span>{coursedate format="%d %F %Y"}</span></li><br />
    {/if}<br />
    {/related_entries}<br />
    {related_entries id="relatedtraining2"}<br />
    {if status != "closed"}<br />
    <li><a href="http://{title_permalink=">{title}</a> <span>{coursedate format="%d %F %Y"}</span></li><br />
    {/if}<br />
    {/related_entries}<br />
    {related_entries id="relatedtraining3"}<br />
    {if status != "closed"}<br />
    <li><a href="http://{title_permalink=">{title}</a> <span>{coursedate format="%d %F %Y"}</span></li><br />
    {/if}<br />
    {/related_entries}<br />
    {if relatedtraining1}<br />
    </ul><br />
    {/if}<br />
    {/exp:weblog:entries}

  • #4 / Feb 16, 2009 1:00pm

    Sue Crocker

    26054 posts

    I’d use if no_results instead.

    Something like this:

    {exp:weblog:entries weblog="{my_weblog}" url_title="{segment_3}"}
    {if no_results}
    your redirect code
    {/if}
    ....
    {/exp:weblog:entries}
.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases