I've always wanted to do this. Well, except the part about being arrested.
"But the fact is, with an initial investment of only $800, in two weeks' time he had a portfolio valued at over $350 million. Every trade he made capitalized on unexpected business developments, which simply can't be pure luck.
Heh.
(Thanks to Andy for the link.)
I've just posted version 1.3 of mytop.
What's new? Here's what the Changes file lists...
Added a "c" command to switch between the thread view and "command summary" view. The command summary pulls the Com_* values from SHOW STATUS and summarizes them. The UI needs work and I welcome feedback on how to improve it.
Fixed various bugs. Added regex support for filters. Added the ability to [K]ill all threads owned by a particular user. Fixed query cache hit rate computation.
Use the value of Com_select rather than Questions to calculate the Qcache ratio. Only SELECT queries are candidates for the cache, so this is far more accurate.
Bug reports, patches, and feature suggestions always welcome. :-)
(Oh, there are likely a few things missing from the docs... Let me know. From now on, I'll try to update the docs sooner after changing the code.)