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
Typical monitoring systems, such as Nagios, Zenoss, etc... for example, provide
both a typical configuration model out the box as well as the ability to write
any checks you may need for your specific environment. You should have some
level of success with any of these.
-Garot
garotconk...
it should do the following:
1. give the status of the health of the nodes -Primary concern
2. Give slow queries
3. NO or reads etc
4. No of users logged in
5. Other admin tasks
On Wed, Oct 10, 2012 at 1:20 PM, Manuel Arostegui wrote:
>
>
> 2012/10/10 Aastha
>
>> Hi,
>>
>> Are there any open s
2012/10/10 Aastha
> Hi,
>
> Are there any open source MYSQL rela time monitoring tools available in the
> market.
>
> Aastha
>
Hello Aastha,
You should try to be more specific when asking for stuff.
What do you want to monitor? reads/writes? QPS? threads? etc
Thanks
Manuel.
Hi,
Are there any open source MYSQL rela time monitoring tools available in the
market.
Aastha
We have tried Oracle tool (MySQL Enterprise Monitor) which allows you to
capture and analyze queries submitted from selected hosts, for a specific time
window. The tool and its user interface were very useful in identifying the
volume and heavy queries. Licensing and (cost) may be an issue. I h
Thanks Johan for info,
We already tried with tcpdump and wireshark it was helpfull. Percona tool kit i
need to try.
From: Johan De Meersman
To: Anupam Karmarkar
Cc: mysql@lists.mysql.com
Sent: Wednesday, 10 October 2012 5:16 PM
Subject: Re: Monitoring Sess
- Original Message -
> From: "Anupam Karmarkar"
>
> How to monitor individual session number of rows selected or updated
> by sessions, number of bytes sent and reviewed by session in a given
> time period, sessions connects runs command and then disconnects,
> SHOW GLOBAL STATUS is not h
Hi Rick,
Thanks for the advise. I have now set my query-cache to zero.
(I take your point about query cache too large. I understand that a
smaller cache size, and the use of the SQL_NO_CACHE and SQL_CACHE
directives can be used to control which queries are cached. Therefore
trying to get t
