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.
