XF 2.0 MySQL high CPU usage since upgrade

JOGARA

New member
Any of the staff have any ideas?
It is not a slow server. Dual Skylake 2GHz CPUs with plenty of RAM.

Using cPanel for management and I moved to MariaDB 10.3 the other day and still have the same issue.
 

Mike

XenForo developer
Staff member
You'd probably need to look at the process list to see the queries that are running, as presumably there are ones taking some time.

Beyond that, you may need to make sure that your MySQL configuration is tuned, particularly for InnoDB workloads:

 
Top