MySQL Management

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. alarms can be configured for these parameters.
• Based on the thresholds configured, notifications and alarms 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.