Azure MySQL Flexible Server Services

# Query Azure MySQL Flexible Server state, HA configuration, and zone placement
az mysql flexible-server show \
  --resource-group rg-production-databases \
  --name mysql-flex-primary-prod \
  --query "{Name:name,State:state,Version:version,HA:highAvailability.mode,Zone:zone,StandbyZone:highAvailability.standbyAvailabilityZone,StorageGB:storage.storageSizeGb,IOPS:storage.iops}" \
  --output table

# Check server parameter configuration for connection limits and thread pool
az mysql flexible-server parameter show \
  --resource-group rg-production-databases \
  --server-name mysql-flex-primary-prod \
  --name max_connections \
  --query "{Parameter:name,Value:value,Source:source}" \
  --output table

-- Safe read-only inspection of active MySQL client threads and connection capacity
SHOW STATUS LIKE 'Threads_%';

-- Inspect connection states and max connection threshold headroom
SELECT
  'Threads_connected' AS metric,
  VARIABLE_VALUE AS current_connections
FROM performance_schema.global_status
WHERE VARIABLE_NAME = 'Threads_connected'
UNION ALL
SELECT
  'max_connections' AS metric,
  VARIABLE_VALUE AS configured_limit
FROM performance_schema.global_variables
WHERE VARIABLE_NAME = 'max_connections';