Just moved my Joomla site to a dedicated Linux server, but the site performance is not good. There are mysql queries as below hanging there and accumulate to very high CPU usages.
Pid 1834
Owner mysql
Priority 0
Cpu % 33.9
Mem % 12.8
Command
/usr/sbin/mysqld –basedir=/ –datadir=/var/lib/mysql –user=mysql –log-error=/var/lib/mysql/sumsale.sumsale.com.err –open-files-limit=33628 –pid-file=/var/lib/mysql/sumsale.sumsale.com.pid
Once the process is killed, the site speeds up. but it shows up immediately and accumulates again. Need to find the reason, fix the issue and improve the site performance.
The site uses a subdomain and multisite strcture. URL of the site: www.sumsale.com, and one of the subsites: wcm.sumsale.com