Applications Manager MySQL Server monitoring capability helps database administrators monitor the performance and availability of a MySQL database farm. It is an agentless monitoring solution that provides out-of-the-box performance metrics for ensuring the MySQL database server runs efficiently.
Applications
Manager provides a web client that allows you to visualize
MySQL monitoring data from your database tier alongside your
application tiers.
Additionally Applications Manager also has a grouping capability that helps you to group databases so that you gain more visibility on which business applications are affected due to an outage.
Some of the components that are monitored in MySQL database
are:
Connection Time
Request Statistics
Connection Statistics
Thread Details
Table Lock Statistics
Key efficiency
Query Hit Ratio
Query Cache Hitrate
Replication Details, etc.
Monitor Custom MySQL Database Queries
Additionally, Applications Manager also provides the ability to monitor any SQL Query of a MySQL Database by using the Database Query Monitoring capability. With this, a DBA can monitor additional performance metrics, monitor custom database tables and even monitor and expose Business Metrics to Line of Business Managers.
"May I commend Adventnet on an excellent low cost
product that does what it says on the tin."
Ismail Patel
Wolverhampton City Council
United Kingdom
MySQL Monitoring Capabilities
Out-of-the-box monitoring of MySQL availability and performance.
Monitors performance statistics such as connection time,
request statistics, connection statistics, thread details,
etc. Alerts can be configured for these parameters.
Based on the thresholds configured, notifications and
alerts are generated. Actions are executed automatically
based on configurations.
Performance graphs and reports are available instantly.
Reports can be grouped and displayed based on availability,
health, and connection time.
Delivers both historical and current MySQL performance
metrics, delivering insight into the performance over a
period of time.
Happened to read this article in Computer World about how hotel reservations system crashed at MGM Mirage. It had caused check-in and check-out problems for thousands of guests in seven hotels in Las Vegas and elsewhere. "We haven't narrowed down the problem to a specific cause," the spokeswoman of MGM Mirage said. "I would be hesitant at this point to say it was the reservation system. The issue could lie in an underlying application or process."..... read full blog