I use aws rds mysql and successfully set everything up with using performance_schema as the source.
Unfortunately I had to notice that QAN does not show any of my application queries and I found out that this is because it does not collect data for prepared statements (which is the de facto standard for any application to send queries). Does this mean QAN only really works when using the slow query log as the source?
If so, is there a way to use slow query logs as the source for PMM when connecting to aws rds mysql?
Query analytics do support perf schema as a query source though ( AWS - Percona Monitoring and Management ).
Did you enable the “Use Performance Schema” checkbox during setup?
@Michael_Okoko yes. but only queries that did not use prepared statements are showing up in QAN. I think this has been a known issue/limitation when using performance_schema as the source:
Weird that there is not more pressure to drive this forwards, since pretty much everyone uses prepared statements. So the only option to get useful QAN seems to be to use the slow query logs and I am not sure how I can do this with aws rds or if it is even possible