Stay Curious!

Upcoming innotop features

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:

  1. 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.
  2. Connect to and monitor multiple servers simultaneously.
  3. 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.
  4. 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.
  5. Easily monitor replication across many machines; watch master and slave status.
  6. 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.

Posted on Wed, Dec 13, 2006. Approximately 400 Words.

Databases Open Source