Foglight for MySQL
Foglight for MySQL ensures the health of your MySQL database environment
Detect, diagnose and resolve performance issues across your MySQL environment
Your organization implemented MySQL because it’s a cost-effective, stable and scalable database option. However, introducing open source technology into your enterprise database can challenge DBAs like you to realize the benefits and cost savings that the platform can provide.
What if you could proactively manage the health of your MySQL infrastructure while helping your organization realize the cost efficiency of leveraging open source databases? What if you could do this without sacrificing your ability to monitor and diagnose problems? Foglight® for MySQL addresses these and broader cross platform needs. Make your job easier while you ensure the health and performance of your entire database environment.
Features
Global view
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.
Workload analysis
Drill into every dimension of your data, including users, connections, SQL and sessions. A derived workload metric tells you how much work your server is performing for comparison to other MySQL servers.
Automated change tracking
See all changes made to the server configuration in any given time period — even through server restarts — and determine the impact of each change on performance.
Comparison reporting
Easily spot and correct discrepancies by comparing database server configurations against your templates.
Lock analysis
Resolve MySQL concurrency issues in record time with historical reviews of lock and deadlock issues.
Replication
Visualize even the most complex replication environments, whether one-to-one or one-to-many. Receive alerts when replication breaks or lags.
Query analysis and statement digests
Understand query performance with a complete breakdown of resource consumption, wait and lock times, exceptions and row counts. Compare the performance of similar queries across your MySQL servers, and see full explain plans. See how workload is affected when specific statements are executed.
Component visualization
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.
Table visualization
Visualize all tables for all your MySQL databases on a single screen, with table health and basic properties.
Server metrics
Understand server performance by category. Quickly identify issues affecting server components, and drill down to details for fast resolution.
InnoDB performance
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.
Centralized administration
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.
Intelligent alerting
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.
Enterprise-scale monitoring
Monitor hundreds of MySQL servers from a single management server.
Low overhead
Execute data collection through remote agents that ensure minimal overhead (no more than 2% CPU) is added to monitored database instances.
High granularity
Ensure high-integrity data collection with frequent collections, or customize collection frequency to meet your business requirements.
Embedded repository
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.
Tour
Tables
Query Cache
Statements
MySQL Server View
List of Monitored Instances
Specifications
- Supported MySQL Versions
- MySQL 5.0 and above
- MariaDB 5.0 and above
- Supported Deployment Locations
- Both on-premises and cloud deployments
- Supported FMS Versions
- Foglight Management Server (FMS) 5.7.5 or higher
Resources
Foglight for MySQL
Proactively manage the health and performance of your MySQL database infrastructure.
A Zombie's Survival Guide in a Changing Database World
With the rise of autonomous databases – and all the other scary changes in database management systems – you, as a DBA may be wondering whether you’re in the midst of a DBApocolypse. You are. And this is your definitive survival guide.
The Importance of Continuous Monitoring in a DevOps Pipeline
A common challenge in many IT teams is the “blame game” where developers blame DBAs for stability and performance issues and vice versa. What if you had complete visibility and continuous monitoring to understand the root cause of database issues?
Managing Cross-Platform Database Environments
This technical brief outlines the top five complications faced by DBAs amid the rush of new database technologies in recent years. For each challenge it provides background, context and the benefits Foglight for Databases brings in addressing them.
DBAs Face New Challenges: Trend in Database Administration
To gain insight into the evolving challenges for DBAs, Quest commissioned DBTA to survey DBAs and those responsible for the management of the corporate data management infrastructure. The results are in and the thought-provoking findings are now available
Tools for the Evolving Database Administrator
Databases evolve fast and smart database administrators (DBAs) evolve even faster. As the landscape shifts from reliance on relational database management systems (RDBMS) to public-cloud Database as a Service (DBaaS), so do the responsibilities of the DBA
New Trends and Challenges for DBAs
Research reveals how continued data growth, evolving responsibilities and cloud technology are affecting DBAs.
- More Resources
- Communities
- Research Docs
Take the next step
Related Products
Foglight for Cross-Platform Databases
Consolidate and standardize database performance management across diverse environments.
Foglight for Oracle
Manage, diagnose and optimize Oracle database performance, on premises and in the cloud.
Foglight for SQL Server
Ensure the health of your SQL Server databases with comprehensive performance monitoring
Foglight for MongoDB
Rapidly detect, diagnose and fix issues across physical, virtual and cloud-based servers.
Foglight for PostgreSQL
Proactively manage the health and performance of your PostgreSQL database infrastructure.
Foglight for Cassandra
Rapidly detect, diagnose and fix issues across physical, virtual and cloud-based servers.
Foglight for DB2
Provide scalable, intelligent, web-based monitoring 24x7 with ease
Foglight for SAP ASE
Resolve issues faster with continuous, scalable, web-based Sybase database monitoring.