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?

已提問 1 年前檢視次數 284 次
2 個答案
0

Hi there.

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

Thank you.

profile pictureAWS
專家
已回答 1 年前
  • 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
專家
已回答 1 年前
    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)

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南