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 to the MariaDB instance. You can also use the ~/.mytop file to set your default parameters. With the current VirtualBox configuration, you only need to define the selected database (here, it is not specified, so all databases are matched), as shown...