httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gryzli Bugbear <gryzli.the.bugb...@gmail.com>
Subject Re: [users@httpd] Slow Apache 2.4 server
Date Thu, 21 Jun 2018 06:11:02 GMT
Hi,

Maybe you should first find where the slowness come from (most probably 
it is php, rather than Apache).

You could try to measure the php execution time from the beginning of 
the request to the end of it, then you will have some more information 
where to dig further.

It wont be a good idea to start optimizing blindly some stuff, without 
being sure where exactly the problem is.


Regards,


On 06/20/2018 07:31 PM, Jørn wrote:
> Hello,
>
> I have a problem with slow access from Apache 2.4.27 (new server) compared to an older
> Apache 2.2.14 (old server.
> The old server is a dual core AMD running Fedora Core 12 with 4Gb physical memory, while
> the new server is an 8 core AMD with 16 Gb memory.
>
> It is the same PHP code on both. The old server has PHP version 5.2.12 and the new server
> has PHP 7.0.25. The PHP code access the same database.
>
> Below is an extract from the access log file from both servers. Both requests are the
same
> resulting in rendering a lot of thumbnails. On the old server (with other traffic), the
> total time from the first GET to the last one is 4 seconds. While on the new server the
> time is 7 seconds.
>
> I have not done touch/tuned any parameters since I do not know which one to touch.
>
> My BIG question is: What can be done to make the new server as fast as the old one?
>
> I have included some output from httpd -V and from the access log showing relevant
> requests.
>
>
> Old server> httpd -V
> Server version: Apache/2.2.14 (Unix)
> Server built:   Feb 16 2010 22:30:44
> Server's Module Magic Number: 20051115:23
> Server loaded:  APR 1.3.9, APR-Util 1.3.9
> Compiled using: APR 1.3.9, APR-Util 1.3.9
> Architecture:   64-bit
> Server MPM:     Prefork
>    threaded:     no
>      forked:     yes (variable process count)
> Server compiled with....
>   -D APACHE_MPM_DIR="server/mpm/prefork"
>   -D APR_HAS_SENDFILE
>   -D APR_HAS_MMAP
>   -D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)
>   -D APR_USE_SYSVSEM_SERIALIZE
>   -D APR_USE_PTHREAD_SERIALIZE
>   -D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
>   -D APR_HAS_OTHER_CHILD
>   -D AP_HAVE_RELIABLE_PIPED_LOGS
>   -D DYNAMIC_MODULE_LIMIT=128
>   -D HTTPD_ROOT="/usr/local/apache2"
>   -D SUEXEC_BIN="/usr/local/apache2/bin/suexec"
>   -D DEFAULT_PIDLOG="logs/httpd.pid"
>   -D DEFAULT_SCOREBOARD="logs/apache_runtime_status"
>   -D DEFAULT_LOCKFILE="logs/accept.lock"
>   -D DEFAULT_ERRORLOG="logs/error_log"
>   -D AP_TYPES_CONFIG_FILE="conf/mime.types"
>   -D SERVER_CONFIG_FILE="conf/httpd.conf"
>   
>
> New server> httpd -V
> Server version: Apache/2.4.27 (Fedora)
> Server built:   Jul 17 2017 13:12:07
> Server's Module Magic Number: 20120211:68
> Server loaded:  APR 1.6.2, APR-UTIL 1.5.4
> Compiled using: APR 1.5.2, APR-UTIL 1.5.4
> Architecture:   64-bit
> Server MPM:     prefork
>    threaded:     no
>      forked:     yes (variable process count)
> Server compiled with....
>   -D APR_HAS_SENDFILE
>   -D APR_HAS_MMAP
>   -D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)
>   -D APR_USE_SYSVSEM_SERIALIZE
>   -D APR_USE_PTHREAD_SERIALIZE
>   -D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
>   -D APR_HAS_OTHER_CHILD
>   -D AP_HAVE_RELIABLE_PIPED_LOGS
>   -D DYNAMIC_MODULE_LIMIT=256
>   -D HTTPD_ROOT="/etc/httpd"
>   -D SUEXEC_BIN="/usr/sbin/suexec"
>   -D DEFAULT_PIDLOG="/run/httpd/httpd.pid"
>   -D DEFAULT_SCOREBOARD="logs/apache_runtime_status"
>   -D DEFAULT_ERRORLOG="logs/error_log"
>   -D AP_TYPES_CONFIG_FILE="conf/mime.types"
>   -D SERVER_CONFIG_FILE="conf/httpd.conf"
>
>
>  From old server accessed from internet over a 5Mbit line:
>
> 20/Jun/2018:13:38:12 +0200 "GET /album/styrkeprveun/content HTTP/1.1" 200 36405
> 20/Jun/2018:13:38:13 +0200 "GET /image/thumbnail/155181p9s0/render HTTP/1.1" 200 7039
> 20/Jun/2018:13:38:13 +0200 "GET /image/thumbnail/155183p5k0/render HTTP/1.1" 200 7516
> 20/Jun/2018:13:38:13 +0200 "GET /image/thumbnail/1551897qn0/render HTTP/1.1" 200 8879
> 20/Jun/2018:13:38:13 +0200 "GET /image/thumbnail/155184ot70/render HTTP/1.1" 200 7933
> 20/Jun/2018:13:38:13 +0200 "GET /image/thumbnail/155187xrb0/render HTTP/1.1" 200 7946
> 20/Jun/2018:13:38:13 +0200 "GET /image/thumbnail/155191rr50/render HTTP/1.1" 200 8160
> 20/Jun/2018:13:38:13 +0200 "GET /image/thumbnail/155190aau0/render HTTP/1.1" 200 8229
> 20/Jun/2018:13:38:13 +0200 "GET /image/thumbnail/155193bto0/render HTTP/1.1" 200 8176
> 20/Jun/2018:13:38:13 +0200 "GET /image/thumbnail/155195z940/render HTTP/1.1" 200 7294
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155199zwi0/render HTTP/1.1" 200 8323
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155202rmm0/render HTTP/1.1" 200 8783
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155197q9a0/render HTTP/1.1" 200 7148
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155207h760/render HTTP/1.1" 200 7162
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155209rdv0/render HTTP/1.1" 200 7673
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155212em50/render HTTP/1.1" 200 9299
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/1552148du0/render HTTP/1.1" 200 9065
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155204c9f0/render HTTP/1.1" 200 7462
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155216cno0/render HTTP/1.1" 200 7407
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155218znv0/render HTTP/1.1" 200 7477
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/1552193c50/render HTTP/1.1" 200 7489
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155221ccz0/render HTTP/1.1" 200 7604
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155222t3m0/render HTTP/1.1" 200 8050
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155223fdu0/render HTTP/1.1" 200 7990
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155224tuz0/render HTTP/1.1" 200 8019
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155225ykd0/render HTTP/1.1" 200 8059
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155226tyx0/render HTTP/1.1" 200 8030
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155227w6a0/render HTTP/1.1" 200 8252
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155229fhj0/render HTTP/1.1" 200 8020
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155230aiu0/render HTTP/1.1" 200 8130
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155231du70/render HTTP/1.1" 200 8192
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155228rhw0/render HTTP/1.1" 200 8237
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155232dn90/render HTTP/1.1" 200 8140
> 20/Jun/2018:13:38:14 +0200 "GET /image/thumbnail/155233x3m0/render HTTP/1.1" 200 7880
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/155234ruf0/render HTTP/1.1" 200 7856
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/155235rtz0/render HTTP/1.1" 200 7901
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/1552364mx0/render HTTP/1.1" 200 7826
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/1552372i40/render HTTP/1.1" 200 8292
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/155238bak0/render HTTP/1.1" 200 7869
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/1552417o20/render HTTP/1.1" 200 7019
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/155244pwi0/render HTTP/1.1" 200 7450
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/155247jad0/render HTTP/1.1" 200 7015
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/155251pmy0/render HTTP/1.1" 200 7430
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/155252xjz0/render HTTP/1.1" 200 8292
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/155254ibu0/render HTTP/1.1" 200 8548
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/155255w3n0/render HTTP/1.1" 200 8447
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/155257v590/render HTTP/1.1" 200 7356
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/155259s6r0/render HTTP/1.1" 200 7189
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/155260vfz0/render HTTP/1.1" 200 7902
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/155262fmn0/render HTTP/1.1" 200 7993
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/155264fbj0/render HTTP/1.1" 200 7967
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/155266xtt0/render HTTP/1.1" 200 6956
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/155267aie0/render HTTP/1.1" 200 7339
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/1552699gx0/render HTTP/1.1" 200 8068
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/1552719x80/render HTTP/1.1" 200 8268
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/1552743ta0/render HTTP/1.1" 200 6943
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/155275ppd0/render HTTP/1.1" 200 7451
> 20/Jun/2018:13:38:15 +0200 "GET /image/thumbnail/155276xhi0/render HTTP/1.1" 200 7213
> 20/Jun/2018:13:38:16 +0200 "GET /image/thumbnail/155278ocw0/render HTTP/1.1" 200 6816
> 20/Jun/2018:13:38:16 +0200 "GET /image/thumbnail/155279nqi0/render HTTP/1.1" 200 7283
> 20/Jun/2018:13:38:16 +0200 "GET /image/thumbnail/155280a6s0/render HTTP/1.1" 200 7385
> 20/Jun/2018:13:38:16 +0200 "GET /image/thumbnail/155281t3m0/render HTTP/1.1" 200 7452
>
> Range: 20/Jun/2018:13:38:12 - 20/Jun/2018:13:38:16. Total of 4 seconds.
>
> New server accessed from internal 100Mbit network:
> Jun/2018:18:10:34 +0200 "GET /album/styrkeprveun/content HTTP/1.1" 200 51460
> Jun/2018:18:10:35 +0200 "GET /image/thumbnail/155184ot70/render HTTP/1.1" 200 7933
> Jun/2018:18:10:35 +0200 "GET /image/thumbnail/155190aau0/render HTTP/1.1" 200 8229
> Jun/2018:18:10:35 +0200 "GET /image/thumbnail/155183p5k0/render HTTP/1.1" 200 7516
> Jun/2018:18:10:35 +0200 "GET /image/thumbnail/155187xrb0/render HTTP/1.1" 200 7946
> Jun/2018:18:10:35 +0200 "GET /image/thumbnail/1551897qn0/render HTTP/1.1" 200 8879
> Jun/2018:18:10:35 +0200 "GET /image/thumbnail/155181p9s0/render HTTP/1.1" 200 7039
> Jun/2018:18:10:35 +0200 "GET /image/thumbnail/155191rr50/render HTTP/1.1" 200 8160
> Jun/2018:18:10:35 +0200 "GET /image/thumbnail/155193bto0/render HTTP/1.1" 200 8176
> Jun/2018:18:10:35 +0200 "GET /image/thumbnail/155197q9a0/render HTTP/1.1" 200 7148
> Jun/2018:18:10:35 +0200 "GET /image/thumbnail/155195z940/render HTTP/1.1" 200 7294
> Jun/2018:18:10:35 +0200 "GET /image/thumbnail/155199zwi0/render HTTP/1.1" 200 8323
> Jun/2018:18:10:36 +0200 "GET /image/thumbnail/155202rmm0/render HTTP/1.1" 200 8783
> Jun/2018:18:10:36 +0200 "GET /image/thumbnail/155204c9f0/render HTTP/1.1" 200 7462
> Jun/2018:18:10:36 +0200 "GET /image/thumbnail/155207h760/render HTTP/1.1" 200 7162
> Jun/2018:18:10:36 +0200 "GET /image/thumbnail/155209rdv0/render HTTP/1.1" 200 7673
> Jun/2018:18:10:36 +0200 "GET /image/thumbnail/155212em50/render HTTP/1.1" 200 9299
> Jun/2018:18:10:36 +0200 "GET /image/thumbnail/1552148du0/render HTTP/1.1" 200 9065
> Jun/2018:18:10:36 +0200 "GET /image/thumbnail/155218znv0/render HTTP/1.1" 200 7477
> Jun/2018:18:10:36 +0200 "GET /image/thumbnail/155216cno0/render HTTP/1.1" 200 7407
> Jun/2018:18:10:36 +0200 "GET /image/thumbnail/1552193c50/render HTTP/1.1" 200 7489
> Jun/2018:18:10:37 +0200 "GET /image/thumbnail/155223fdu0/render HTTP/1.1" 200 7990
> Jun/2018:18:10:36 +0200 "GET /image/thumbnail/155221ccz0/render HTTP/1.1" 200 7604
> Jun/2018:18:10:37 +0200 "GET /image/thumbnail/155222t3m0/render HTTP/1.1" 200 8050
> Jun/2018:18:10:37 +0200 "GET /image/thumbnail/155224tuz0/render HTTP/1.1" 200 8019
> Jun/2018:18:10:37 +0200 "GET /image/thumbnail/155225ykd0/render HTTP/1.1" 200 8059
> Jun/2018:18:10:37 +0200 "GET /image/thumbnail/155226tyx0/render HTTP/1.1" 200 8030
> Jun/2018:18:10:37 +0200 "GET /image/thumbnail/155227w6a0/render HTTP/1.1" 200 8252
> Jun/2018:18:10:37 +0200 "GET /image/thumbnail/155228rhw0/render HTTP/1.1" 200 8237
> Jun/2018:18:10:37 +0200 "GET /image/thumbnail/155229fhj0/render HTTP/1.1" 200 8020
> Jun/2018:18:10:37 +0200 "GET /image/thumbnail/155230aiu0/render HTTP/1.1" 200 8130
> Jun/2018:18:10:37 +0200 "GET /image/thumbnail/155231du70/render HTTP/1.1" 200 8192
> Jun/2018:18:10:38 +0200 "GET /image/thumbnail/155232dn90/render HTTP/1.1" 200 8140
> Jun/2018:18:10:38 +0200 "GET /image/thumbnail/155233x3m0/render HTTP/1.1" 200 7880
> Jun/2018:18:10:38 +0200 "GET /image/thumbnail/155234ruf0/render HTTP/1.1" 200 7856
> Jun/2018:18:10:38 +0200 "GET /image/thumbnail/155235rtz0/render HTTP/1.1" 200 7901
> Jun/2018:18:10:38 +0200 "GET /image/thumbnail/1552417o20/render HTTP/1.1" 200 7019
> Jun/2018:18:10:38 +0200 "GET /image/thumbnail/1552364mx0/render HTTP/1.1" 200 7826
> Jun/2018:18:10:38 +0200 "GET /image/thumbnail/1552372i40/render HTTP/1.1" 200 8292
> Jun/2018:18:10:38 +0200 "GET /image/thumbnail/155238bak0/render HTTP/1.1" 200 7869
> Jun/2018:18:10:38 +0200 "GET /image/thumbnail/155244pwi0/render HTTP/1.1" 200 7450
> Jun/2018:18:10:38 +0200 "GET /image/thumbnail/155247jad0/render HTTP/1.1" 200 7015
> Jun/2018:18:10:39 +0200 "GET /image/thumbnail/155251pmy0/render HTTP/1.1" 200 7430
> Jun/2018:18:10:39 +0200 "GET /image/thumbnail/155252xjz0/render HTTP/1.1" 200 8292
> Jun/2018:18:10:39 +0200 "GET /image/thumbnail/155254ibu0/render HTTP/1.1" 200 8548
> Jun/2018:18:10:39 +0200 "GET /image/thumbnail/155255w3n0/render HTTP/1.1" 200 8447
> Jun/2018:18:10:39 +0200 "GET /image/thumbnail/155259s6r0/render HTTP/1.1" 200 7189
> Jun/2018:18:10:39 +0200 "GET /image/thumbnail/155260vfz0/render HTTP/1.1" 200 7902
> Jun/2018:18:10:39 +0200 "GET /image/thumbnail/155257v590/render HTTP/1.1" 200 7356
> Jun/2018:18:10:39 +0200 "GET /image/thumbnail/155262fmn0/render HTTP/1.1" 200 7993
> Jun/2018:18:10:39 +0200 "GET /image/thumbnail/155264fbj0/render HTTP/1.1" 200 7967
> Jun/2018:18:10:40 +0200 "GET /image/thumbnail/155266xtt0/render HTTP/1.1" 200 6956
> Jun/2018:18:10:40 +0200 "GET /image/thumbnail/155267aie0/render HTTP/1.1" 200 7339
> Jun/2018:18:10:40 +0200 "GET /image/thumbnail/1552699gx0/render HTTP/1.1" 200 8068
> Jun/2018:18:10:40 +0200 "GET /image/thumbnail/1552719x80/render HTTP/1.1" 200 8268
> Jun/2018:18:10:40 +0200 "GET /image/thumbnail/1552743ta0/render HTTP/1.1" 200 6943
> Jun/2018:18:10:40 +0200 "GET /image/thumbnail/155276xhi0/render HTTP/1.1" 200 7213
> Jun/2018:18:10:40 +0200 "GET /image/thumbnail/155275ppd0/render HTTP/1.1" 200 7451
> Jun/2018:18:10:40 +0200 "GET /image/thumbnail/155278ocw0/render HTTP/1.1" 200 6816
> Jun/2018:18:10:40 +0200 "GET /image/thumbnail/155279nqi0/render HTTP/1.1" 200 7283
> Jun/2018:18:10:40 +0200 "GET /image/thumbnail/155280a6s0/render HTTP/1.1" 200 7385
> Jun/2018:18:10:41 +0200 "GET /image/thumbnail/155281t3m0/render HTTP/1.1" 200 7452
>
> Range: Jun/2018:18:10:34 - Jun/2018:18:10:41. Total of 7 seconds.
>

-- 
-- Gryzli

https://gryzli.info


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Mime
View raw message