Disable session storing for anonymous access (crawler issues)

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: Reduce SessionTimeout Launch session_gc 2 times per day 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 18 2025 00:04:05
Script start
Timing:	Jan 18 2025 00:04:05
Module start 'layout'
Timing:	Jan 18 2025 00:04:05
Module start 'content'
Timing:	Jan 18 2025 00:04:05
Module end 'content'
Timing:	Jan 18 2025 00:04:06
Script end

Main resources:

Total runtime	0.8733 sec
Peak memory usage	4,096.0000 KB
Database Queries	72

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0052	588.1719	152.6563
Module start 'layout'	0.0052	0.0040	740.8281	39.5156
Module start 'content'	0.0092	0.8616	780.3438	638.6641
Module end 'content'	0.8709	0.0024	1,419.0078	20.0938
Script end	0.8732		1,439.1016

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0038	0.4356	16	0.0002
Check MTime	0.0014	0.1567	16	0.0001
Mysql Total
Database connection	0.0006	0.0648	1	0.0006
Mysqli_queries	0.7994	91.5346	72	0.0111
Looping result	0.0007	0.0802	70	0.0000
Template Total	0.8409	96.3	2	0.4205
Template load	0.0021	0.2397	2	0.0010
Template processing	0.8388	96.0537	2	0.4194
Template load and register function	0.0001	0.0124	1	0.0001
states
state_id_array	0.0014	0.1656	1	0.0014
state_identifier_array	0.0012	0.1323	2	0.0006
Override
Cache load	0.0018	0.2117	43	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0011	0.1233	3	0.0004
Fetch class attribute name	0.0017	0.1958	10	0.0002
XML
Image XML parsing	0.0016	0.1878	3	0.0005
class_abstraction
Instantiating content class attribute	0.0000	0.0035	14	0.0000
General
dbfile	0.0010	0.1174	30	0.0000
String conversion	0.0000	0.0013	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
7	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
7	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
10	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
3	content/datatype/view/ezxmltags/strong.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/strong.tpl
2	content/datatype/view/ezxmltags/link.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/link.tpl
2	content/datatype/view/ezxmltags/li.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/li.tpl
1	content/datatype/view/ezxmltags/ul.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/ul.tpl
1	content/datatype/view/ezxmltags/quote.tpl	datatype/ezxmltext/quote.tpl	extension/ezwebin/design/ezwebin/override/templates/datatype/ezxmltext/quote.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 35 Number of unique templates used: 10

Time used to render debug report: 0.0001 secs