Website loading very slow

ansarul 2018-10-08 20:30:00 UTC #1

Keywords: WordPress - Amazon Web Services - Technical issue - Other
Description:
I have migrated one website aws ec2 intense after that server responding very slow please check my error log let me know how i can solve the issue

[Mon Oct 08 18:26:06.847081 2018] [ssl:warn] [pid 2167:tid 140691376637696] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Mon Oct 08 18:26:06.942107 2018] [ssl:warn] [pid 2180:tid 140691376637696] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Mon Oct 08 18:26:06.984404 2018] [mpm_event:notice] [pid 2180:tid 140691376637696] AH00489: Apache/2.4.34 (Unix) OpenSSL/1.0.2o configured -- resuming normal operations
[Mon Oct 08 18:26:06.984437 2018] [core:notice] [pid 2180:tid 140691376637696] AH00094: Command line: '/opt/bitnami/apache2/bin/httpd.bin -f /opt/bitnami/apache2/conf/httpd.conf'
[Mon Oct 08 19:00:43.605128 2018] [pagespeed:warn] [pid 4537:tid 140690822416128] [mod_pagespeed 1.13.35.2-0 @4537] Failed to read cache clean timestamp /opt/bitnami/apache2/var/cache/mod_pagespeed/!clean!time!. Doing an extra cache clean to be safe.
[Mon Oct 08 19:44:01.076972 2018] [proxy_fcgi:error] [pid 4537:tid 140690839201536] [client 1.186.185.244:5109] AH01071: Got error 'PHP message: The WC_Cart::get_cart_url function is deprecated since version 2.5. Replace with wc_get_cart_url.\n', referer: http://13.236.179.25/
[Mon Oct 08 19:44:33.776045 2018] [proxy_fcgi:error] [pid 4537:tid 140690629383936] [client 204.187.14.77:58452] AH01071: Got error 'PHP message: The WC_Cart::get_cart_url function is deprecated since version 2.5. Replace with wc_get_cart_url.\n', referer: http://www.directshoeoutlet.com/
[Mon Oct 08 19:51:40.481266 2018] [proxy_fcgi:error] [pid 4537:tid 140690662954752] [client 66.249.83.74:61648] AH01071: Got error 'PHP message: The WC_Cart::get_cart_url function is deprecated since version 2.5. Replace with wc_get_cart_url.\n', referer: http://www.directshoeoutlet.com/
[Mon Oct 08 19:52:48.895110 2018] [proxy_fcgi:error] [pid 4537:tid 140690855986944] [client 66.102.7.138:56895] AH01071: Got error 'PHP message: The WC_Cart::get_cart_url function is deprecated since version 2.5. Replace with wc_get_cart_url.\n', referer: http://www.directshoeoutlet.com/
[Mon Oct 08 19:52:55.725942 2018] [proxy_fcgi:error] [pid 2205:tid 140690981877504] [client 66.249.83.72:39737] AH01071: Got error 'PHP message: The WC_Cart::get_cart_url function is deprecated since version 2.5. Replace with wc_get_cart_url.\n', referer: http://www.directshoeoutlet.com/
[Mon Oct 08 19:54:48.533383 2018] [proxy_fcgi:error] [pid 2205:tid 140690662954752] [client 66.249.81.226:42078] AH01071: Got error 'PHP message: The WC_Cart::get_cart_url function is deprecated since version 2.5. Replace with wc_get_cart_url.\n', referer: http://www.directshoeoutlet.com/
[Mon Oct 08 19:55:29.583466 2018] [proxy_fcgi:error] [pid 4537:tid 140690763667200] [client 66.249.93.34:43158] AH01071: Got error 'PHP message: The WC_Cart::get_cart_url function is deprecated since version 2.5. Replace with wc_get_cart_url.\n', referer: http://www.directshoeoutlet.com/
[Mon Oct 08 19:56:42.684090 2018] [proxy_fcgi:error] [pid 2205:tid 140690923128576] [client 66.249.93.62:64066] AH01071: Got error 'PHP message: The WC_Cart::get_cart_url function is deprecated since version 2.5. Replace with wc_get_cart_url.\n', referer: http://www.directshoeoutlet.com/
[Mon Oct 08 20:07:32.681966 2018] [mpm_event:notice] [pid 2180:tid 140691376637696] AH00491: caught SIGTERM, shutting down
[Mon Oct 08 20:07:58.880440 2018] [ssl:warn] [pid 10965:tid 140602570319616] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Mon Oct 08 20:07:58.930181 2018] [ssl:warn] [pid 10966:tid 140602570319616] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Mon Oct 08 20:07:58.953060 2018] [mpm_event:notice] [pid 10966:tid 140602570319616] AH00489: Apache/2.4.34 (Unix) OpenSSL/1.0.2o configured -- resuming normal operations
[Mon Oct 08 20:07:58.953102 2018] [core:notice] [pid 10966:tid 140602570319616] AH00094: Command line: '/opt/bitnami/apache2/bin/httpd.bin -f /opt/bitnami/apache2/conf/httpd.conf -D DISABLE_BANNER'
[Mon Oct 08 20:08:37.804393 2018] [proxy_fcgi:error] [pid 11110:tid 140602205243136] [client 1.186.185.244:15241] AH01071: Got error 'PHP message: The WC_Cart::get_cart_url function is deprecated since version 2.5. Replace with wc_get_cart_url.\n', referer: http://13.236.179.25/
[Mon Oct 08 20:09:06.261036 2018] [proxy_fcgi:error] [pid 10975:tid 140602339915520] [client 204.187.14.72:58452] AH01071: Got error 'PHP message: The WC_Cart::get_cart_url function is deprecated since version 2.5. Replace with wc_get_cart_url.\n', referer: http://www.directshoeoutlet.com/
[Mon Oct 08 20:21:38.791928 2018] [mpm_event:notice] [pid 10966:tid 140602570319616] AH00491: caught SIGTERM, shutting down
[Mon Oct 08 20:22:04.991985 2018] [ssl:warn] [pid 11626:tid 140402841364224] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Mon Oct 08 20:22:05.049558 2018] [ssl:warn] [pid 11627:tid 140402841364224] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Mon Oct 08 20:22:05.073895 2018] [mpm_event:notice] [pid 11627:tid 140402841364224] AH00489: Apache/2.4.34 (Unix) OpenSSL/1.0.2o configured -- resuming normal operations
[Mon Oct 08 20:22:05.073943 2018] [core:notice] [pid 11627:tid 140402841364224] AH00094: Command line: '/opt/bitnami/apache2/bin/httpd.bin -f /opt/bitnami/apache2/conf/httpd.conf -D DISABLE_BANNER'

