Introduction

Proxytop is a self contained real time monitoring tool for ProxySQL, a high performance, high availability, protocol aware proxy for MySQL and forks (like Percona Server and MariaDB).

How to install:

## You may first need to install system Python and MySQL dev packages 
## e.g. "sudo apt install python-dev libmysqlclient-dev"
pip install MySQL-python npyscreen
wget -P /usr/bin https://raw.githubusercontent.com/sysown/proxytop/master/proxytop

How to run:

To connect to a local ProxySQL server configured with the default settings just run the file:

$ proxytop

The script supports connecting to a non-default confication using command line parameters:

usage: proxytop [-h] [-H HOST] [-P PORT] [-u USER] [-p PASSWORD] [-f DFILE]

optional arguments:
  -h, --help            show this help message and exit
  -H HOST, --host HOST  ProxySQL hostname / IP address (default=127.0.0.1)
  -P PORT, --port PORT  ProxySQL Admin port (default=6032)
  -u USER, --user USER  ProxySQL Admin username (default=admin)
  -p PASSWORD, --password PASSWORD
                        ProxySQL Admin password (default=admin)
  -f DFILE, --dfile DFILE
                        Use the MySQL defaults file specified (expects a
                        [proxysqladmin] group)

Interactive shortcuts:

• The arrow keys and "tab" allow for navigating the menus
• "s" will change the sort order (available in Connection Pool and Query Rules views)
• "l" allows for filtering in the Query Rules view (specify full search term e.g. rule_id: 1)
• "+" or "-" to increase or decrease the refresh interval

Other information:

• Scrolling is available in all views in case the lists exceed screen size
• The default interval for refresh is 1 second
• The Process List's minimum refresh interval is 5 seconds in order to avoid overloading ProxySQL Admin