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
preguntada hace 8 meses160 visualizaciones
1 Respuesta
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
respondido hace 8 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas