Dolphie
A terminal-based dashboard for real-time monitoring and analytics of MySQL, MariaDB, and ProxySQL databases.
What is Dolphie?
Dolphie is a terminal user interface (TUI) tool that provides a comprehensive, real-time view into MySQL, MariaDB, and ProxySQL performance and activity. It serves as a unified monitoring dashboard, enabling users to quickly diagnose issues, analyze queries, and understand system behavior directly from the command line. It is designed as a lightweight, fast, and feature-rich alternative to graphical monitoring tools.
Database administrators and developers who manage MySQL, MariaDB, or ProxySQL instances and prefer command-line tools for real-time monitoring and troubleshooting.
Developers choose Dolphie for its deep, real-time database insights with minimal overhead, its ability to monitor multiple hosts and ProxySQL simultaneously via hostgroups, and its unique features like session recording/replay and daemon mode for continuous background monitoring.
Overview
Your single pane of glass for real-time analytics into MySQL/MariaDB & ProxySQL
Use Cases
Best For
- Real-time monitoring of MySQL/MariaDB performance metrics and system utilization directly in the terminal.
- Analyzing and killing active queries and connections with filtering and sorting capabilities.
- Continuous, non-interactive monitoring and data recording via daemon mode for forensic analysis.
- Investigating database incidents by recording live session data and replaying it later for troubleshooting.
- Monitoring multiple database instances or ProxySQL hostgroups simultaneously through a tabbed TUI interface.
- Diagnosing replication status and performance schema metrics like statement summaries and metadata locks.
Not Ideal For
- Environments requiring web-based dashboards or integration with existing GUI monitoring systems.
- Teams needing long-term historical data analysis beyond a few days, as replay retention is limited.
- Situations where database performance must not be impacted by monitoring queries, due to Dolphie's active polling.
Pros & Cons
Pros
Supports hostgroups with tabbed views for simultaneous connection to multiple MySQL, MariaDB, or ProxySQL instances, enabling efficient cluster management directly from the terminal.
Integrates live dashboard metrics, processlist analysis, performance schema data, and ProxySQL stats in one TUI, providing deep database visibility without switching tools.
Allows credentials from config files, environment variables, login paths, and SSL connections, making it adaptable to various security and access control setups as detailed in the README.
Enables session recording to compressed SQLite files with ZSTD compression and playback for troubleshooting, a unique feature for incident investigation highlighted in the documentation.
Cons
Daemon mode recording can consume significant disk space, especially on busy servers, as warned in the README, requiring manual configuration of retention hours and monitoring.
Active querying for real-time data adds load to monitored databases, which might be problematic in performance-critical environments where zero-impact monitoring is needed.
Configuring hostgroups, credential profiles, and daemon mode with systemd requires detailed understanding and careful setup, as indicated by the extensive configuration options.
Frequently Asked Questions
Related Projects
Prometheus.ioThe Prometheus monitoring system and time series database.
MySQLTuner-perlMySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.
innodb-rubyA parser for InnoDB file formats, in Ruby
sql-tapWatch SQL traffic in real-time with a TUI
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.