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 31 2025 06:00:32
Script start
Timing:	Jan 31 2025 06:00:32
Module start 'layout'
Timing:	Jan 31 2025 06:00:32
Module start 'content'
Timing:	Jan 31 2025 06:00:33
Module end 'content'
Timing:	Jan 31 2025 06:00:33
Script end

Main resources:

Total runtime	1.1077 sec
Peak memory usage	4,096.0000 KB
Database Queries	57

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0086	588.2578	151.2266
Module start 'layout'	0.0086	0.0019	739.4844	36.6953
Module start 'content'	0.0105	1.0957	776.1797	940.0625
Module end 'content'	1.1062	0.0015	1,716.2422	11.8125
Script end	1.1077		1,728.0547

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	0.2841	16	0.0002
Check MTime	0.0013	0.1182	16	0.0001
Mysql Total
Database connection	0.0006	0.0574	1	0.0006
Mysqli_queries	1.0493	94.7275	57	0.0184
Looping result	0.0005	0.0441	55	0.0000
Template Total	1.0747	97.0	2	0.5373
Template load	0.0024	0.2179	2	0.0012
Template processing	1.0722	96.7940	2	0.5361
Template load and register function	0.0015	0.1395	1	0.0015
states
state_id_array	0.0019	0.1709	1	0.0019
state_identifier_array	0.0021	0.1861	2	0.0010
Override
Cache load	0.0015	0.1366	38	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0004	0.0400	2	0.0002
Fetch class attribute name	0.0020	0.1808	4	0.0005
XML
Image XML parsing	0.0006	0.0498	2	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0009	4	0.0000
General
dbfile	0.0025	0.2259	17	0.0001
String conversion	0.0000	0.0004	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
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	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 24 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs