CODEWITHSUNDEEP
mysqlsqlamazon-aurora
Gutierrez
Gutierrez

Reputation: 157

Queries On Sys Schema Throws Empty Results On Aurora

my goal building queries related with sys schema, like:

SELECT * FROM sys.host_summary_by_statement_type;

Is to get some stadistics and group them to show to my final clients as a security requeriment. I got same results with other queries that uses sys, and it is weird because on my local server it works but when I connect to my Aurora RDS always throws empty results.

Is there any kind of restriction from Amazon related with this? If so, Is there a way to remove the restriction?

Thanks in advance, good day.

Upvotes: 1

Views: 1115

Answers (1)

Nathan Griffiths
Nathan Griffiths

Reputation: 12756

The sys schema for performance data does not exist by default for Aurora MySQL instances, you need to enable it.

Check the RDS parameter group for your Aurora instance to see if the performance_schema parameter is set to 1. If not, the performance schema (and sys schema) is not enabled so you won't see any data.

Change this parameter value to 1 and restart the instance, you should then start seeing performance data returned from views in this schema.

Upvotes: 1

Related Questions