Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

GCP mysql 5.7 and 8.0 Instances QAN Data not available, additional configuration needed?

Description

QAN data is not available for MySQL 5.7, 8.0 GCP instances 

 

User Impact: QAN has no data for Google Cloud Mysql 5.7, 8.0, they need additional changes or configuration setup which is missing in our documentation. 

I was trying to setup GCP mysql 5.7 and mysql 8.0 instances on our testing jobs, I followed the official docs to create pmm user and made sure perf schema agent is in running status, I checked the logs I don't see any error but only see 0 buckets being sent for `type=qan_mysql_perfschema_agent`

STR: 
1) Setup Google cloud mysql 5.7
2) Setup PMM users with similar permissions as mentioned in our  documentation: 

GRANT SELECT, PROCESS, REPLICATION CLIENT, RELOAD ON . TO 'pmm'@'%';

3) create sbtest user for running sysbench 

4) Add this remote instance to PMM via remote MySQL UI, make sure qan_mysql_perfschema_agent is running status
5) Wait for some mins, no QAN data, dashboard have data for MySQL instance. 

6) Open pmm-agent log on the server, you will see buckets being sent with sizes as 0

How to test

None

How to document

None

Attachments

2
  • 29 Dec 2021, 05:08 AM
  • 29 Dec 2021, 05:08 AM

Smart Checklist

Activity

Nailya Kutlubaeva July 25, 2022 at 7:46 AM

I updated both our instances MySQL 5.6 and MySQL 5.7 and now QAN data is displayed

Michal July 21, 2022 at 6:09 AM

I could not replicate this.
By default GCP MySQL 8 does not have performance schema enabled - see https://cloud.google.com/sql/docs/mysql/flags

After enabling performance schema, I'm getting QAN data.

Can you please double-check on your end?

Done

Details

Assignee

Reporter

Priority

Components

Labels

Needs QA

Yes

Story Points

Smart Checklist

Created December 29, 2021 at 4:52 AM
Updated November 13, 2024 at 8:33 AM
Resolved July 25, 2022 at 7:59 AM

Flag notifications