Re: generic remote command/script for monitoring MySQL instance health

2009-03-11 Thread Thomas Spahni

On Mon, 9 Mar 2009, Sven wrote:


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


Hi

What about 'mysqladmin ping' ?

Regards,
Thomas Spahni

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Re: generic remote command/script for monitoring MySQL instance health

2009-03-11 Thread Sven
On 3/11/09, Thomas Spahni t...@lawbiz.ch wrote:
  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.

  What about 'mysqladmin ping' ?

Hi Thomas

thank you. That was the command I searched.

kind regards
Sven

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



generic remote command/script for monitoring MySQL instance health

2009-03-09 Thread Sven
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
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Re: generic remote command/script for monitoring MySQL instance health

2009-03-09 Thread walter harms
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
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org