LightSail LAMP PhP with Postgresql database suddenly extremely slow

0

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.

  • 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.

質問済み 2年前288ビュー
1回答
0

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.

回答済み 2年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