Forums / Setup & design / Disable session storing for anonymous access (crawler issues)

Disable session storing for anonymous access (crawler issues)

« 
Previous topic
|
Setup & design
|
Next topic
 »
Author Message

Benjamin Lorteau

Tuesday 01 February 2011 5:29:19 am

Hello,

I'm running a pretty big site with eZ Publish, and my session table is constantly clogged with anonymous sessions. Thoses sessions are created by the different crawler that access site pages. I have about 150 active session of crawler, and many more inactive but stored until deletion.

Is there a way to delete anonymous session faster, or is there a way to identify search engine crawlers ?

Thanks in advance !

Solution : Upgrade to 4.4 with file based session management. Thanks Guillaume and André !

eZ Publish personal project : http://www.aeriesguard.com [fr]

Guillaume Kulakowski

Tuesday 01 February 2011 8:26:44 am

What is your eZ Publish version ?

In eZP 4.4 you can choose to store session in file system and anonymous doesn't create any session.

Other solution:

My blog : http://www.llaumgui.com (not in eZ Publish ;-))
eZC on RHEL : http://blog.famillecollet.com/pages/Config-en
eZC on Fedora : just "yum install php-channel-ezc"

Benjamin Lorteau

Tuesday 01 February 2011 9:30:10 am

I'm still running the 4.3 version.

I already thought of reducing the SessionTimeout, but I don't want to reduce real user agreement for the sake of one big MySQL table ;)

Anyway, thanks for the tips !

eZ Publish personal project : http://www.aeriesguard.com [fr]

André R.

Wednesday 02 February 2011 1:42:10 am

4.4 should be a good boost to your setup, by default it will switch to file based session handler, so if you're on some kind of cluster setup you'll need to make it use db session handler preferably before you upgrade (so it uses when the new code starts to run).

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Benjamin Lorteau

Wednesday 02 February 2011 2:16:42 am

Hello André,

thanks for your reply, unfortunately I didn't manage to upgrade cleanly, after the upgrade I had got some pretty big SQL errors about non-existent field (even with SQL upgrade done) so I reverted to 4.3.

I'm not in cluster mode so file based session should be just fine for my setup. I will give another shot at the upgrade but for now I can't afford to pass too many time on it.

eZ Publish personal project : http://www.aeriesguard.com [fr]

Guillaume Kulakowski

Wednesday 02 February 2011 2:23:45 am

"

In eZP 4.4 you can choose to store session in file system and anonymous doesn't create any session.

"

The link: https://github.com/ezsystems/ezpublish/blob/master/doc/bc/4.4/changes-4.4.0.txt#L26

My blog : http://www.llaumgui.com (not in eZ Publish ;-))
eZC on RHEL : http://blog.famillecollet.com/pages/Config-en
eZC on Fedora : just "yum install php-channel-ezc"

Benjamin Lorteau

Monday 21 March 2011 5:48:49 am

I recently upgraded in 4.4 (with some problems though), so there's no longer a problem for me. Thanks for the tips !

eZ Publish personal project : http://www.aeriesguard.com [fr]

eZ debug

Timing: Jan 17 2025 21:40:09
Script start
Timing: Jan 17 2025 21:40:09
Module start 'content'
Timing: Jan 17 2025 21:40:10
Module end 'content'
Timing: Jan 17 2025 21:40:10
Script end

Main resources:

Total runtime0.8720 sec
Peak memory usage4,096.0000 KB
Database Queries209

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0065 587.9766180.8047
Module start 'content' 0.00650.7455 768.7813643.7734
Module end 'content' 0.75200.1200 1,412.5547341.0547
Script end 0.8720  1,753.6094 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00440.4997210.0002
Check MTime0.00140.1620210.0001
Mysql Total
Database connection0.00120.138110.0012
Mysqli_queries0.778989.31592090.0037
Looping result0.00250.29032070.0000
Template Total0.844696.920.4223
Template load0.00330.378620.0017
Template processing0.841396.475020.4207
Template load and register function0.00010.013410.0001
states
state_id_array0.00140.158410.0014
state_identifier_array0.00110.121120.0005
Override
Cache load0.00280.3167430.0001
Sytem overhead
Fetch class attribute can translate value0.00200.230440.0005
Fetch class attribute name0.00140.1566100.0001
XML
Image XML parsing0.00210.242140.0005
class_abstraction
Instantiating content class attribute0.00000.0040140.0000
General
dbfile0.00210.2461410.0001
String conversion0.00000.000530.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
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
7content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
7content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
10content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
3content/datatype/view/ezxmltags/strong.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/strong.tplEdit templateOverride template
2content/datatype/view/ezxmltags/link.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/link.tplEdit templateOverride template
2content/datatype/view/ezxmltags/li.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/li.tplEdit templateOverride template
1content/datatype/view/ezxmltags/ul.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/ul.tplEdit templateOverride template
1content/datatype/view/ezxmltags/quote.tpldatatype/ezxmltext/quote.tplextension/ezwebin/design/ezwebin/override/templates/datatype/ezxmltext/quote.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 35
 Number of unique templates used: 10

Time used to render debug report: 0.0002 secs