andresrc 2018-10-09 10:06:36 UTC #2

Hi @ansarul,

Thanks for using Bitnami. We have a Support Tool that will gather relevant information for us to debug the issue. Could you please download and execute it on the machine where the stack is running by following the steps described in the guide below? You must click on the platform or cloud that you are using to find the correct instructions.

How to Run the Bitnami Support Tool

Please note that you need to paste the code outputted by the tool in your reply.

Please also run the following command and provide the output:

sudo top -b -n 5 -d 5

Regards,

Andres R.

ansarul 2018-10-12 19:09:18 UTC #3

Hi @andresrc

Please check the out put
bitnami@ip-172-31-6-137:~$ sudo top -b -n 5 -d 5
top - 19:08:04 up 4 days, 42 min, 1 user, load average: 5.27, 4.83, 4.77
Tasks: 125 total, 2 running, 123 sleeping, 0 stopped, 0 zombie
%Cpu(s): 6.4 us, 1.1 sy, 0.9 ni, 83.5 id, 0.1 wa, 0.0 hi, 0.0 si, 7.9 st
KiB Mem : 1014500 total, 84492 free, 606732 used, 323276 buff/cache
KiB Swap: 649996 total, 598592 free, 51404 used. 145844 avail Mem

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
25078 mysql 20 0 1018672 189368 9876 S 70.6 18.7 2:47.55 mysqld.bin
25270 daemon 20 0 339168 134076 66460 R 23.5 13.2 1:18.99 .php-fpm.bin
1 root 20 0 38052 4164 2896 S 0.0 0.4 0:05.20 systemd
2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthreadd
3 root 20 0 0 0 0 S 0.0 0.0 0:12.50 ksoftirqd/0
5 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/0:0H
7 root 20 0 0 0 0 S 0.0 0.0 0:16.82 rcu_sched
8 root 20 0 0 0 0 S 0.0 0.0 0:00.00 rcu_bh
9 root rt 0 0 0 0 S 0.0 0.0 0:00.00 migration/0
10 root rt 0 0 0 0 S 0.0 0.0 0:01.52 watchdog/0
11 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kdevtmpfs
12 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 netns
13 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 perf
14 root 20 0 0 0 0 S 0.0 0.0 0:00.00 xenwatch
15 root 20 0 0 0 0 S 0.0 0.0 0:00.00 xenbus
17 root 20 0 0 0 0 S 0.0 0.0 0:00.14 khungtaskd
18 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 writeback
19 root 25 5 0 0 0 S 0.0 0.0 0:00.00 ksmd
20 root 39 19 0 0 0 S 0.0 0.0 0:06.61 khugepaged
21 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 crypto
22 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kintegrityd
23 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
24 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kblockd
25 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ata_sff
26 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 md
27 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 devfreq_wq
30 root 20 0 0 0 0 S 0.0 0.0 0:06.24 kswapd0
31 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 vmstat
32 root 20 0 0 0 0 S 0.0 0.0 0:00.00 fsnotify_ma+
33 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ecryptfs-kt+
49 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kthrotld
50 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
51 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
52 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
53 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
54 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
55 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
56 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
57 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
58 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
59 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
60 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
61 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
62 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
63 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
64 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
65 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
66 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
67 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
68 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
69 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
70 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
71 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
72 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
73 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
74 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
75 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 scsi_tmf_0
76 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
77 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 scsi_tmf_1
82 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ipv6_addrco+
83 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
96 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 deferwq
248 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 raid5wq
279 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
300 root 20 0 0 0 0 S 0.0 0.0 0:02.13 jbd2/xvda1-8
301 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-rsv-co+
360 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 iscsi_eh
366 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ib_addr
368 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ib_mcast
369 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ib_nl_sa_wq
370 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ib_cm
371 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 iw_cm_wq
372 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 rdma_cm
376 root 0 -20 0 0 0 S 0.0 0.0 0:01.03 kworker/0:1H
400 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kauditd
426 root 20 0 102968 560 516 S 0.0 0.1 0:00.00 lvmetad
453 root 20 0 42288 1708 1612 S 0.0 0.2 0:00.26 systemd-ude+
456 root 20 0 12204 1696 1576 S 0.0 0.2 0:08.66 haveged
458 root 20 0 28352 2084 1944 S 0.0 0.2 0:01.96 systemd-jou+
480 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 loop0
484 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 loop1
549 systemd+ 20 0 100324 1084 952 S 0.0 0.1 0:00.27 systemd-tim+
927 root 20 0 16120 2240 1888 S 0.0 0.2 0:00.11 dhclient
1092 root 20 0 5220 56 0 S 0.0 0.0 0:07.86 iscsid
1093 root 10 -10 5720 3512 2428 S 0.0 0.3 0:38.33 iscsid
1103 root 20 0 29008 1988 1820 S 0.0 0.2 0:00.44 cron
1105 daemon 20 0 26044 1528 1444 S 0.0 0.2 0:00.00 atd
1108 message+ 20 0 42892 1328 1108 S 0.0 0.1 0:00.26 dbus-daemon
1119 root 20 0 4396 1144 1144 S 0.0 0.1 0:00.00 acpid
1122 syslog 20 0 260628 864 784 S 0.0 0.1 0:00.28 rsyslogd
1131 root 20 0 28616 2328 2172 S 0.0 0.2 0:00.26 systemd-log+
1134 root 20 0 275848 2340 2000 S 0.0 0.2 0:04.95 accounts-da+
1141 root 20 0 636492 2288 1108 S 0.0 0.2 0:05.56 lxcfs
1147 root 20 0 65508 2368 2260 S 0.0 0.2 0:00.34 sshd
1191 root 20 0 13372 120 0 S 0.0 0.0 0:00.02 mdadm
1220 root 20 0 277088 2008 1596 S 0.0 0.2 0:00.01 polkitd
2368 root 0 -20 0 0 0 S 0.0 0.0 0:00.10 loop2
2476 root 20 0 231632 13568 4952 S 0.0 1.3 0:17.81 snapd
2650 root 0 -20 0 0 0 S 0.0 0.0 0:00.04 loop3
2760 root 20 0 282132 5388 4108 S 0.0 0.5 0:05.59 amazon-ssm-+
3880 root 20 0 14388 1492 244 S 0.0 0.1 0:03.90 gonit
10213 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 xfsalloc
10214 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 xfs_mru_cac+
10368 bitnami 20 0 45144 1856 1856 S 0.0 0.2 0:00.01 systemd
10373 bitnami 20 0 63576 260 0 S 0.0 0.0 0:00.00 (sd-pam)
14238 root 20 0 0 0 0 S 0.0 0.0 0:03.82 kworker/0:2
24225 root 20 0 0 0 0 S 0.0 0.0 0:00.20 kworker/u30+
24344 root 20 0 0 0 0 S 0.0 0.0 0:00.04 kworker/u30+
24361 root 20 0 92792 6592 5716 S 0.0 0.6 0:00.04 sshd
24364 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/0:0
24374 bitnami 20 0 92792 3312 2432 S 0.0 0.3 0:00.04 sshd
24375 bitnami 20 0 22692 4796 3260 S 0.0 0.5 0:00.35 bash
24747 root 20 0 4504 1592 1592 S 0.0 0.2 0:00.04 mysqld_safe
25120 root 20 0 271180 11220 5620 S 0.0 1.1 0:00.00 .php-fpm.bin
25121 daemon 20 0 312652 107708 64636 S 0.0 10.6 0:31.24 .php-fpm.bin
25127 root 20 0 205664 37936 34068 S 0.0 3.7 0:00.82 httpd.bin
25135 daemon 20 0 1273364 16484 9196 S 0.0 1.6 0:00.24 httpd.bin
25136 daemon 20 0 1343176 76988 33792 S 0.0 7.6 0:07.85 httpd.bin
25271 daemon 20 0 1320908 118364 35200 S 0.0 11.7 0:31.60 httpd.bin
25339 daemon 20 0 312124 106432 63028 S 0.0 10.5 0:28.33 .php-fpm.bin
25346 daemon 20 0 308700 98184 56224 S 0.0 9.7 0:17.35 .php-fpm.bin
25348 daemon 20 0 305520 100996 63516 S 0.0 10.0 0:34.51 .php-fpm.bin
25359 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/u30+
25360 root 20 0 54772 3840 3376 S 0.0 0.4 0:00.07 sudo
25361 root 20 0 41668 3556 3044 R 0.0 0.4 0:00.04 top

andresrc 2018-10-15 07:59:49 UTC #4

Hi @ansarul,

It seems mysql is consuming most of the resource. That may be related to having less resources than needed or queries that are consuming more resources that expected (e.g. missing indexes).

This post explains how to enable the slow log query in MySQL, which can be useful in these cases.

Regards,

Andres R.

ansarul 2018-10-15 08:22:50 UTC #5

Hi @andresrc

I checked the reference post but the link not woking
https://docs.bitnami.com/installer/apps/#how-to-connect-to-the-mysql-database

Can you help me with the correct link

andresrc 2018-10-15 09:57:09 UTC #6

Hi @ansarul,

Ups, yes, the documentation site changed since that post was published. Some relevant links:

Regards,

Andres R.

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!