mytop

mytop was a powerful tool for MySQL, which is now deprecated. Fortunately, the MariaDB project has continued this tool and included advanced features, such as progression as described in the preceding section. It permits us to show the current running queries and update often using the top command. As this is an interactive command, several options exist. To download it, get it from the MariaDB source code and add it to your binary PATH environment:

wget -O /usr/bin/mytop "http://bazaar.launchpad.net/~maria-captains/maria/10.0-base/download/sergii%40pisem.net-20121017170408-6g093t8gm948zore/mytop.sh-20110627161159-12i6t8if6e5q5v6c-1/mytop.sh"
chmod 755 /usr/bin/mytop

Once mytop is installed, you can call it with extra parameters to connect ...

Get MariaDB High Performance now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.