Admin Page Timing Out

Next topic

Author	Message
Zaid Amireh	Thursday 06 April 2006 1:11:56 am Hello, We have ez 3.7.2 on a P4 2G RAM, when trying to access the admin interface the connection times out, apache's memory usage jumps to 900MB for the child that was handling the request. After some investigation we think the problem is related to the treemenu in the left part of the admin interface, we have a node 'News' which has 200,000 objects directly under it, building the treemenu to handle this amount of objects results in the timeouts and the huge memory usage (Even the Ajax TreeMenu plugin times out). How can we disable 'generating and pushing' the treemenu from the controller to the view, if I remove the treemenu code from the template that wouldn't stop the controller from pushing this content anyway, right? Sorry if I'm totally off track but I am not a developer. Here is a link to a call trace with full parameters (250MB, 23MB gzipped) http://205.234.207.181/trace.2043925204-2.xt.gz To be honest I couldn't make out anything useful out of it, here are my notes anyway: 1) At line 278863 is a slow sql query that took about 16 seconds. 2) At line 281520 is another slow query. 3) From line 281552 to line 490016 are mysql_fetch_array() calls which seem to be related to node 64
Kristof Coomans	Thursday 06 April 2006 1:46:31 am Take a look in contentstructuremenu.ini. You will find several settings in there to limit the content structure menu. independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org
Zaid Amireh	Thursday 06 April 2006 2:41:11 am I changed the contentstructuremenu.ini to the following ShowClasses[]=forums RootNodeID=2 MaxDepth=3 I also tried those in an override file, now the login pages times out too.
Kristof Coomans	Thursday 06 April 2006 6:06:11 am Did you put those settings under a [TreeMenu] block, and did you clear the cache afterwards? independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org
Zaid Amireh	Thursday 06 April 2006 6:08:21 am yes and yes :)
Kristof Coomans	Thursday 06 April 2006 6:19:01 am Can you browse to /settings/view of the admin interface? There you select the contentstructuremenu.ini file and your admin siteaccess. Now have a look at the ShowClasses setting. What's it's value there, and where was it taken from (the 'Placement' column)? independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org
Zaid Amireh	Thursday 06 April 2006 6:39:03 am <b>Settings for contentstructuremenu.ini in siteaccess albawaba_admin</b> ShowClasses default [0] forums override [1] forums
Kristof Coomans	Thursday 06 April 2006 10:09:50 am "forums" is the identifier of a content class that hasn't not too many object instances, right? Then the settings seem to be ok. Did you check your database? We had a similar problem once and it turned out to be the database that was corrupted. independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org
Zaid Amireh	Sunday 09 April 2006 12:04:31 am I checked the database and everything seems to be fine, sure it took like 4 hours to check considering that the database is at 17G right now.
Betsy Gamrat	Sunday 09 April 2006 7:14:44 am Also check the <b>MaxNodes</b> setting for contentstructuremenu.ini admin view.