In a recent blog post, Google announced the general availability of Monitoring Query Language (MQL) in Cloud Monitoring.

MQL provides developers and operators with powerful metric querying, analysis, charting, and alerting capabilities. They can use the language for use cases such as troubleshooting purposes, root cause analysis, reporting and analytics, and complex alert logic.

Google built MQL using operations and functions. Using the ‘pipe’ idiom, operations are connected together, where one operation’s output becomes the input to the next – and by linking, users can build up complex queries incrementally. In the same way, users can compose and chain commands and data via pipes on the Linux command line – allowing them to fetch metrics and apply operations using MQL. Users can use MQL to:

• Create ratio-based charts and alerts
• Perform time-shift analysis
• Apply mathematical, logical, table operations, and other functions to metrics
• Fetch, join, and aggregate over multiple metrics
• Select by arbitrary, rather than predefined, percentile values
• Create new labels to aggregate data by using arbitrary string manipulations, including regular expressions

#query #google cloud platform #google cloud #cloud