# Install innotop with Homebrew, dnf, zypper

Top clone for MySQL. Version 1.16.0 via Homebrew; verified 2026-06-22. Also installable with dnf: sudo dnf install innotop.

## Install

```sh
sudo av install brew:innotop
```

Additional install commands:

### macOS

- Homebrew (100%):

```sh
brew install innotop
```

  Evidence: local Homebrew formula metadata

### Linux

- dnf (92%):

```sh
sudo dnf install innotop
```

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

- zypper (92%):

```sh
sudo zypper install innotop
```

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

## Package facts

- **Package key:** brew:innotop
- **Package manager:** Homebrew
- **Package manager page:** <https://formulae.brew.sh/formula/innotop>
- **Version:** 1.16.0
- **Source summary:** Top clone for MySQL
- **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
- **Generated:** 2026-07-25T07:20:51+00:00

## Executables

- innotop (cli)
- innotop (alias)

## Dependencies

- perl-dbd-mysql

## Uses from macOS

- perl

## Install behavior

- Post-install hook: not defined
- Bottle: available on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux

## Freshness

- Page generated: 2026-07-25
- Package-manager version: 1.16.0
- Package-manager updated: 2026-06-22
- Local data: ok
- Upstream repository: https://github.com/innotop/innotop
- Upstream latest detected: v1.16.0 (current)
## 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

- <https://formulae.brew.sh/formula/innotop>
- <https://github.com/innotop/innotop>
- <https://raw.githubusercontent.com/innotop/innotop/master/Changelog>
- <https://raw.githubusercontent.com/innotop/innotop/master/INSTALL>
- <https://raw.githubusercontent.com/innotop/innotop/master/README.md>
- <https://raw.githubusercontent.com/innotop/innotop/master/innotop>


## Security Notes

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

- **Geiger risk:** blue / medium
- broad file, network, media, or database tool signal


## 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

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

## Credential files

- Unix: ~/.innotop/innotop.conf, /etc/innotop/innotop.conf
## 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

## Other Package-Manager Records

- dnf - innotop - 1.15.2-4.fc44: normalized package name match | Fedora Rawhide package metadata: innotop from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst | A MySQL and InnoDB monitor program | https://github.com/innotop/innotop
- zypper - innotop - 1.15.2-1.2: normalized package name match | openSUSE Tumbleweed package metadata: innotop from https://download.opensuse.org/tumbleweed/repo/oss/repodata/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst | A MySQL and InnoDB monitor program | https://github.com/innotop/innotop/


## Related links

- [Source-control packages](https://www.automicvault.com/pkg/source-control-tools/) - Belongs to a source-control command family.
- [Secret-risk packages](https://www.automicvault.com/pkg/secret-risk-packages/) - Has protected-tool coverage, approval-gate, or non-low Geiger security signals.
- [Terminal utility packages](https://www.automicvault.com/pkg/terminal-utilities/) - Matched terminal and command-line workflow metadata.
- [Text processing packages](https://www.automicvault.com/pkg/text-processing-tools/) - Matched text, document, or structured-data processing metadata.
- [dolphie](https://www.automicvault.com/pkg/brew/dolphie/) - Shares av.db curated category or tags: cli, data, database-monitoring, mysql.
- [rainfrog](https://www.automicvault.com/pkg/brew/rainfrog/) - Shares av.db curated category or tags: cli, data, mysql, terminal.
- [automysqlbackup](https://www.automicvault.com/pkg/brew/automysqlbackup/) - Shares av.db curated category or tags: cli, data, mysql.
- [csvlens](https://www.automicvault.com/pkg/brew/csvlens/) - Shares av.db curated category or tags: cli, data, terminal.
- [distribution](https://www.automicvault.com/pkg/brew/distribution/) - Shares av.db curated category or tags: cli, data, terminal.
- [dumpling](https://www.automicvault.com/pkg/brew/dumpling/) - Shares av.db curated category or tags: cli, data, mysql.
- [geni](https://www.automicvault.com/pkg/brew/geni/) - Shares av.db curated category or tags: cli, data, mysql.
- [gh-ost](https://www.automicvault.com/pkg/brew/gh-ost/) - Shares av.db curated category or tags: cli, data, mysql.

## Combined YAML source

View the package source record on GitHub. [combined/innotop.yml](https://github.com/automic-vault/db/blob/main/combined/innotop.yml)


## Sources

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