administration interface very slow

Thursday 01 February 2007 12:31:58 am

Hi,

I have a question regarding performance of the administration interface,
we have APC php cache, we changed the settings for MySQL like described
in the article Tuning MySQL for eZ Publish cf 'http://ez.no/community/articles/tuning_mysql_for_ez_publish'
(again thanks to Bård Farstad), but the administration interface is very (too) slow.

I also tried to install an extension for the tree menu : ezjaxx, which improves performance,
but it is not enough.

What can we do for this ?

The server is a blade HS20 on a blade center IBM Architecture, with the following characteristics :
dual *Intel Xeon 3.20GHz
3Go RAM,
HARD DRIVE SCSI 10000 rpm
NETWORK 1Gb/s
*data is on a SAN Qlogic driver

Software versions are :
php 4.3.9-cgi (4.3.9-3.22) (on red hat AS 4 uptodate)
Apache 2.0.52
mysql 4.1.20

Thanks for help
Fabio Carissimi

Thursday 01 February 2007 1:41:15 am

Hi Lukasz,

as a timing extract I have

<b>Timing points:</b>
<i>Checkpoint Elapsed Rel. Elapsed Memory Rel. Memory</i>
Module start 'content' 0.0000 sec 0.2997 sec 6,483.4063KB 7,281.9297KB
Module end 'content' 0.2997 sec 0.9590 sec 13,765.3359KB 6,885.5391KB
End 1.2587 sec 20,650.8750KB 0.0059KB
<b>Total runtime: 1.2880 sec</b>
<b>Time accumulators:</b>
<i> Accumulator Elapsed Percent Count Average</i>
<b>ini_load</b>
Load cache 0.0270 sec 2.0189% 16 0.0017 sec
FindInputFiles 0.0208 sec 1.5580% 16 0.0013 sec
<b>Mysql Total</b>
Mysql_queries 0.0983 sec 7.3527% 97 0.0010 sec
Looping result 0.0081 sec 0.6056% 88 0.0001 sec
<b>TS translator </b>
TS init 0.0150 sec 1.1237% 13 0.0012 sec
TS cache load 0.0104 sec 0.7773% 13 0.0008 sec
TS context load 0.0074 sec 0.5527% 13 0.0006 sec
<b>Template Total 1.2343 sec 92.3% 3 0.4114 sec</b>
Template load 0.0121 sec 0.9048% 3 0.0040 sec
Template processing 1.2215 sec 91.3571% 3 0.4072 sec
Template load and register function 0.0001 sec 0.0094% 1 0.0001 sec
<b>override </b>
Cache load 0.0112 sec 0.8359% 6 0.0019 sec
Matching rules 0.0012 sec 0.0884% 3 0.0004 sec
<b>class_abstraction </b>
Instantiating content class attribute 0.0065 sec 0.4851% 6 0.0011 sec
<b>General </b>
dbfile 0.0441 sec 3.2954% 639 0.0001 sec
<b>Total script time: 1.3370 sec</b>

What seems to be heavy is Template processing 1.2215 sec 91.3571%
but I have this settings :

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

I have php 4.3.9 CGI like sais in the first post,
we work on a linux Red Hat AS 4 and we must use certified versions,
and unfortunatly, certified version on this OS is 4.3.9 CGI and not last php4 as an apache module.
Do you think it can change a lot ?

Thursday 01 February 2007 2:22:49 am

The site contains more than 1000 nodes /objects, but I put a limit to 500 in the tree menu in contentmenustructure.ini (MaxNodes=500). but for this point, I think ezjaxx extension partially solve the problem ??

here is an example of a scipt that take more than 7 seconds, it is only a content view in the admin
interface :
<b>Timing points:</b>
<i>Checkpoint Elapsed Rel. Elapsed Memory Rel. Memory</i>
Module start 'content' 0.0000 sec 2.8035 sec 6,487.5469Kb 19,424.4609Kb
Module end 'content' 2.8035 sec 4.3842 sec 25,912.0078Kb 16,497.3672Kb
End 7.1878 sec 42,409.3750Kb 0.0156Kb
<b>Total runtime</b>: 7.3141 sec
<b>Time accumulator</b>s:
<i>Accumulator Elapsed Percent Count Average</i>
<b>ini_load</b>
Load cache 0.0329 sec 0.4464% 19 0.0017 sec
FindinputFiles 0.0255 sec 0.3459% 19 0.0013 sec
<b>Mysql Total</b>
Mysql_queries 0.6537 sec 8.8766% 1311 0.0005 sec
Looping result 0.1193 sec 1.6206% 1304 0.0001 sec
<b>TS translator</b>
TS init 0.0182 sec 0.2466% 15 0.0012 sec
TS cache load 0.0130 sec 0.1770% 15 0.0009 sec
TS context load 0.0096 sec 0.1301% 15 0.0006 sec
<b>Template Total</b> 7.1698 sec 97.4% 3 2.3899 sec
Template load 0.0124 sec 0.1690% 3 0.0041 sec
Template processing 7.1566 sec 97.1830% 3 2.3855 sec
String conversion in template resource 0.0004 sec 0.0049% 1 0.0004 sec
Template parser: create text elements 0.0008 sec 0.0114% 1 0.0008 sec
Template parser: remove whitespace 0.0002 sec 0.0030% 1 0.0002 sec
Template parser: construct tree 0.0042 sec 0.0570% 1 0.0042 sec
Template load and register function 0.0008 sec 0.0107% 3 0.0003 sec
<b>override</b>
Cache load 0.0874 sec 1.1863% 81 0.0011 sec
Matching rules 0.0012 sec 0.0165% 3 0.0004 sec
<b>class_abstraction</b>
instantiating content class attribute 0.1075 sec 1.4592% 91 0.0012 sec
Sytem overhead
Fetch class attribute name 0.0641 sec 0.8700% 54 0.0012 sec
Fetch class attribute can translate value 0.0014 sec 0.0188% 1 0.0014 sec
XML
image XML parsing 0.0112 sec 0.1526% 2 0.0056 sec
<b>General</b>
<b>dbfile</b> 0.2093 sec 2.8424% 3117 0.0001 sec
String conversion 0.0011 sec 0.0153% 16 0.0001 sec
String conversion w/ mbstring 0.0001 sec 0.0011% 1 0.0001 sec
<b>Total script time</b>: 7.3641 sec

Thanks for help

Friday 02 February 2007 3:02:19 am

What ez publish version do you use ?

What's the speed without compile enabled (it should be faster the first page load after a clear cache).

Yes CGI has a had the reputation to be slower. I worked on a lighttpd+fastcgi config and it works fine (that's my dev environment). This being said, the numbers you give a high, no matter what. Try to disable the content tree to have a speed info not related to the size of your content tree.

X+

http://www.sydesy.com