OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: generic remote command/script for monitoring MySQL instance health

From: walter harms (wharmsbfs.de)
Date: Mon Mar 09 2009 - 11:18:17 CDT


you may like to try "mytop"
or

watch -n10 mysql -BNA <databasename> -e "show full processlist"

add user,host,databasename as needed

Sven schrieb:
> Hi folks
>
> I am searching for a generic command to monitor that MySQL instance is
> up and running. I don't have any know-how about the schema of the DB.
>
> kind regards
> Sven Aluoor
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql