Keywords: WordPress - AWS - Technical issue - Other
Description:
Hi Guys,
Need help understanding what the issue is with the "mysqld.bin" process constantly running at 150% to 200% CPU usage.
The site had no issues until about a week or so, before was running fine.
I have a LAMP Bitnami configuration on AWS EC2
I've already gone thru similar threads here and tried a few things but to no avail.
I've also followed the troubleshooting guides offered by bitnatmi docs.
I'm pasting the outputs here.
Please guide me to fix this issue.
# ps -e -orss=,args= | sort -b -k1,1n | pr -TW$COLUMNS
Output:
112 /sbin/iscsid
164 /sbin/mdadm --monitor --pid-file /run/mdadm/monitor.pid --daemonise --scan --syslog
680 pr -TW167
720 sort -b -k1,1n
1220 /sbin/lvmetad -f
1312 /usr/sbin/acpid
1476 ps -e -orss=,args=
1704 /bin/sh /opt/bitnami/mysql/bin/mysqld_safe --defaults-file=/opt/bitnami/mysql/my.cnf --mysqld=mysqld.bin --socket=/opt/bitnami/mysql/tmp/mysql.sock --datadir=/op
1960 /usr/sbin/atd -f
2000 (sd-pam)
2372 /lib/systemd/systemd-timesyncd
2708 /usr/bin/lxcfs /var/lib/lxcfs/
2752 /usr/sbin/cron -f
2784 /sbin/dhclient -1 -v -pf /run/dhclient.eth0.pid -lf /var/lib/dhcp/dhclient.eth0.leases -I -df /var/lib/dhcp/dhclient6.eth0.leases eth0
2840 /usr/sbin/rsyslogd -n
2892 /lib/systemd/systemd-logind
3048 /usr/bin/dbus-daemon --system --address=systemd: --nofork --nopidfile --systemd-activation
3132 /lib/systemd/systemd --user
3212 /usr/sbin/sshd -D
3244 /lib/systemd/systemd-udevd
3356 /lib/systemd/systemd-journald
3508 /sbin/iscsid
4084 /usr/lib/policykit-1/polkitd --no-debug
4320 /usr/bin/gonit
4552 /usr/lib/accountsservice/accounts-daemon
4596 /sbin/init
4744 /usr/sbin/haveged --Foreground --verbose=1 -w 1024
4752 sshd: ubuntu@pts/0
4808 sshd: ubuntu [priv]
5328 -bash
6148 /snap/amazon-ssm-agent/1480/amazon-ssm-agent
9640 php-fpm: master process (/opt/bitnami/php/etc/php-fpm.conf)
13700 /usr/bin/python3 /usr/share/unattended-upgrades/unattended-upgrade-shutdown --wait-for-signal
14156 /usr/lib/snapd/snapd
37632 /opt/bitnami/apache2/bin/httpd.bin -f /opt/bitnami/apache2/conf/httpd.conf -DDISABLE_BANNER
46708 /opt/bitnami/apache2/bin/httpd.bin -f /opt/bitnami/apache2/conf/httpd.conf -DDISABLE_BANNER
52788 php-fpm: pool wordpress
52804 /opt/bitnami/apache2/bin/httpd.bin -f /opt/bitnami/apache2/conf/httpd.conf -DDISABLE_BANNER
52992 php-fpm: pool wordpress
54168 php-fpm: pool wordpress
57380 php-fpm: pool wordpress
58508 php-fpm: pool wordpress
59172 /opt/bitnami/apache2/bin/httpd.bin -f /opt/bitnami/apache2/conf/httpd.conf -DDISABLE_BANNER
62540 /opt/bitnami/apache2/bin/httpd.bin -f /opt/bitnami/apache2/conf/httpd.conf -DDISABLE_BANNER
438516 /opt/bitnami/mysql/bin/mysqld.bin --defaults-file=/opt/bitnami/mysql/my.cnf --basedir=/opt/bitnami/mysql --datadir=/opt/bitnami/mysql/data --plugin-dir=/opt/bit
# ps -e -o pcpu,nice,state,cputime,args --sort -pcpu | head -10
Output:-
%CPU NI S TIME COMMAND
99.0 0 S 00:01:04 /opt/bitnami/mysql/bin/mysqld.bin --defaults-file=/opt/bitnami/mysql/my.cnf --basedir=/opt/bitnami/mysql --datadir=/opt/bitnami/mysql/data --plugin-dir=/opt/bitnami/mysql/lib/plugin --user=mysql --lower-case-table-names=1 --log-error=/opt/bitnami/mysql/data/mysqld.log --pid-file=/opt/bitnami/mysql/data/mysqld.pid --socket=/opt/bitnami/mysql/tmp/mysql.sock --port=3306
0.1 0 S 00:00:04 php-fpm: pool wordpress
0.1 0 S 00:00:03 php-fpm: pool wordpress
0.1 0 S 00:00:03 php-fpm: pool wordpress
0.1 0 S 00:00:03 php-fpm: pool wordpress
0.1 0 S 00:00:00 /opt/bitnami/apache2/bin/httpd.bin -f /opt/bitnami/apache2/conf/httpd.conf -DDISABLE_BANNER
0.0 0 S 00:00:08 /sbin/init
0.0 0 S 00:00:00 [kthreadd]
0.0 0 S 00:00:05 [ksoftirqd/0]
# df -ih
Output:
Filesystem Inodes IUsed IFree IUse% Mounted on
udev 248K 322 248K 1% /dev
tmpfs 250K 413 250K 1% /run
/dev/xvda1 5.5M 251K 5.3M 5% /
tmpfs 250K 1 250K 1% /dev/shm
tmpfs 250K 3 250K 1% /run/lock
tmpfs 250K 16 250K 1% /sys/fs/cgroup
/dev/loop1 15 15 0 100% /snap/amazon-ssm-agent/1480
/dev/loop0 15 15 0 100% /snap/amazon-ssm-agent/1455
/dev/loop2 13K 13K 0 100% /snap/core/7917
/dev/loop3 13K 13K 0 100% /snap/core/7713
tmpfs 250K 4 250K 1% /run/user/1000
Appreciate all the help I can get.
Thank you.