1b.app
Link copied -

Optimizing system performance for less RAM usage

Congratulations!
In the system https://box1.luxshina.ua/
The user noticed that there is an overload of the RAM indicator. This caused the system to hang, such as not being able to create a process.
I suspect that the problem is a large number of actions for downloading the price of suppliers, although the activation time is distributed.
Please tell me what is loading the system?
What are the possible options for optimizing the system from our side, from settings to improvements?
Original question is available on version: ua

Answers:

How did the user notice this and how much RAM was left on the server at that moment? Now I see 75% occupied RAM, which is quite acceptable.
28.08.2023, 18:23
Original comment available on version: ru

The user previously worked on the old version, which hung when the system was used a lot. The flow of customers occurs seasonally, so the problem appeared in a certain period of time, for example, in spring. To solve this problem, the developers suggested switching to a new version.

That is why it is necessary to prevent the problem with overloading.

The user noticed this when he could not create a lead due to a system freeze. This happens during working hours.

At the moment, the user's system utilization is not high, and even then it is consistently above 75%, and RAM usage increases every hour.

Examples on the screens, what you were able to follow.

The most noticed was 92%, when about 1200 MB remained
29.08.2023, 13:41
Original comment available on version: ua

Most likely, it is not the import of suppliers that makes the load, but the recalculation of prices. You can recalculate prices several times a day, for example, 1 time at 8-9 am before the start of the working day and the second time after it ends to see how the system will behave with this work option. If at the same time there will be no hangup, it is clear that something needs to be done with the recalculation, if they do, then it’s not him
29.08.2023, 15:01
Original comment available on version: ru

They removed it so that at 4 p.m. it listed the prices, attached the screens before and after. But the result of the work, the time specified in the name of the screens has been completed. As you can see there is still a high rise.
29.08.2023, 16:20
Original comment available on version: ua

the deviation from the base is only 1 GB, the hourly crowns can eat so much, this is normal. Do not look at the operative, when it is necessary, it will be thrown into swap and thereby clean itself. You look whether the system has stopped slowing down or not.
From the fact that there is 1.5GB of free RAM left, the server does not stop working, he himself understands this.
29.08.2023, 19:23
Original comment available on version: ru

Let's try to make the price calculation work every hour (the user needs such a function), or will it hang with such settings. Please do not close the question for a while, I will reply. Thank you!
30.08.2023, 11:40
Original comment available on version: ua

Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter. Log in and comment