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
gefragt vor 8 Monaten159 Aufrufe
1 Antwort
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
beantwortet vor 8 Monaten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen