Mytop is one of my classic open source and free console-based (non-gui) monitoring tool for MySQL database was written by Jereme Zawodny using Per. You’ll be asked to enter a password   related: http://www.tecmint.com/mytop-mysql-database-monitoring-in-rhel-centos-fedora/

ps – reports a snapshot of the current processes. ps displays information about a selection of the active processes. If you want a repetitive update of the selection and the displayed information, use top(1) instead. This version of ps accepts several kinds of options: 1   UNIX options, which may be grouped and must be preceded […]

How to compress a folder recursively with 7zip. Exclude all .log, .gz and .tar files Example if it takes a lot of resources you may want to do this (as root of course) (thanks George Valkov) 7zip Help Related http://dotnetperls.com/7-zip-examples http://www.howtoadvice.com/7zipHelper

Create a user with limited permissions GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, CREATE ROUTINE, ALTER ROUTINE,CREATE TEMPORARY TABLES,DROP,INDEX, LOCK TABLES ON yourdb.* TO usr@localhost IDENTIFIED BY “pwd” if you want to create a user that has access to databases that start with a certain prefix. GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, […]