I’m running a Wordpress-Woocommerce website on a VPS. My VPS configuration is as below:
- 4 Core CPU
- 8 GB RAM
- 40 GB NVMe
I’m running CentOS 7 + Cyberpanel + Openlitespeed Server + QUIC CDN + MariaDB.
- PHP version: 8.1
- MariaDB version 10.4.32
My CPU usage is always on the peak as shown below.
I tried running top command, and I found mysqld is consuming too much CPU as seen below.
I ran SHOW PROCESSLIST; from phpmyadmin and found the following.
Now I’m stuck here. I tried googling a lot but I don’t understand how to overcome this.
Please help. Thanks in advance.
My website is https://www.wellshot.in just in case if you need.