CPU load has ran at around 0.85 forever, years. Traffic has increased but with cdn, css styles and optimization this box has been rock steady.
When we went to migrate to xF mysql needed to be recompiled with i ? (not a sys admin).
Since then cpu load has been about 4x normal
Mysql has taken up upto 250% of cpu in spikes which is new.
Slow query log showing nothing. The items that were showing up from a pluggin weve had installed for ages has been removed.
Intially we thought "Enable Delayed Insert SQL Queries" was the issue, so the 4 xF sites have had it disabled.
4 quad core cpus - Intel(R) Xeon(R) CPU E5520 @ 2.27GHz
httpd 2.2.24 (Unix)
Server load 8.95 (16 CPUs) as of posting this
NOTE: its using upto 50% cpu at times for this:
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/web2.xxxxxxx.com.pid --skip-external-locking