Data base times out and cut off

0

Hi!

Im using aws and my data base times out a lot. If i try to change anything and uploading files it basically dies. For an exampel Im using better search plug in for wp to change host name in all dv sheets. It runs perfect to the half then the db times out. Is there any changes that need to be done or is it just what it is..the db commits suicide every now and then. 1) connection 1tb up and down 2) happens even if I use a db software. Thanks in demand

Leon
質問済み 8ヶ月前159ビュー
1回答
0

This could be due to too many long-running queries. Another likely cause could be that you're not closing the connections as soon as you've finished with them, which releases them to the connection pool.

In general, you should acquire connections as late as possible and release them as early as possible to avoid this type of situation. If the connections were not properly closed, the garbage collector and finalizers would return the connection to the pool, which may take a while.

If you believe you genuinely have many active connections with long-running queries, I would suggest you increase the number of connections in the connection pool. If you believe it's the actual query itself timing out (i.e. taking longer than you're allowing) then you should increase the timeout for the command or connection.

[References]
Troubleshoot query time-out errors

profile pictureAWS
回答済み 8ヶ月前

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

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

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

関連するコンテンツ