I have multiple MySQL servers running on CentOS. I would like to use mytop to monitor real time database query activities, but do not want to install mytop locally on each of my MySQL instances. How can I install mytop on a network server to monitor multiple MySQL servers (nodes) on the same network just by running a command like the one below for example:
mytop -h db-test-1
This should display results for database db-test-1, and for db-test-2 or 3, just basically change the db hostname appropriately.