Azure MySQL
Collect Azure MySQL Metrics.
Configuration¶
Install Func¶
It is recommended to activate the TrueWatch Integration - Extensions - DataFlux Func (Automata): All prerequisites are automatically installed, please proceed with the script installation.
If you are deploying Func manually, refer to Manual Deployment of Func
It is recommended to deploy the GSE version.
Install Script¶
Note: Please prepare the required Azure application registration information in advance and assign the
Monitoring Readerrole to the application registration.
To synchronize Azure MySQL monitoring data, we install the corresponding collection script: "TrueWatch Integration (Azure-DB For MySQL Flexible Server Collection)" (ID: integration_azure_mysql_flexible_server).
After clicking 【Install】, input the corresponding parameters:
Azure Tenant ID: Tenant IDAzure Client ID: Application Registration Client IDAzure Client Secret Value: Client Secret Value, note that it is not the IDSubscriptions: Subscription ID, multiple subscriptions separated by,
Click 【Deploy Startup Script】, the system will automatically create the Startup script set and configure the corresponding startup scripts.
After enabling, you can see the corresponding automatic trigger configuration in 「Manage / Automatic Trigger Configuration」. Click 【Execute】 to immediately execute it once without waiting for the scheduled time. Wait for a moment, and you can check the execution task records and corresponding logs.
Verification¶
- In 「Manage / Automatic Trigger Configuration」, confirm whether the corresponding task has the corresponding automatic trigger configuration, and check the task records and logs for any exceptions.
- In TrueWatch, check if there is asset information in 「Infrastructure / Custom」.
- In TrueWatch, check if there are corresponding monitoring data in 「Metrics」.
Metrics¶
After configuring Azure MySQL monitoring data, the default Measurement is as follows. You can collect more metrics by configuring Microsoft.DBforMySQL/flexibleServers Supported Metrics
| Metric Name | Description | Unit |
|---|---|---|
| aborted_connections_total | Total Aborted Connections | count |
| active_connections_maximum | Maximum Active Connections | count |
| active_transactions_maximum | Maximum Active Transactions | count |
| available_memory_bytes_average | Average Available Memory Bytes | byte |
| backup_storage_used_maximum | Maximum Backup Storage Used | count |
| binlog_storage_used_maximum | Maximum Binary Log Storage Used | count |
| com_alter_table_total | Total ALTER TABLE Commands | count |
| com_create_db_total | Total CREATE DATABASE Commands | count |
| com_create_table_total | Total CREATE TABLE Commands | count |
| com_delete_total | Total DELETE Commands | count |
| com_drop_db_total | Total DROP DATABASE Commands | count |
| com_drop_table_total | Total DROP TABLE Commands | count |
| com_insert_total | Total INSERT Commands | count |
| com_select_total | Total SELECT Commands | count |
| com_update_total | Total UPDATE Commands | count |
| cpu_credits_consumed_maximum | Maximum CPU Credits Consumed | count |
| cpu_credits_remaining_maximum | Maximum CPU Credits Remaining | count |
| cpu_percent_maximum | Maximum CPU Percentage | byte |
| data_storage_used_maximum | Maximum Data Storage Used | count |
| ibdata_1_storage_used_maximum | Maximum ibdata1 Storage Used | count |
| innodb_buffer_pool_pages_data_total | Total InnoDB Buffer Pool Data Pages | count |
| innodb_buffer_pool_pages_dirty_total | Total InnoDB Buffer Pool Dirty Pages | count |
| innodb_buffer_pool_pages_flushed_average | Average InnoDB Buffer Pool Pages Flushed | count |
| innodb_buffer_pool_pages_free_total | Total InnoDB Buffer Pool Free Pages | count |
| innodb_buffer_pool_read_requests_total | Total InnoDB Buffer Pool Read Requests | count |
| innodb_buffer_pool_reads_total | Total InnoDB Buffer Pool Reads | count |
| innodb_data_writes_total | Total InnoDB Data Writes | count |
| innodb_row_lock_time_average | Average InnoDB Row Lock Wait Time | milliseconds |
| innodb_row_lock_waits_maximum | Maximum InnoDB Row Lock Waits | count |
| io_consumption_percent_maximum | Maximum I/O Consumption Percentage | byte |
| lock_deadlocks_maximum | Maximum Deadlocks | count |
| lock_row_lock_waits_maximum | Maximum Row Lock Waits | count |
| lock_timeouts_maximum | Maximum Lock Timeouts | count |
| memory_percent_maximum | Maximum Memory Percentage | % |
| network_bytes_egress_total | Total Network Bytes Egress | byte |
| network_bytes_ingress_total | Total Network Bytes Ingress | byte |
| others_storage_used_maximum | Maximum Other Storage Used | count |
| queries_total | Total Queries | count |
| serverlog_storage_limit_maximum | Maximum Server Log Storage Limit | count |
| serverlog_storage_usage_maximum | Maximum Server Log Storage Used | count |
| slow_queries_total | Total Slow Queries | count |
| storage_io_count_total | Total Storage I/O Count | count |
| storage_limit_maximum | Maximum Storage Limit | count |
| storage_percent_maximum | Maximum Storage Percentage | % |
| storage_throttle_count_maximum | Maximum Storage Throttle Count | count |
| storage_used_maximum | Maximum Storage Used | count |
| threads_running_total | Total Running Threads | count |
| total_connections_total | Total Connections | count |
| trx_rseg_history_len_maximum | Maximum Transaction Rollback Segment History Length | count |
| uptime_maximum | Maximum Uptime | seconds |