[ Thanks to An Anonymous Reader for
this link. ]
“4- Display the number of connections to a MySQL Database
“Count the number of active connections to a MySQL database. The
MySQL command “show processlist” gives a list of all the active
clients. However, by using the processlist table, in the
information_schema database, we can sort and count the results
within MySQL.“5- Create a local compressed tarball from remote host
directory“This improves on #9892 by compressing the directory on the
remote machine so that the amount of data transferred over the
network is much smaller. The command uses ssh(1) to get to a remote
host, uses tar(1) to archive and compress a remote directory,
prints the result to STDOUT, which is written to a local file. In
other words, we are archiving and compressing a remote directory to
our local box.”