Comments on: Custom Percona Monitoring and Management Metrics in MySQL and PostgreSQL https://www.percona.com/blog/custom-percona-monitoring-and-management-metrics-in-mysql-and-postgresql/ Fri, 15 Dec 2023 01:22:28 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Cosmic Oppai https://www.percona.com/blog/custom-percona-monitoring-and-management-metrics-in-mysql-and-postgresql/#comment-10974227 Fri, 15 Dec 2023 01:22:28 +0000 https://www.percona.com/blog/?p=78706#comment-10974227 Can we execute multi line query with dirty read.

For example a below query like this:

airbnb_raw_pricing_scrape_count:
query: |
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SELECT COUNT(1) AS count, DATE(updated_at) AS update_date
FROM db.table
WHERE updated_at >= (SELECT DATE(MAX(updated_at)) – INTERVAL 20 DAY FROM db.table)
GROUP BY update_date
ORDER BY update_date DESC
LIMIT 10;
metrics:
– count:
usage: “GAUGE”
description: “Count”
– update_date:
usage: “LABEL”
description: “Update Date”

]]>