- Newest
- Most votes
- Most comments
Hi there.
Can you confirm your production RDS instance has the parameters defined in a parameter group?
Thank you.
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%';
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).
Also, have you tried SHOW LOCAL VARIABLES or just SHOW VARIABLES?
- 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)
- 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)
Is the development environment in RDS or local?
development environment is base on RDS too.