I would propose to split a different way: have a
"analysis" server (few but heavy queries) separate from the "tools"
server (web service, many relatively fast queries). I believe this would
help more to make the server(s) more useful.
this would make more sense with two MySQL instances on a single server
(using separate disks). MySQL itself doesn't use all that much CPU.