XF 2.0 MySQL high CPU usage since upgrade

[JOGARA]

Since upgrading to the latest release, MySQL has been pegged at 100%.
Anyone else?

 

[JOGARA]

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]

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:

InnoDB Performance Optimization Basics

These InnoDB performance optimizations work well for a wide range of applications, though the optimal settings do depend on the workload.

www.percona.com