Linux Today: Linux News On Internet Time.
Search Linux Today
Linux News Sections:  Developer -  High Performance -  Infrastructure -  IT Management -  Security -  Storage -
Linux Today Navigation
LT Home
Contribute
Contribute
Link to Us
Linux Jobs


Top White Papers

More on LinuxToday


11 useful commands for Linux/Unix administrators

Jan 23, 2012, 15:04 (1 Talkback[s])
(Other stories by M. Zinoune)

[ 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: