Forums / Install & configuration / Server goes DOWN - is ez publish guilty?

Server goes DOWN - is ez publish guilty?

Previous topic

Install & configuration

Next topic

Author	Message
Andrey Astakhov	Friday 19 October 2007 4:17:10 am My web server goes down third time this week. Server administrator say that they suspect php memory leaks. Hardware AMD Athlon64 3500+, 1GB RAM Software Operating system: Redhat Linux Fedora 6 Apache: 1.3.37 PHP: 4.4.7 (php info: http://prostobank.com.ua/phpinfo.php) eZ Publish: 3.8.4 We have about 5000 visitors per day. I noticed that ezsession table is always corrupted after server is down. I truncated this table and kept an eye on it. Thus, I've found out that size of this table grows drastically: about 50-60 NEW sessions per minute. At the moment I have 3900 anonymous users and 5900 sessions. I tried to delete old and expired sessions, but it doesn't work: i still have 5900 sessions (even more already). 60 new sessions per minute - is this a normall behaviour?
André R.	Friday 19 October 2007 6:13:03 am Related issue: http://issues.ez.no/10431 Related forum thread: http://ez.no/developer/forum/general/session_table_not_being_cleared_in_a_3_6_2_site 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
Andrey Astakhov	Friday 19 October 2007 9:16:46 am Thank you for answer, Andre <i> > Related issue: > http://issues.ez.no/10431 </i> I don't have Debian or Ubuntu and my session.gc_probability = 1 Why the resolution for this issue is "Won't Implement"? Is it not a problem? <i> > Related forum thread: > http://ez.no/developer/forum/gene...le_not_being_cleared_in_a_3_6_2_site </i> Great: "I belive there is a 'session' created for every request from the anynomous user" That is a real problem. Session cleanup cronjob but is good idea but it looks like a workaround. Why eZ Publish creates a new record in ezssession table for every http request? Does it depend on [Session] configuration in site.ini?

Author

Message

Andrey Astakhov

Friday 19 October 2007 4:17:10 am

My web server goes down third time this week.
Server administrator say that they suspect php memory leaks.

Hardware
AMD Athlon64 3500+, 1GB RAM

Software
Operating system: Redhat Linux Fedora 6
Apache: 1.3.37
PHP: 4.4.7 (php info: http://prostobank.com.ua/phpinfo.php)
eZ Publish: 3.8.4

We have about 5000 visitors per day.

I noticed that ezsession table is always corrupted after server is down.
I truncated this table and kept an eye on it.
Thus, I've found out that size of this table grows drastically: about 50-60 NEW sessions per minute.
At the moment I have 3900 anonymous users and 5900 sessions. I tried to delete old and expired sessions, but it doesn't work: i still have 5900 sessions (even more already).

60 new sessions per minute - is this a normall behaviour?

André R.

Friday 19 October 2007 6:13:03 am

Related issue:
http://issues.ez.no/10431

Related forum thread:
http://ez.no/developer/forum/general/session_table_not_being_cleared_in_a_3_6_2_site

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

Andrey Astakhov

Friday 19 October 2007 9:16:46 am

Thank you for answer, Andre
<i>
> Related issue:
> http://issues.ez.no/10431
</i>
I don't have Debian or Ubuntu and my session.gc_probability = 1
Why the resolution for this issue is "Won't Implement"? Is it not a problem?

<i>
> Related forum thread:
> http://ez.no/developer/forum/gene...le_not_being_cleared_in_a_3_6_2_site
</i>

Great: "I belive there is a 'session' created for every request from the anynomous user"
That is a real problem. Session cleanup cronjob but is good idea but it looks like a workaround. Why eZ Publish creates a new record in ezssession table for every http request? Does it depend on [Session] configuration in site.ini?

eZ debug

Timing:

Jan 18 2025 18:25:17

Script start

Timing:

Jan 18 2025 18:25:17

Module start 'content'

Timing:

Jan 18 2025 18:25:17

Module end 'content'

Timing:

Jan 18 2025 18:25:17

Script end

Main resources:

Total runtime

0.6825 sec

Peak memory usage

4,096.0000 KB

Database Queries

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0068	587.8516	180.8203
Module start 'content'	0.0068	0.6701	768.6719	549.3984
Module end 'content'	0.6770	0.0054	1,318.0703	42.0703
Script end	0.6824		1,360.1406

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0068

587.8516

180.8203

Module start 'content'

0.0068

0.6701

768.6719

549.3984

Module end 'content'

0.6770

0.0054

1,318.0703

42.0703

Script end

0.6824

1,360.1406

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.5008	14	0.0002
Check MTime	0.0015	0.2231	14	0.0001
Mysql Total
Database connection	0.0007	0.1027	1	0.0007
Mysqli_queries	0.6099	89.3637	58	0.0105
Looping result	0.0005	0.0758	56	0.0000
Template Total	0.6356	93.1	2	0.3178
Template load	0.0022	0.3293	2	0.0011
Template processing	0.6333	92.7940	2	0.3167
Template load and register function	0.0002	0.0268	1	0.0002
states
state_id_array	0.0009	0.1303	1	0.0009
state_identifier_array	0.0008	0.1201	2	0.0004
Override
Cache load	0.0019	0.2721	38	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0924	2	0.0003
Fetch class attribute name	0.0008	0.1235	4	0.0002
XML
Image XML parsing	0.0006	0.0851	2	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0013	4	0.0000
General
dbfile	0.0068	1.0017	19	0.0004
String conversion	0.0000	0.0010	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0034

0.5008

0.0002

Check MTime

0.0015

0.2231

0.0001

Mysql Total

Database connection

0.0007

0.1027

0.0007

Mysqli_queries

0.6099

89.3637

0.0105

Looping result

0.0005

0.0758

0.0000

Template Total

0.6356

93.1

0.3178

Template load

0.0022

0.3293

0.0011

Template processing

0.6333

92.7940

0.3167

Template load and register function

0.0002

0.0268

0.0002

states

state_id_array

0.0009

0.1303

0.0009

state_identifier_array

0.0008

0.1201

0.0004

Override

Cache load

0.0019

0.2721

0.0000

Sytem overhead

Fetch class attribute can translate value

0.0006

0.0924

0.0003

Fetch class attribute name

0.0008

0.1235

0.0002

XML

Image XML parsing

0.0006

0.0851

0.0003

class_abstraction

Instantiating content class attribute

0.0000

0.0013

0.0000

General

dbfile

0.0068

1.0017

0.0004

String conversion

0.0000

0.0010

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
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
9	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
9	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 24 Number of unique templates used: 6

Usage

Requested template

Template

Template loaded

Edit

Override

node/view/full.tpl

full/forum_topic.tpl

extension/sevenx/design/simple/override/templates/full/forum_topic.tpl