11 useful commands for Linux/Unix administrators

[ 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."

Complete Story

Related Stories:

• Create Bash Aliases For Faster Terminal Commands In Linux(Jan 04, 2012)
• 12 Commands Every Linux Newbie Should Learn(Dec 27, 2010)
• 7 Useful Linux Networking Commands (Apr 19, 2010)
• 5 most common and useful commands/tools for Linux administrators(Apr 05, 2010)
• Practical Guide to Linux Commands, Editors, and Shell Programming(Jan 01, 2010)
• 10 Useful Linux Commands(Dec 31, 2009)