dolphie
MySQL/MariaDB/ProxySQL real-time monitoring TUI
TLDR
SYNOPSIS
dolphie [options]
DESCRIPTION
dolphie is a real-time monitoring tool for MySQL, MariaDB, and ProxySQL databases. It provides a terminal user interface (TUI) dashboard showing key performance metrics, process lists, replication status, and query statistics.
The tool displays information similar to top or htop but specifically designed for database monitoring, including active connections, slow queries, lock waits, and resource usage.
PARAMETERS
-u, --user USERNAME
Database username-p, --password PASSWORD
Database password-h, --host HOST
Database host (default: localhost)-P, --port PORT
Database port (default: 3306)-S, --socket SOCKET
Unix socket file path-c, --config FILE
Configuration file path--proxysql
Connect to ProxySQL instead of MySQL/MariaDB--refresh-interval SECONDS
Dashboard refresh interval (default: 1)--show-processlist
Show processlist by default--use-certificates
Use SSL certificates for connection--ssl-ca FILE
SSL CA certificate file--ssl-cert FILE
SSL client certificate file--ssl-key FILE
SSL client key file-v, --version
Display version and exit--help
Display help and exit
KEYBINDINGS
q
Quitp
Toggle processlist viewl
Toggle lock viewr
Toggle replication views
Change sort column in processlistk
Kill a process (enter PID)?
Show help
CAVEATS
Requires appropriate database privileges (PROCESS, SUPER, REPLICATION CLIENT). Connection credentials must be kept secure. Continuous querying may impact database performance. SSL certificates must be properly configured for secure connections.
HISTORY
dolphie was created to provide a MySQL-focused monitoring solution similar to tools like mytop and innotop, but with a modern TUI interface and support for newer database versions and ProxySQL.
