LinuxCommandLibrary
GitHubF-DroidGoogle Play Store

dolphie

MySQL/MariaDB/ProxySQL real-time monitoring TUI

TLDR

Connect to MySQL server and monitor
$ dolphie -u [username] --ask-pass -h [host]
copy
Connect using a URI
$ dolphie mysql://[user]:[pass]@[host]:[port]
copy
Connect using a configuration file
$ dolphie -c [config.ini]
copy
Monitor ProxySQL instance
$ dolphie --host [host] --port 6032 -u [user] --ask-pass
copy
Auto-refresh every 2 seconds
$ dolphie -r 2 -h [host] -u [user]
copy
Read credentials from a MySQL config file
$ dolphie -m ~/.my.cnf -h [host]
copy
Record a session for later replay
$ dolphie -R -h [host] -u [user]
copy

SYNOPSIS

dolphie [options] [uri]

DESCRIPTION

dolphie is a real-time terminal user interface for monitoring MySQL, MariaDB, and ProxySQL. It shows dashboards, graphs, processlists, replication status, lock waits, transactions, and resource usage, similar in spirit to mytop and innotop but built on a modern TUI framework.Beyond live monitoring, dolphie can record a session to disk and replay it later, run in daemon mode to collect metrics continuously, and aggregate multiple hosts via hostgroups.

PARAMETERS

-u, --user USERNAME

Database username.
-p, --password PASSWORD
Database password. Prefer --ask-pass or a config file to avoid leaking through shell history.
--ask-pass
Prompt for the password interactively.
-h, --host HOST
Database host (default: localhost).
-P, --port PORT
Database port (default: 3306; 6032 for ProxySQL).
-S, --socket SOCKET
Unix socket file path.
-c, --config-file FILE
Path to a Dolphie configuration file.
-m, --mycnf-file FILE
MySQL-style config file to read credentials from.
-l, --login-path NAME
Login path from `~/.mylogin.cnf`.
-C, --cred-profile NAME
Named credential profile defined in the Dolphie config file.
-r, --refresh-interval SECONDS
Data collection cycle (default: 1).
--panels LIST
Comma-separated panels to display at startup (dashboard, processlist, graphs, replication, ...).
--graph-marker MARKER
Style used for graph markers (default: braille).
--ssl-mode MODE
REQUIRED, VERIFYCA, or VERIFYIDENTITY.
--ssl-ca FILE
SSL CA certificate file.
--ssl-cert FILE
SSL client certificate file.
--ssl-key FILE
SSL client private key file.
-H, --hostgroup NAME
Connect to a group of hosts defined in the config.
--heartbeat-table TABLE
pt-heartbeat table reference (MySQL only) for replication lag.
-R, --record
Record the session to disk for later replay.
-D, --daemon
Run headless in daemon mode; recording is enabled automatically.
--replay-file FILE
Replay a previously recorded session.
--show-trxs-only
Filter the processlist to active transactions only.
-V, --version
Display version and exit.
--help
Display help and exit.

CAVEATS

Requires the PROCESS, REPLICATION CLIENT and (for KILL) SUPER privileges on MySQL. Continuous polling at a very low refresh interval can add load to the monitored server. Passing -p on the command line exposes the password in `ps` and shell history: prefer --ask-pass, a config file, or a login path.

HISTORY

dolphie was created by Charles Thompson as a modern, Python-based replacement for mytop and innotop, with first-class support for MySQL 8, MariaDB, and ProxySQL, and features such as recording, daemon mode, and SSL/TLS connections.

SEE ALSO

mysql(1), mytop(1), htop(1)

Copied to clipboard
Kai