slow site / cache dir not being populated

Next topic

Author	Message
Andre Felipe Machado	Sunday 01 July 2007 8:20:36 am Hello, My site http://www.techforce.com.br is working but painfully slow and cpu hungry now after an isp bw quota limit reached. The mysql db was runing away 100% cpu. Myisamchk --safe-recover on it. Myisamchk --extend-check on it said mysql ok now. But the site is still slow and now apache is taking 100% cpu. I guess it is a cache problem. the settings/override/site.ini.append.php contains: [OverrideSettings] Cache=enabled [TemplateSettings] TemplateCache=enabled TemplateCompile=enabled TemplateOptimization=enabled NodeTreeCaching=enabled [ContentSettings] TranslationList=eng-GB;eng-US;por-BR ViewCaching=enabled CachedViewModes=full;sitemap;pdf PreViewCache=enabled PreCacheSiteaccessArray[]=news PreCacheSiteaccessArray[]=news_admin Executed bin/shell/clearcache.sh --clear-all Executed bin/modifx.sh Granted permissive access to var/ changed var/ owner to the webserver user and group. Even restarted the xen vm. but the var/news/cache and var/cache sub-directories are almost empty (only packages and translation populated). I saw that var/news/cache/expiry.php was not cleared by clearcache.sh. Do you have suggestions? Regards. Andre Felipe --- A Debian user never dies. Issues a last command: shutdown -h now http://www.techforce.com.br
Paul Borgermans	Sunday 01 July 2007 11:22:48 am If mysql is running away, check also the session table (and clear it). Hard to do anything about bw limits hit Paul eZ Publish, eZ Find, Solr expert consulting and training http://twitter.com/paulborgermans
Andre Felipe Machado	Monday 02 July 2007 8:28:31 am Hello, Many thanks for your suggestion. I was not aware of the session table problem. I managed to circumvent the cache problem (not a real solution). Was able to find a local backup (rsync) including the var/cache and var/news/cache directories with megabytes of data and done at a day with normal behaviour. Uploaded that old cache data and now the site is running at normal speed. Some pages were displaying at old cached versions (!) from that date, despite admin interface showing their new versions. Well, an edit publish cycle refreshed the cache content for these pages. Not the best solution, but worked. From inside the admin panel, flushing the cache did not solve. Weird. Seems as ezp not being able to create cache directories or files. but it can update content and recreate cache files already there. It is a trick, and a real solution should be investigated. regards. Andre Felipe --- A Debian user never dies. Issues a last command: shutdown -h now http://www.techforce.com.br

Author

Message

Sunday 01 July 2007 8:20:36 am

Hello,
My site http://www.techforce.com.br is working but painfully slow and cpu hungry now after an isp bw quota limit reached.
The mysql db was runing away 100% cpu.
Myisamchk --safe-recover on it.
Myisamchk --extend-check on it said mysql ok now.
But the site is still slow and now apache is taking 100% cpu.
I guess it is a cache problem.
the settings/override/site.ini.append.php contains:

[OverrideSettings]
Cache=enabled

[TemplateSettings]
TemplateCache=enabled
TemplateCompile=enabled
TemplateOptimization=enabled
NodeTreeCaching=enabled

[ContentSettings]
TranslationList=eng-GB;eng-US;por-BR
ViewCaching=enabled
CachedViewModes=full;sitemap;pdf
PreViewCache=enabled
PreCacheSiteaccessArray[]=news
PreCacheSiteaccessArray[]=news_admin

Executed bin/shell/clearcache.sh --clear-all
Executed bin/modifx.sh
Granted permissive access to var/
changed var/ owner to the webserver user and group.
Even restarted the xen vm.

but the var/news/cache and var/cache sub-directories are almost empty (only packages and translation populated).
I saw that var/news/cache/expiry.php was not cleared by clearcache.sh.

Do you have suggestions?
Regards.
Andre Felipe

---
A Debian user never dies. Issues a last command:
shutdown -h now

http://www.techforce.com.br

Paul Borgermans

Sunday 01 July 2007 11:22:48 am

If mysql is running away, check also the session table (and clear it).

Hard to do anything about bw limits hit

Paul

eZ Publish, eZ Find, Solr expert consulting and training
http://twitter.com/paulborgermans

Andre Felipe Machado

Monday 02 July 2007 8:28:31 am

Hello,
Many thanks for your suggestion. I was not aware of the session table problem.
I managed to circumvent the cache problem (not a real solution).
Was able to find a local backup (rsync) including the var/cache and var/news/cache directories with megabytes of data and done at a day with normal behaviour.
Uploaded that old cache data and now the site is running at normal speed.
Some pages were displaying at old cached versions (!) from that date, despite admin interface showing their new versions.
Well, an edit publish cycle refreshed the cache content for these pages. Not the best solution, but worked.
From inside the admin panel, flushing the cache did not solve.
Weird. Seems as ezp not being able to create cache directories or files. but it can update content and recreate cache files already there.
It is a trick, and a real solution should be investigated.
regards.
Andre Felipe

---
A Debian user never dies. Issues a last command:
shutdown -h now

http://www.techforce.com.br

eZ debug

Timing:	Jan 18 2025 16:08:53
Script start
Timing:	Jan 18 2025 16:08:53
Module start 'layout'
Timing:	Jan 18 2025 16:08:53
Module start 'content'
Timing:	Jan 18 2025 16:08:53
Module end 'content'
Timing:	Jan 18 2025 16:08:54
Script end

Main resources:

Total runtime	0.9555 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.0054	589.4375	152.6250
Module start 'layout'	0.0054	0.0025	742.0625	39.4453
Module start 'content'	0.0079	0.9462	781.5078	553.9063
Module end 'content'	0.9541	0.0014	1,335.4141	12.1406
Script end	0.9555		1,347.5547

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.3517	16	0.0002
Check MTime	0.0014	0.1480	16	0.0001
Mysql Total
Database connection	0.0011	0.1101	1	0.0011
Mysqli_queries	0.8969	93.8592	57	0.0157
Looping result	0.0007	0.0764	55	0.0000
Template Total	0.9217	96.5	2	0.4608
Template load	0.0022	0.2266	2	0.0011
Template processing	0.9195	96.2274	2	0.4597
Template load and register function	0.0001	0.0122	1	0.0001
states
state_id_array	0.0015	0.1546	1	0.0015
state_identifier_array	0.0010	0.1059	2	0.0005
Override
Cache load	0.0018	0.1921	42	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0614	2	0.0003
Fetch class attribute name	0.0015	0.1599	5	0.0003
XML
Image XML parsing	0.0011	0.1143	2	0.0005
class_abstraction
Instantiating content class attribute	0.0000	0.0015	6	0.0000
General
dbfile	0.0020	0.2107	23	0.0001
String conversion	0.0000	0.0007	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/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
5	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
6	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 20 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs