Innotop is a Perl script created to extract important information about the internal functioning of the InnoDB storage engine. Starting from version 5.4, we have information about active transactions, locks, the status of the InnoDB Buffer Pool, etc., through tables added to the MySQL catalog, also known and represented by the information_schema database.
Reading these tables can be an unpleasant and useless task for those who do not have much experience with MySQL. Even worse would be trying to use the show engine InnoDB status. I confess that in the early years of MySQL, the result of this command, to me, looked a lot like the alien signal hidden in satellite frequencies during the Earth invasion in the movie “Independence Day.” Some things intrigued me in this movie: 1) Why was the movie title never translated? 2) How did the “fly man” (Jeff Goldblum) connect to the invaders’ system: Bluetooth or Wi-Fi? 3) Guys, for the love of J. Christ, the invaders had no firewall and still wanted to conquer Earth? No way Jose!
I’ve rambled enough, let’s get back to what matters: installing innotop!
I will assume we will use Linux, out of passion: CentOS. What are the dependencies, the prerequisites for installing innotop?
- PERL
– Run the command below to check if Perl is installed:
perl -v
This is perl, v5.8.8 built for x86_64-linux-thread-multi
Copyright 1987-2006, Larry Wall
Perl may be copied only under the terms of either the Artistic License or the GNU General Public License, which may be found in the Perl 5 source kit.
Complete documentation for Perl, including FAQ lists, should be found on this system using “man perl” or “perldoc perl”. If you have access to the Internet, point your browser at http://www.perl.org/, the Perl Home Page.
In my case, I have Perl v5.8.8 installed. The version does not matter; if you get a message similar to mine, you are ready to continue.
– Run the command below to install Perl if you don’t have it installed:
yum install perl
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Setting up Install Process
Package 4:perl-5.8.8-32.el5_5.2.x86_64 already installed and latest version
Resolving Dependencies
–> Running transaction check
—> Package perl.i386 4:5.8.8-32.el5_5.2 set to be updated
–> Finished Dependency Resolution
Dependencies Resolved
Package Arch Version Repository Size
Installing: perl i38 4:5.8.8-32.el5_5.2 extras 12 M
Transaction Summary
Install 1 Package(s)
Upgrade 0 Package(s)
Total download size: 12 M
Is this ok [y/N]: y
Just confirm with yes and proceed with the installation. It’s worth remembering that yum is the installation command inherent to Red Hat-based distributions, like CentOS in my case. Other distributions might use: apt-get, aptitude, urpmi, pkg-get, etc.
Visit our Blog
Learn more about databases
Learn about monitoring with advanced tools
Have questions about our services? Visit our FAQ
Want to see how we’ve helped other companies? Check out what our clients say in these testimonials!
Discover the History of HTI Tecnologia
