Interesting concept, but REAL TIME, is it necessary? One could argue that users would see an increased slow down due to constant processing being needed on the server. Then there's the I/O of reading/writing to the disk and then hogging the ethernet port to send the data out to a central monitoring system. How big is that pipe on the central server that they can monitor everything in one place?
We use Nagios, and it does CPU, Memory and Disk usage for us, but it's delayed - maybe 5 minutes. cPanel comes with Munin as part of their Plugins section, and it's very useful for reviewing and charting usage on an individual server level.
As for not knowing what task MySQl is runing - installed "mytop" - we use it daily, and it's easy to see who is using what resources.
Stopping processes (killing them) is currently the only method in stopping out of control tasks. I'm interested to see what their "slow down" method consists of.
Sure sounds interesting though, but I'd hate to be the guy having to do real time monitoring on 1000's of servers and 100,000+ accounts. Sometimes too much data is just that - too much!