install

Additional install commands

macOS

Homebrewverified · 100%

brew install innotop

local Homebrew formula metadata

Linux

Fedora dnfverified · 92%

sudo dnf install innotop

Fedora Rawhide package metadata · innotop · source: dl.fedoraproject.org

openSUSE zypperverified · 92%

sudo zypper install innotop

openSUSE Tumbleweed package metadata · innotop · source: download.opensuse.org

overview

Package summary

Top clone for MySQL

Project links

Commands and aliases

innotop

history

Project history and usage

innotop is a Perl terminal monitor for MySQL, modeled after `top`. The README describes it as customizable, plugin-capable, able to monitor many servers at once, and able to aggregate across them.

Project history

The program source records copyright from 2006 by Baron Schwartz and later maintainers Kenny Gryp and Frederic Descamps from 2013. The README notes that the full project history was imported into GitHub and that the manual is embedded in the program as Perl POD.

The changelog shows the project maturing rapidly during the MySQL 5 era: adding plugin functionality, group-by behavior, richer filtering and sorting, central and per-user configuration files, command-line DSN handling, query dashboards, Percona/MariaDB user statistics, and later compatibility work for MySQL 8, MySQL 9, SSL, Group Replication, and changed replication terminology.

Adoption history

innotop was packaged by Unix distributions early. Its INSTALL file lists FreeBSD, Gentoo, Ubuntu/Debian, and RPM packages via openSUSE Build Service, while Homebrew metadata lists additional Fedora and openSUSE packaging. The package persisted because database operators wanted a fast terminal view into MySQL and InnoDB behavior.

How it is used

Users run `innotop` in a terminal to inspect MySQL queries, transactions, locks, replication, and server health. Connection details can come from command-line DSNs, MySQL option files, prompts, or saved innotop configuration, with credentials potentially stored in the same config paths curated for this package.

Why package nerds care

innotop is a classic ops package: a single Perl program with embedded documentation, DBI/DBD::mysql dependencies, and a long compatibility tail across MySQL, Percona Server, and MariaDB. Its history captures the era when terminal dashboards were the lightest viable database observability stack.

Timeline

2006: Program source records original copyright by Baron Schwartz.
2007: Version 1.5 adds plugin functionality, group-by behavior, and configuration directory changes.
2009: Version 1.7 adds central config support and the default `~/.innotop/innotop.conf` path.
2010: Version 1.8 adds Percona/MariaDB USER_STATISTICS support and query summaries.
2018: Version 1.12 adds MySQL 8.0 support.
2021: Version 1.13 adds SSL support.
2024: Version 1.15 adds Group Replication and new replication terminology support.
2026: Version 1.16 reworks query EXPLAIN compatibility for modern MySQL.

Related projects

Related projects and technologies include MySQL, InnoDB, MariaDB, Percona Server, Perl DBI and DBD::mysql, MySQL option files, and the Unix `top` interface tradition.

Sources

security posture

Risk level: blue

broad file, network, media, or database tool signal.

Risk classifier

blue risk · medium confidence · tool

Why

broad file, network, media, or database tool signal

Signals

text:sql

Install behavior

No Homebrew post-install hook is recorded in formula metadata.
Homebrew bottle metadata is available for 6 platform targets.
Installs with 1 runtime dependencies.

Recommended review

Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.

local files

Configuration and credential file locations

These source-backed paths show where this package keeps local settings or durable credentials. Automic Vault can use them as review targets for secret scanning, migration, and command approval.

Configuration files

Config paths the tool may read or write during local use.

Unix: ~/.innotop/innotop.conf/etc/innotop/innotop.conf

Credential files

Credential-bearing paths to review before unattended agent runs.

Unix: ~/.innotop/innotop.conf/etc/innotop/innotop.conf

executables

Installed executables

Command	Kind	Exposure	Note
`innotop`	cli	global executable

freshness

Version and freshness

These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.

page generated2026-07-25

manager version1.16.0

manager updated2026-06-22

local dataok

upstreamcurrent

latest detectedv1.16.0

https://github.com/innotop/innotop

okNo freshness warnings were generated.

install metadata

Package metadata

Package key	brew:innotop
Version	1.16.0
Package manager	Homebrew
Package manager page	https://formulae.brew.sh/formula/innotop
Homepage	https://github.com/innotop/innotop/
Repository	https://github.com/innotop/innotop
Upstream docs	https://github.com/innotop/innotop#readme
License	GPL-2.0-only OR Artistic-1.0-Perl
Source archive	https://github.com/innotop/innotop/archive/refs/tags/v1.16.0.tar.gz
Last updated	2026-06-22T14:03:47-07:00
Pulse	updated
Dependencies	perl-dbd-mysql
Uses from macOS	perl
Bottle	available (on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux)
Homebrew post-install	not defined
Service	none declared

registry facts

Source database details

Source Database	Homebrew formula API
Tap	homebrew/core
Full Name	innotop
Version Scheme	0
Revision	0
Head Version	HEAD
Bottle Stable Root URL	https://ghcr.io/v2/homebrew/core
Deprecated	no
Disabled	no
Keg Only	no
URL Keys	head stable

source database matches

Other package-manager records

Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.

dnf95%

innotop 1.15.2-4.fc44

A MySQL and InnoDB monitor program

https://github.com/innotop/innotop

sudo dnf install innotop

License: GPL-2.0-only or Artistic-1.0-Perl
Category: Unspecified
Architecture: noarch
Source Package: innotop
2 dependencies
1 provides
normalized package name match
Matched by: Innotop

Fedora Rawhide package metadata · dl.fedoraproject.org · Fedora Rawhide package metadata: innotop from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst

zypper95%

innotop 1.15.2-1.2

A MySQL and InnoDB monitor program

https://github.com/innotop/innotop/

sudo zypper install innotop

License: GPL-2.0-only
Category: Productivity/Databases/Tools
Architecture: noarch
Source Package: innotop
2 dependencies
1 provides
normalized package name match
Matched by: Innotop

openSUSE Tumbleweed package metadata · download.opensuse.org · openSUSE Tumbleweed package metadata: innotop from https://download.opensuse.org/tumbleweed/repo/oss/repodata/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst

package graph

Links come from deterministic package relationships, av.db category and tag curation, ecosystem matches, and package hub membership.

source trail

Generated from repository data

This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.

Combined YAML source

View the package source record on GitHub.

combined/innotop.yml

Used sources

Geiger risk classifier
Nucleus package database
av.db category and tag curation
cross-ecosystem install command graph
curated configuration and credential file locations
curated package history
external package-manager database matches
package relationship graph
package version freshness
package-page enrichment

Install innotop with Homebrew, dnf, zypper