I’m using 2.25.0 version of PMM. At the moment, I don’t use the QAN feature so I would like to turn it off to reduce memory usage as the Clickhouse consumes too much memory. :frowning: Is it possible? If true, how to do that? Thanks. :slight_smile:

Hi @chadr thanks for posting to the Percona forums! There isn’t a supported way of turning off Clickhouse in PMM. Possibly the simplest would be to remove the executable bit on the binary /usr/bin/clickhouse, for example: chmod -x /usr/bin/clickhouse

Is it possible to turn the QAN including Clickhouse off?

Percona Monitoring and Management (PMM) PMM 2.x

Ceri_Williams February 9, 2023, 12:49pm 11

Whilst I can control memory usage as a whole, I couldn’t make ClickHouse see anything different when it auto-configures its memory usage, so I have created PMM-11593

1 Like

Topic		Replies	Views
How to Query the QAN DB PMM 2.x	2	601	November 1, 2022
PMM QAN - Query Analytics API Percona Monitoring and Management (PMM)	1	519	December 9, 2021
Clickhouse query plugin question PMM 2.x mysql	1	638	September 19, 2023
qan does not remove or stop individual servers PMM 1.x	2	1050	April 6, 2019
Pmm-agent doesn't set database for some queries when analyzing mysql.slow-log PMM 2.x pmm , mysql , closed-no-reply	0	707	September 7, 2021

Is it possible to turn the QAN including Clickhouse off?

Related topics