#StackBounty: #mysql #performance #mysql-5.7 #aws-aurora #read-only-database Clear performance schema on read-only MySQL instance

Bounty: 50

I am using AWS Aurora MySQL with Writer and reader instances in replication. Both instance are used by two separate applications.
I want to clear the performance schema on the read replica server but getting below error.

An error occurred truncating performance_schema event tables. (‘The
MySQL server is running with the –read-only option so it cannot
execute this statement’, 1290)

Is there any option that can be done specifically for this AWS deployment?
Here is the version info:

enter image description here

Output of Select @@global.read_only, @@global.super_read_only;
enter image description here

Get this bounty!!!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.