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-unsubscr...@httpd.apache.org
For additional commands, e-mail: users-h...@httpd.apache.org
