Bug ? or low performance ?.....

[MagicMike]

Sorry to bother but i have serious performance issues ......
here's my config:
1.Webserver:
Pentium 4 HT 3.00GHZ
2G RAM
80GHD
SuseLinux9.1
2. Sqlserver:
Pentium 4 HT 3.00GHZ
1G RAM80G HD (2x40G raid0)
SuseLinux9.2

I am using apache2 2.0.52
having a PHPNUKE site with around 35000 members
Online around 300-500users at once
Performance is LOUSY and very slow !


Here's what i did:

I installed and configured your webserver according to instructions
copied the phpnukefiles over to the DEFAULT/html dir (running on
port 8088 ! (running well there
changed the mmcache config (in php.ini) that it would enable the optimizer !
(its off by default ?? )
stopped and started lsws by typing /opt/lsws/bin/lswsctrl stop|start
(checked that everything was running as it used to be !)
switched off apache2 (rcapache2 stop)
then changed the port from 8088 to 80
restarted ( like listed above) lsws !

after a few minutes (around 5 or so) the performance of your webserver goes down ? Drastically !
Until the webpage wasnt reachable anymore (no errors but endless waiting time...)

(i have a some users online at once so.....)

after that experience i stopped lsws and started apache2 again

Its slow (very slow on weekends ) but everyone can access the pages

what did i do wrong ?

regards MIKE

[mistwang]

I think it is not configured properly, and I need more information to identify the problem, output of "top", "netstat -an | grep ESTABLISHED",
and content of lsws/logs/error.log lsws/logs/stderr.log, Real time report page in admin interface.

If you can make the admin interface available to me, I can take a look.

There are some configuration you need to tune for the best performance in production environment:
Turn on "Smart Keepalive", set "Connections soft limit per client" to "10",
Also turn off MySQL persistent connection in php.ini

[MagicMike]

Originally Posted by mistwang

, set "Connections soft limit per client" to "10",

I guess that does the trick...server load does not go over 0.5 !!

lets see how it will do this night when more users are online at the same time

thanks

[mistwang]

You are welcome. :-)

"Connection limits" are helpful with server load, but I think it is not the cause of the site slow down & hanging problem.
The problem should be caused by the persistent connection from PHP to MySQL, deadlock happens, and eventually all PHP processes hang there doing nothing. We saw it happened on many sites.

Please keep us posted. :-)

[MagicMike]

Originally Posted by mistwang

You are welcome. :-)

"Connection limits" are helpful with server load, but I think it is not the cause of the site slow down & hanging problem.
The problem should be caused by the persistent connection from PHP to MySQL, deadlock happens, and eventually all PHP processes hang there doing nothing. We saw it happened on many sites.

Please keep us posted. :-)

sorry that wasnt the case here
NO persistent connection were made (this would render the sqlserver useless after some time of using it *g* )
I am affraid that i am not using it right now :-(
i have a new problem with it some (not all ???) users get a scrambled page (regardless of browser or OS) looks like the gzip compression of somehow messed up ? (either thru configuration or on my webserver)

I had this issue once in cooperation with mmcache !

i will investigate

regards Mike

[mistwang]

If you are using "epoll" event dispatcher, you should switch to "poll".

[MagicMike]

Originally Posted by mistwang

If you are using "epoll" event dispatcher, you should switch to "poll".

send you a pm check please

[mistwang]

It is caused by mmcache + gzip compression in PHP, try turning off compression in PHP and clearing mmcache disk cache.
Consider using eAccelerator instead.

[MagicMike]

Using eaccelerator and it works like a charm
not THAT fast as i thought it would be but...if you can squeese some
more performance out of it your are free to try....its life and online now with
lightspeed webserver

(send you a pm with the details the other day )

thanks for your help

MIKE

[mistwang]

The bottle neck is in PHP, the faster PHP runs, the bigger performance difference with litespeed will be.