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 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南