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
asked 7 months ago152 views
1 Answer
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
answered 7 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions