Monitoring in Azure Database for MariaDB
Monitoring data about your servers helps you troubleshoot and optimize for your workload. Azure Database for MariaDB provides various metrics that give insight into the behavior of your server.
All Azure metrics have a one-minute frequency, and each metric provides 30 days of history. You can configure alerts on the metrics. Other tasks include setting up automated actions, performing advanced analytics, and archiving history. For more information, see the Azure Metrics Overview.
For step by step guidance, see How to set up alerts.
List of metrics
These metrics are available for Azure Database for MariaDB:
|Metric||Metric Display Name||Unit||Description|
|cpu_percent||CPU percent||Percent||The percentage of CPU in use.|
|memory_percent||Memory percent||Percent||The percentage of memory in use.|
|io_consumption_percent||IO percent||Percent||The percentage of IO in use. (Not applicable for Basic tier servers.)|
|storage_percent||Storage percentage||Percent||The percentage of storage used out of the server's maximum.|
|storage_used||Storage used||Bytes||The amount of storage in use. The storage used by the service may include the database files, transaction logs, and the server logs.|
|serverlog_storage_percent||Server Log storage percent||Percent||The percentage of server log storage used out of the server's maximum server log storage.|
|serverlog_storage_usage||Server Log storage used||Bytes||The amount of server log storage in use.|
|serverlog_storage_limit||Server Log storage limit||Bytes||The maximum server log storage for this server.|
|storage_limit||Storage limit||Bytes||The maximum storage for this server.|
|active_connections||Active Connections||Count||The number of active connections to the server.|
|connections_failed||Failed Connections||Count||The number of failed connections to the server.|
|network_bytes_egress||Network Out||Bytes||Network Out across active connections.|
|network_bytes_ingress||Network In||Bytes||Network In across active connections.|
You can enable slow query logging on your server. These logs are also available through Azure Diagnostic Logs in Azure Monitor logs, Event Hubs, and Storage Account. To learn more about logging, visit the server logs page.
Query Store keeps track of query performance over time including query runtime statistics and wait events. The feature persists query runtime performance information in the mysql schema. You can control the collection and storage of data via various configuration knobs.
Query Performance Insight
Query Performance Insight works in conjunction with Query Store to provide visualizations accessible from the Azure portal. These charts enable you to identify key queries that impact performance. Query Performance Insight is accessible in the Intelligent Performance section of your Azure Database for MariaDB server's portal page.
The Performance Recommendations feature identifies opportunities to improve workload performance. Performance Recommendations provides you with recommendations for creating new indexes that have the potential to improve the performance of your workloads. To produce index recommendations, the feature takes into consideration various database characteristics, including its schema and the workload as reported by Query Store. After implementing any performance recommendation, customers should test performance to evaluate the impact of those changes.
Planned maintenance notification
Planned maintenance notifications allow you to receive alerts for upcoming planned maintenance to your Azure Database for MariaDB. These notifications are integrated with Service Health's planned maintenance and allow you to view all scheduled maintenance for your subscriptions in one place. It also helps to scale the notification to the right audiences for different resource groups, as you may have different contacts responsible for different resources. You will receive the notification about the upcoming maintenance 72 hours before the event.
We will make every attempt to provide Planned maintenance notification 72 hours notice for all events. However, in cases of critical or security patches, notifications might be sent closer to the event or be omitted.
To receive planned maintenance notification
- In the portal, select Service Health.
- In the Alerts section, select Health alerts.
- Select + Add service health alert and fill in the fields.
- Fill out the required fields.
- Choose the Event type, select Planned maintenance or Select all
- In Action groups define how you would like to receive the alert (get an email, trigger a logic app etc.)
- Ensure Enable rule upon creation is set to Yes.
- Select Create alert rule to complete your alert
For detailed steps on how to create service health alerts, refer to Create activity log alerts on service notifications.
Planned maintenance notifications are currently available in preview in all regions except West Central US