The Slow_queries counter increments based on your settings applied to MySQL's long_query_time parameter (default 10s), which you can review with this query:
SHOW VARIABLES LIKE 'long_query_time';
This setting's default is 501, but can vary based on the underlying resources available to your instance. You can review your current max_connections limit with this query:
SHOW VARIABLES LIKE 'max_connections';
It is important to note that this alert is disabled by default and you need to edit the configuration in New Relic One to add a targeted MySQL instance:
"WHERE displayName = 'MySql Instance Name'"
This allows the baseline to be calculated against a single instance instead of all running MySQL instances being monitored.
MySQL monitoring quickstart
Applications powered by relational database management systems demand the user to understand how the application uses it. Quickly identify and resolve the source server issues with MySQL performance monitoring tools.
Identify query optimization metrics and more within a single New Relic MySQL dashboard and ensure the highest application performance with this approach.
Optimize your infrastructure by collecting inventory and metrics from your database. Analyze the data to ascertain server health and identify the source of potential problems.
New Relic + MySQL - your ideal tool for better monitoring
Install this quickstart to access pre-configured observability solutions. Unlike other performance monitoring tools, New Relic is a powerful proactive remote monitoring solution that provides a comprehensive view from a single MySQL dashboard.
The MySQL quickstart include out-of-the-box dashboards and alerts, including:
- Alerts (pending reads and writes, max connection errors/second, questions/second, and slow queries/second)
- Dashboards (operations/second, slow queries per minute by node, active connections by node, and more)
Value of MySQL quickstart
New Relic’s instant observability quickstart helps developers accelerate time to value. You can use this approach to help reduce administrative overheads. Implement this robust performance and infrastructure monitoring tool within minutes.