Enable QAN without Performance schema in mysql

Hi Team,

Is there any way we can enable QAN without performance schema in mysql , the reason being we need to provision a 4 CPU instance if we need to enable performance schema in google cloud sql , is there any way we can enable this without performance schema , please let us know
Thanks

1 Like

Hi,

It can be used two metric sources Slow query log and Performance Schema
But the first one requires to have PMM Client on the same host as the database server.

https://www.percona.com/doc/percona-monitoring-and-management/2.x/setting-up/client/mysql.html#choose-and-configure-a-source

1 Like

Hi adivinho,

This is a cloudsql instance [PaaS] hence we cannot connect to it directly nor can we install the pmm-client

1 Like

So the only possible way is to use Performance Schema

1 Like