How to install innotop on Microsoft Windows at Xaprb

I recently tested innotop on Microsoft Windows. There was one slight glitch, but I changed a couple lines of code, and now it runs out of the box under ActivePerl. Version 0.1.156 contains those changes for Windows compatibility.

How to install

I installed it under ActivePerl 5.8.8 build 819:

Download and install ActivePerl
After installation, open the Perl Package Manager from Start/Programs/ActivePerl 5.8.8 Build 819. Select Time-HiRes, DBD-mysql, and install them.
Download and extract innotop and run it.

I also watched another person run it under ActivePerl 5.8.7.

That’s it. Here is a screenshot of innotop on Windows XP:

Differences under Windows

If you have term-ansicolor , it is disabled because Windows terminals don’t like the formatting characters. That makes the display a bit less compact, but such is life.

If you have any experience with other ways to run innotop under Windows (cygwin?), please let me know.

My next project is to take a number of samples of SHOW INNODB STATUS from MySQL running under Windows and make sure they’re parsed correctly. I’ve read the source, but reading the source doesn’t mean I’ve done it right. (Update: yep, I did it right).

Update: version 0.1.159 has additional fixes. A new Windows-specific configuration variable, max_height, defines how high the viewable window area is. Otherwise innotop can’t figure out how much space it has to work with. I also fixed the code to work with MySQL 5.1’s new SHOW ENGINE output (there is an extra column in the output).

Update 2006-11-14: version 0.1.160 has more Windows compatibility. An astute Perl hacker showed me how to get ANSI formatting codes to work in a Windows console, which allows bold and highlighted text and a more compact display (so you can get more on the screen). To get this to work, just install Win32::Console::ANSI. Yay!

Technorati Tags:No Tags

You might also like:

Checking if your kit is complete... Looks good Warning: prerequisite InnoDBParser failed to load: Can't locate List/Util.pm in @INC (@INC contains: C:/Perl/lib C:/Perl/site/lib .) at C:/Perl/lib/InnoDBParser.pm line 13. BEGIN failed--compilation aborted at C:/Perl/lib/InnoDBParser.pm line 13. Compilation failed in require at (eval 6) line 3. Warning: prerequisite Term::ReadKey failed to load: Can't locate Term/ReadKey.pm in @INC (@INC contains: C:/Perl/lib C:/Perl/site/lib .) at (eval 7) line 3. Writing Makefile for innotop

2 Responses to “How to install innotop on Microsoft Windows”

Feed for this Entry

1 Muhammad ali

Nov 14th, 2006 at 8:46 am

I am using windowxp. first i tried to install ActivePerl 5.8.8.819 but it failed. then i have installed the active perl 5.6.1.638. i installed DBD-mysql but did not find Time-HiRes. then download the package of innotop-0.1.157. after using the command G:\Installables\innotop-0.1.157>perl Makefile.PL i get the following trace but no innotop screen appears:

can u help me this issue

Thanks
MuhammadAli

2 Xaprb
Nov 14th, 2006 at 12:37 pm
Hi Muhhamad, I wrote you an email directly too, so check your inbox. It sounds like ActivePerl isn’t bundling some libraries that I thought were standard (List::Util, Term::ReadKey). Maybe if you can get the newer version to work, it will help. If you do get 5.6 to work, let me know.

Also, under Windows, the Makefile.PL approach won’t work for installation, as far as I know, unless you have make installed (doubtful). When I ran it on Windows, I just unzipped the archive and ran it directly from the command-line:
```
cd whereinnotopisunpacked
perl innotop
```

Comments are currently closed.

Xaprb