It’s been a while since I released an update to the innotop InnoDB and MySQL monitor, but I have not been idle. I’m currently working hard to add major new features and functionality. Here’s a quick list of what’s coming, much of which is done already but still slightly broken:
- Arbitrary user-defined expressions can be the source of a column in a tabular view. You are not limited to choosing from the columns I’ve defined; you can add your own, and base it directly on the available data or write an expression to calculate what you want.
- Connect to and monitor multiple servers simultaneously.
- More powerful filtering to show only the data you care about. Built-in filters are applied by default, but you can define your own of course.
- Highlighting based on user-defined criteria. Maybe you want a transaction to appear red if it has been active for more than a minute, or you want queries running on different servers to have different colors.
- Easily monitor replication across many machines; watch master and slave status.
- Readline support for easier configuration (tab-completion, etc).
Those are just the major features. Many of you have requested features by e-mail, and I’m either building those now, or they’re in the TODO list.
Many of these features require gutting and re-building significant portions of the code (For example, going from one to many servers is a complete paradigm change. Most of what I’m doing right now is cleaning up the mess that caused). I’m not sure how to do some of the planned changes, but a few weeks ago I didn’t know how I’d handle multiple servers. I’m sure it will all come to me.
If you have specific requests, please be sure to ask! I’ll get you started: would it be helpful to monitor NDB status on many machines at once, if you run a large NDB cluster? I personally don’t monitor any such clusters, so this isn’t an itch I’ve scratched, but it would be very little work for me to transform that ugly semicolon-separated stuff into a nice tabular display.
My current TODO list should be finished up in a month or so, and then I’ll release a new version. Right now I’m going to take a little break from programming and blogging, so I’ll read and reply to your comments when I return.
Technorati Tags:No Tags
Many thanks for this cool tool! Finally found an alternative to mytop (Jeremy forgot it long long time ago :).
Anyways, I have one request for innotop (since you’re already in a deep developement :). I have a huge table with blob row where the text is gzipped with php before storing it. Queries to store the information are very common, so they’re in the list often too. The problem is that queries contain very random bits of binary cuss-words (like “D?\”)??)?VRš??)j?5;??@?\”?d”) and innotop tends to be very angry about it suggesting me to “Dumping current info” and “Enter a filename:” :).
Could it be possible to somehow identify and convert the binary data in queries into something more human and innotop readable (like “protected binnary data”) so it would not take these bits as commands to itself? As far as I know, this is a terminal related issue, still if I use linux terminal instead of PuTTY (which is my default), I have to reset the terminal very offten..
Thanks!
// Aurimas
That’s a great idea and I’ll definitely try to do that. I already remove newlines, but didn’t consider removing other “stuff.” I’ll have to see how hard it is to do this without obliterating valid Unicode characters. Maybe I should only allow ASCII through since many terminals don’t do Unicode anyway. Hmmm.