Topic: Crazy Load on 24 Core, 16 GB Server with only 5 visitors

[panta3000]

Hi,

we run:

Apache 2.4.18 on ubuntu
Mysql
typo3

on:
Vsphere 6.5 virtualized ubuntu 16.04. LTS
24 Core, 16 GB RAM

we have Performance issues, i just need to click around the site and load goes up, apache process are easy 95% cpu. The site feels and is laggy when theres more than one person on it.

Even when Nobody is on it cpu load of apache precesses is around 20-30%

Its either mysql or the apache procs going up in cpu load.

I have tried several things like tweak cache settings and hostlookups but i cant get my hand on it.

What else can/should i do to get to the bottom of this? Ive searched around quite a bit but nothing i found or changed so far made it better.
Im not an expert on this...

This is server-status:

Server Version: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g
Server MPM: prefork
Server Built: 2018-06-07T19:43:03

Current Time: Wednesday, 20-Feb-2019 13:55:50 CET
Restart Time: Wednesday, 20-Feb-2019 12:47:56 CET
Parent Server Config. Generation: 1
Parent Server MPM Generation: 0
Server uptime: 1 hour 7 minutes 54 seconds
Server load: 1.02 1.05 1.00
Total accesses: 1919 - Total Traffic: 41.5 MB
CPU Usage: u3813.88 s128.98 cu.01 cs.02 - 96.8% CPU load
.471 requests/sec - 10.4 kB/second - 22.1 kB/request
2 requests currently being processed, 23 idle workers

________________W_______W.......................................
........................................................

Scoreboard Key:
"_" Waiting for Connection, "S" Starting up, "R" Reading Request,
"W" Sending Reply, "K" Keepalive (read), "D" DNS Lookup,
"C" Closing connection, "L" Logging, "G" Gracefully finishing,
"I" Idle cleanup of worker, "." Open slot with no current process

Srv PID Acc M CPU SS Req Conn Child Slot Client VHost Request
0-0 28242 0/64/64 _ 245.55 27 0 0.0 3.06 3.06 141.26.180.xx www.xxxx:443 NULL
1-0 28243 0/140/140 _ 116.94 90 1 0.0 2.02 2.02 141.51.74.xx
2-0 28244 0/75/75 _ 142.26 1 1 0.0 1.61 1.61 ::1 xxxxxx:80 GET /server-status HTTP/1.0
3-0 28245 0/74/74 _ 194.69 31 1 0.0 1.42 1.42 147.88.239.xx
4-0 28246 0/33/33 _ 58.19 97 2 0.0 0.94 0.94 141.26.180.xx
5-0 28247 0/67/67 _ 229.90 153 1 0.0 1.66 1.66 141.26.180.xx
6-0 28248 0/33/33 _ 110.30 41 0 0.0 1.00 1.00 ::1 xxxxxx:80 GET /server-status HTTP/1.1
7-0 28249 0/120/120 _ 149.52 90 25919 0.0 1.34 1.34 141.26.180.xx xxxxxxx:443 NULL
8-0 28250 0/78/78 _ 303.33 31 0 0.0 1.76 1.76 147.88.239.xx
10-0 28271 0/82/82 _ 239.09 151 1 0.0 2.16 2.16 141.51.74.xx
11-0 28272 0/155/155 _ 161.94 53 6791 0.0 2.40 2.40 91.121.160.xxx www.xxxxxx.de:443 NULL
12-0 28273 0/149/149 _ 148.36 137 6923 0.0 1.46 1.46 91.121.160.xx www.xxxxxxx.de:443 NULL
13-0 28274 0/133/133 _ 109.51 98 0 0.0 1.97 1.97 141.51.74.xx
14-0 28275 0/60/60 _ 179.00 31 1 0.0 1.90 1.90 147.88.239.xx
16-0 28277 0/68/68 W 174.32 0 0 0.0 0.81 0.81 ::1 xxxxxxxxxxxx.de:80 GET /server-status HTTP/1.0
17-0 28278 0/84/84 _ 212.66 31 6851 0.0 2.25 2.25 147.88.239.xx
20-0 28320 0/45/45 _ 124.14 27 1 0.0 1.49 1.49 141.26.180.xx www.xxxxxxx.de:443 NULL
21-0 28562 0/44/44 _ 85.09 29 442 0.0 1.68 1.68 188.138.40.xx www.xxxxxx.de:443 GET / HTTP/1.1
22-0 28563 0/31/31 _ 93.06 158 3 0.0 0.69 0.69 141.51.74.xx
23-0 28564 0/23/23 _ 49.35 31 5659 0.0 0.61 0.61 147.88.239.xx
24-0 28837 3/27/27 W 109.23 5 0 46.3 0.65 0.65 91.121.160.xx www.xxxxxx.de:443 GET /xxxxxx/ HTTP/1.1



I hope someone can point me in the right direction.

Cheers,

Chris

[spser]

httpd.conf

upload href

[panta3000]

Im sorry I dont understand. I cant find what you mean be upload href ? Its an entry that should go into httpd.conf ?
I cant find info on this - please elaborate.

Thank you

[James Blond]

Put your config at http://apaste.info/ or http://hastebin.com/ and post here the link to your config. The crystal ball isn't that clear today.

[panta3000]

yeah youre right

here goes:

https://apaste.info/GqjL
https://apaste.info/vJkx
https://apaste.info/XqLo


Thanks for looking!

[panta3000]

Hi,

anyone can help ?

thx alot !

[James Blond]

It isn't the apache config. It might be the php config, but unlikely.
I think it is the typo3 software you run or it might be something different on the OS itself.

What helped a log of user on apache lounge is to use mod_fcgid to seperate PHP from apache process. Then you will be sure if it is apache or the PHP process that runs amok.

[panta3000]

Thank youm i will check it out