Upcoming innotop featuresWed, Dec 13, 2006 in Databases Open Source
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.
I'm Baron Schwartz, the founder and CEO of VividCortex. I am the author of High Performance MySQL and many open-source tools for performance analysis, monitoring, and system administration. I contribute to various database communities such as Oracle, PostgreSQL, Redis and MongoDB.