From: Manuel Arostegui Date: October 10 2012 6:36pm Subject: Re: monitoring tool List-Archive: http://lists.mysql.com/mysql/228366 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0015175d681c3203ba04cbb8bdee --0015175d681c3203ba04cbb8bdee Content-Type: text/plain; charset=ISO-8859-1 2012/10/10 Aastha > 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. --0015175d681c3203ba04cbb8bdee--