B.D error with application doors closed

Asked

Viewed 32 times

2

I have an e-commerce and is staying at Configr and we never had problems with it. This week the site started to get overloaded, even without traffic or anything, coming down several times.

The server people say that the application doors are closed and sent me this article: http://ajuda.configr.com/o-que-pode-impactar-no-consumo-de-ram-seu-cloud/

ATTENTION! It is important to check the application code for openness and closure of connections to the database. Otherwise, consumption tends to increase.

Could someone who knows about the database help me? 'Cause I don’t know a thing

database wordpress woocommerce e-commerce

  • Which Database Error is Showing?

  • @Tony no error appears, the site appears that is overloaded on the site of Configr, as if it had an absurd traffic when in fact, it does not have

1 answer

1


I do not know what is your database and do not understand much of wordpress, but...

A good practice of programming is whenever you create an object, after using it you destroy the same to thus free memory. The same applies to database, when instantiating a connection to the database you are consuming memory and processing of your server, and leaving it open you are constantly occupying that memory and wanting or not also generating some "memory junk".

In my view, the right is whenever you need to do a search(select) or other operation as an insert(Insert) or update(update), you instantiate a connection to the database, perform all necessary operations and then close the connection, thus freeing your server’s memory and processing and also the "memory junk"

In your case, you should be instantiating the connection with the bank and leaving it open always, thus always generating a little "memory junk" and other things that are getting in memory, weighing on your server and the processes of it.

"Memory junk" means, for example, data that the connection might create to optimize repeated tasks, and other things.

Browser other questions tagged database wordpress woocommerce e-commerce

You are not signed in. Login or sign up in order to post.