Forums / Developer / (offset) in navigation link put Apache to 100% CPU load

(offset) in navigation link put Apache to 100% CPU load

Author Message

Alessandro Dellanna

Wednesday 22 December 2010 3:11:22 pm

Hi all, can anyone help me about this:

I have a Blog with several blog post (about 10.000). The full-blog template use the google.tpl template for build navigation paging at the end of the list.

When I click on the navigation link the Apache process go to 100% CPU load (mysql work normally and there isn't any query in execution) and then 240 sec Apache send a timeout. If I try clicking two or three times then the link works correctly.... ghosts,ghosts, on my server .... heeelll....p!

The problem seem to be the (offset) keyword in the link .... but in the search function of ez the (offset) work perfectly.

Here is the code of the navigation template

{include name=navigator
                     uri='design:navigator/google.tpl'
                     page_uri=concat('/content/view','/full/',$node.node_id)
                     item_count=$blogs_count
                     view_parameters=$view_parameters
                     item_limit=$page_limit}

eZ debug

Timing: Jan 29 2025 13:35:05
Script start
Timing: Jan 29 2025 13:35:05
Module start 'content'
Timing: Jan 29 2025 13:35:05
Module end 'content'
Timing: Jan 29 2025 13:35:05
Script end

Main resources:

Total runtime0.2652 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0080 588.0781180.8203
Module start 'content' 0.00800.0048 768.898493.9766
Module end 'content' 0.01270.2524 862.8750522.8594
Script end 0.2651  1,385.7344 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00341.2957200.0002
Check MTime0.00130.4930200.0001
Mysql Total
Database connection0.00070.268910.0007
Mysqli_queries0.214080.66631410.0015
Looping result0.00130.47161390.0000
Template Total0.251995.010.2519
Template load0.00100.377810.0010
Template processing0.250994.596910.2509
Override
Cache load0.00060.234210.0006
Sytem overhead
Fetch class attribute can translate value0.00090.355910.0009
XML
Image XML parsing0.00050.195010.0005
General
dbfile0.00331.2558200.0002
String conversion0.00000.002630.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs