[TYPO3-dev] Typo3 Performance

[Dmitry Dulepov]

Hi!

Franz Koch wrote:
 > yes I have, but somehow my cache-folder wasn't writeable for
 > eaccelerator anymore (it worked before). I changed that and now I have
 > up to 6 pages/sec. with typo3 cache enabled. If I turn typo3 cache 
off > I only got 0.6 pages/sec. (already with eaccelerator).

Yes, eaccelerator helps a lot. But still rate is not high.

 >> Now look into my.cnf and see if have there:
 >> concurent_insert=1
 >
 > no it isn't - should I activate it?

Yes.

 > max_allowed_packet = 1M

You can try increasing this to 4M and see if it makes any difference. 
Basically this is a limit for data transfer chunk. The larger it is, the 
more data can be transfered through socket.

 > read_buffer_size = 131072
 > read_rnd_buffer_size = 262144

These two can be increased too. The first one is how much mysql reads 
sequentaly from files, the second is similar (I do not remember 
difference now). The large - the less disk access.

 > sort_buffer_size = 52280

50K is too small. Set this to 1M at least.

 > table_cache = 256

Hard to say about this one without seeing mysql stats. Should be ok if 
you have only one typo3 site. I have 1000 after tuning but I have 2GB RAM.

 > wait_timeout = 28800

This is default but it can be set to much lower value (I have 15). It 
means that connection waits for this amount of seconds and this 
connection (when it is from PHP!) is not used until closed after 
timeout. I could figure out how php & mysql close those but I often 
found that many connections are idle while new created thus taking extra 
system resources. So I set this to 15 and mysql now keeps minimum number 
of connections.

 > mysql.allow_persistent was enabled in php.ini . After disabling it I
 > have up to 9.8 pages/sec. A static page btw. is delivered with 267
 > pages/sec. A php-file with call for phpinfo() at 89 pages/sec.

Do you run php as module?

If you had more memory, you could enable shm in eaccelerator, it will be 
faster.

 > - mySQL 4.0.18 (I'd like to update, but I fear loosing data as I not a
 > linux freak - just try and error all the time)

No need, it works well.

 > Again, thanks for helping me.

:) Community works! :)

-- 
Dmitry Dulepov

Web: http://typo3bloke.net/
Skype: callto:liels_bugs

"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)