Take Control of MySQL Monitoring

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.

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.

For more information, refer MySQL Management Online Help.

Blog on : Long Checkout Queues in Vegas Hotel

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