I run a fairly busy site, mysql uses 100% CPU, and server load a lot of CPU
I need to install a php code accelerator in view to reduce the large number of CPU.
I think it's the extensive user logging feature.
It literally logs every page view a person makes. That takes up an enormous amount of CPU cycles and MySQL storage space.