RDS Database in Lightsail Becoming Slow and Unexpected Upgrade

Question

Hi,

For the past week, I’ve been experiencing issues with my RDS database. It suddenly becomes very slow for normal queries. All the database metrics look fine, but the only way to make it responsive again is by restarting it. However, after a few hours, it becomes unresponsive again.

Today, the database went into an “Upgrading” state automatically without any prior notice, which caused downtime for my production site.

I haven’t made any changes to the application or the database configuration for the past year.

Can someone help me understand why this is happening and how I can prevent it in the future?

Thanks in advance.

re:Post Agent · Answer

There are a few potential issues that could explain what you're experiencing with your Lightsail database:

1. Regarding the slowness that improves after restart:
This is a common pattern with database systems. When you restart the database, it clears the query cache and buffer cache, which then need to be rebuilt. The temporary performance improvement after restart suggests that your database might be experiencing issues with statistics, query plans, or resource utilization.

You might want to try running ANALYZE and REINDEX operations on your database. These operations update statistics and optimize indexes, which can significantly improve performance, especially if they haven't been run in a long time.

2. Regarding the automatic upgrade:
Amazon Lightsail databases (which use RDS under the hood) have automatic maintenance mechanisms. The "Upgrading" state you observed was likely due to one of these:

- Automatic patching: RDS applies critical patches during maintenance windows
- Major version upgrades: These can be scheduled and will occur during maintenance windows
- Automatic restart: RDS instances automatically restart after 7 days if they've been in a "Stopped" status

You can verify if an upgrade was scheduled by using the AWS CLI command:
```
aws lightsail get-relational-database --relational-database-name YourDatabaseName --region YourRegion
```

To prevent these issues in the future:

1. For performance issues:
- Regularly schedule maintenance tasks like ANALYZE and REINDEX
- Monitor query performance and optimize slow queries
- Consider upgrading your database plan if you're hitting resource limits

2. For unexpected upgrades/restarts:
- Check your maintenance window settings and adjust them to less impactful times
- Monitor the "pendingModifiedValues" in your database description to see if upgrades are scheduled
- Create database snapshots before maintenance windows as a precaution

If the performance issues persist after these steps, you might need to investigate specific query patterns or consider database parameter tuning.  
**Sources**  
[Aurora RDS slow performance | AWS re:Post](https://repost.aws/questions/QUjFix-EEJSCmS97ve9a8dxg/aurora-rds-slow-performance)  
[Lightsail RDS Instance - Restarted on its own | AWS re:Post](https://repost.aws/questions/QUqvn34aM-SJ-YqyWqDwn93w/lightsail-rds-instance-restarted-on-its-own)  
[Upgrade the major version of a Lightsail database - Amazon Lightsail](https://docs.aws.amazon.com/lightsail/latest/userguide/amazon-lightsail-upgrade-database-major-version.html)  
[RDS restarting without notification | AWS re:Post](https://repost.aws/questions/QUH-7-DxYTQ8Sdng7nrwp7LQ/rds-restarting-without-notification)

RDS Database in Lightsail Becoming Slow and Unexpected Upgrade

Add your answer

Relevant content