MySQL sleeping connections consuming 120% CPU

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 just in case if you need.