LightSail LAMP PhP with Postgresql database suddenly extremely slow

Question

Hello, as of today we are experiencing extreme delays between our Php website in a LAMP instance and our LightSail managed PostgreSQL database. It is working for some pages with small queries, very slowly, but not for pages requiring more data. I have rebooted the LAMP instance and the database. The metrics available for the database are quite limited and I can't find any inkling of what is going on. When I try to connect to the database with pgAdmin I get a timeout error. Scrolling through the log available within LightSail is impossible as it starts at the top and requires the press of a button to get more lines, and I can't find a way to download it, or a way to turn on slow query logging. I'm not sure if something may have changed within Bitnami but this is a very important database for us. I'm not sure what else to try besides migrating it to RDS.

rePost-User-5372742
2 anni fa
I have an update - creating a new Lightsail database from a snapshot of the problem database, and pointing my website to that, worked and now the site is blazingly fast. But there is still no inkling what might be wrong with the original database unless the issue is with the Amazon hardware itself.

Answer

Just like to say I have exactly this problem. Around 12 August connections to lightsail instance started taking ~60 seconds to complete.

No load on DB server (~10%).

No changes to configuration or quantity of data.

Database completely unusable.

Postgresql.log file unusable (too slow to page through)

Connections timeout from lambda triggers and from using psql on the command line.

LightSail LAMP PhP with Postgresql database suddenly extremely slow

Contenuto pertinente