when i use admin user in rds mysql but i cannot see the global variables

0

my developer enviornment version: Server version: 5.7.38-log use this command mysql > show global status like 'Thread%'; it will output 4 rows.

but in production enviornment version: Server version: 5.7.38-log the same command mysql > show global status like 'Thread%'; Empty set (0.00 sec)

both of them are same version , user and privileges , but when i execute the query in production , the output is empty .

Is there any configuration or permissions that I haven't noticed?

  • Is the development environment in RDS or local?

  • development environment is base on RDS too.

2 Answers
0

Hi there.

Can you confirm your production RDS instance has the parameters defined in a parameter group?

Thank you.

profile pictureAWS
EXPERT
answered 10 months ago
  • yes, my production RDS instance have individual parameter group , performance_schema parameter is 0 and source column is system .

  • Does it have the same parameters as the development instance?

  • yes, both of them have same parameter . i just use different parameter group name to distinguish development and production instance. production instance has enable performance insight . and i use this document to setting https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.EnableMySQL.html . but my production instance still can't see global variables , when i use this command show global status like 'Thread%';

0

Hi there.

Do you see in the console if the instance has a pending reboot? If so, please manually reboot the instance. (note this example shows a SQL Server instance, but the concept is the same).

RDS Instance Pending Reboot

Also, have you tried SHOW LOCAL VARIABLES or just SHOW VARIABLES?

profile pictureAWS
EXPERT
answered 10 months ago
    1. when i change performance_schema setting on parameter group , i have reboot the db instance . after reboot the db instance,i use show global variables command , it still not work output empty.

    mysql> show global variables; Empty set (0.01 sec)

    1. i have tried show local variables and show variables command . both of them output is empty.

    mysql> show local variables; Empty set (0.00 sec)

    mysql> show variables; Empty set (0.00 sec)

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions