List:General Discussion« Previous MessageNext Message »
From:Manuel Arostegui Date:October 10 2012 6:36pm
Subject:Re: monitoring tool
View as plain text  
2012/10/10 Aastha <aastha3@stripped>

> it should do the following:
>
> 1. give the status of the health of the nodes -Primary concern
>

What do you mean with "health of the nodes"? mysqld running? master-slaves
up and sync'ed? replication not broken? you using NDB?. Still a very vague
explanation.


> 2. Give slow queries
>

You will need to enable slow query log (trying to filter as much as
possible to only log what you would consider a slow query in your
environment). You'd need to scan it too. You might want to take a look at
pt-query-digest. Or use regex over the log if you don't want to use
external tools.


> 3. NO  or reads etc
>

You can parse the output of  "show innodb status" for that.


> 4. No of users logged in
>

Remember you need the SUPER privilege to be able to do this. "show
processlist" will show you the logged users. Again, you'd need to parse its
output.


> 5. Other admin tasks
>

Do you really think we can help you with this description? :-)

Manuel.

Thread
monitoring toolAastha10 Oct
  • Re: monitoring toolManuel Arostegui10 Oct
    • Re: monitoring toolAastha10 Oct
      • Re: monitoring toolGarot Conklin10 Oct
      • Re: monitoring toolManuel Arostegui10 Oct