(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}

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 18 2025 03:12:09
Script start
Timing: Jan 18 2025 03:12:09
Module start 'layout'
Timing: Jan 18 2025 03:12:09
Module start 'content'
Timing: Jan 18 2025 03:12:09
Module end 'content'
Timing: Jan 18 2025 03:12:09
Script end

Main resources:

Total runtime0.0168 sec
Peak memory usage4,096.0000 KB
Database Queries3

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0051 589.1797152.6406
Module start 'layout' 0.00510.0044 741.820339.4844
Module start 'content' 0.00950.0051 781.304789.4141
Module end 'content' 0.01460.0022 870.718830.2891
Script end 0.0168  901.0078 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.002514.8371140.0002
Check MTime0.00116.7238140.0001
Mysql Total
Database connection0.00074.089210.0007
Mysqli_queries0.003621.419530.0012
Looping result0.00000.154210.0000
Template Total0.001810.910.0018
Template load0.00106.095610.0010
Template processing0.00084.748610.0008
Override
Cache load0.00074.427410.0007
General
dbfile0.00031.494280.0000
String conversion0.00000.050940.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

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

Time used to render debug report: 0.0002 secs