Review key health and performance metrics across all your monitored database instances from a single dashboard. Quickly identify the most critical alarms so you can immediately take action to resolve performance issues on your MySQL databases and their underlying hosts.
Resolve MySQL concurrency issues in record time with historical reviews of lock and deadlock issues.
Visualize even the most complex replication environments, whether one-to-one or one-to-many. Receive alerts when replication breaks or lags.
Understand query performance with a complete breakdown of resource consumption, wait and lock times, row counts, and more using the SQL Performance Investigator (SQL PI) component of Foglight for MySQL.
Visualize the performance of critical server components and the underlying host. An interactive dashboard displays high-level server components and the flow of information between them, and alerts you when components operate outside normal ranges.
Visualize all tables for all your MySQL databases on a single screen, with table health and basic properties.
Understand server performance by category. Quickly identify issues affecting server components, and drill down to details for fast resolution.
Track performance indicators for InnoDB so you can allocate the correct amount of memory to your buffer pool, know if queries are waiting to enter InnoDB, understand how transactions affect InnoDB performance and more.
Easily administer a large or distributed environment by managing connections, tables, flushes and resets centrally from any connected server. Ensure accountability with logs of all actions.
Avoid false alerts with adaptive Intelliprofile thresholds, which ensure alarms are only triggered when baselines are breached. Easily manage and annotate alarms, including scheduling blackouts for maintenance periods.
Monitor hundreds of MySQL servers from a single management server.
Execute data collection through remote agents that ensure minimal overhead (no more than 2% CPU) is added to monitored database instances.
Ensure high-integrity data collection with frequent collections, or customize collection frequency to meet your business requirements.
Store historical monitoring data in the embedded data warehouse — without needing to purchase or install additional database instances for storage of monitoring data. External repositories can be leveraged in larger deployments.