Speed of OneBox
Good afternoon. I am your client, I admire and inspire the functionality and capabilities of the system. But there is one nuance that interferes with my happiness - this is the overall speed (performance), page opening time, updating stages, loading goods into an order ...
On test access, everything “flyed”. But when goods, orders, customers were poured onto our server, automation was added, the system began to work longer than the previous “slow” platform.
Pages with orders open for at least 3 seconds, some others up to 10 seconds. Tried to increase the performance of the server, but no effect.
In the load panel, it shows RAM consumption at the level of 3 GB, but in the panel of the server itself, you can see that the database itself also consumes about 7 GB of RAM, which is not a very healthy indicator.
I think that a superficial analysis will not take much time from your specialists to identify the reasons for slow work. I ask for help in solving the problem. I am ready to participa
Original question is available on version: ru
On test access, everything “flyed”. But when goods, orders, customers were poured onto our server, automation was added, the system began to work longer than the previous “slow” platform.
Pages with orders open for at least 3 seconds, some others up to 10 seconds. Tried to increase the performance of the server, but no effect.
In the load panel, it shows RAM consumption at the level of 3 GB, but in the panel of the server itself, you can see that the database itself also consumes about 7 GB of RAM, which is not a very healthy indicator.
I think that a superficial analysis will not take much time from your specialists to identify the reasons for slow work. I ask for help in solving the problem. I am ready to participa
Answers:
I'm also interested in the question of speed.
09.10.2020, 12:57
Original comment available on version: ru
Good afternoon
Preliminarily, from what I saw, this is not the optimality of the system settings by your integrators, give me a few days, I will analyze the system and give more accurate information
Preliminarily, from what I saw, this is not the optimality of the system settings by your integrators, give me a few days, I will analyze the system and give more accurate information
09.10.2020, 14:40
Original comment available on version: ru
Ptashkin Sergey
Client wrote:
Good afternoon. I am your client, I admire and inspire the functionality and capabilities of the system. But there is one nuance that interferes with my happiness - this is the overall speed (performance), page opening time, updating stages, loading goods into an order ... Everything “flyed” on test access. But when goods, orders, customers were poured onto our server, automation was added, the system began to work longer than the previous “slow” platform. Pages with orders open for at least 3 seconds, some others up to 10 seconds. They tried to increase the performance of the server, but it didn’t work. In the load panel, it shows RAM consumption at 3 GB, but in the panel of the server itself, you can see that the database itself also consumes about 7 GB of RAM, which is not a very healthy indicator. I think that your It doesn't take much time for specialists to do a superficial analysis to identify the causes of slow work. I ask for help in solving the problem. I am ready to participate financially in case of a problem on my side. Thank you. address: crm.ohrana.uaps: And this is all while your sales department is already visiting our partners and showing off our cooperation. Believe me, your salespeople are wasting their time while I tell everyone that ONEBOX is slow... Therefore, this is not only my problem, it is also your reputation. And I really want to quickly, without hesitation, advise your service as the fastest and best!
Good afternoon
Before increasing the server parameters, it was necessary to consult what else needs to be done for this. At the moment, you have MYSQL and system configuration configured for CPU 4 cores, RAM 4 - these resources are used. Therefore, after the update, you did not notice anything
now you have CPU 8, RAM 16, I test changed the database and system configuration to these parameters, check if it got better.
And I would also like to get a list of pages where as there are 10 seconds for a more detailed analysis
12.10.2020, 15:19
Original comment available on version: ru
No improvement has been seen yet.
https://crm.ohrana.ua/admin/customorder/zakaz-klienta/?searchLine= - at least 4 seconds, sometimes up to 10 seconds A should open in a split second
https://crm.ohrana.ua/admin/shop/workflowstatus/516/interface/ 6 sec
https://crm.ohrana.ua/admin/shop/workflow/16/constructor/ 25 seconds
It may have been configured for 4 GB of RAM, but the database boldly consumed 7 GB https://prnt.sc/uxtt9n
https://crm.ohrana.ua/admin/customorder/zakaz-klienta/?searchLine= - at least 4 seconds, sometimes up to 10 seconds A should open in a split second
https://crm.ohrana.ua/admin/shop/workflowstatus/516/interface/ 6 sec
https://crm.ohrana.ua/admin/shop/workflow/16/constructor/ 25 seconds
It may have been configured for 4 GB of RAM, but the database boldly consumed 7 GB https://prnt.sc/uxtt9n
12.10.2020, 17:46
Original comment available on version: ru
Ptashkin Sergey
Client wrote:
No improvements have been noticed yet. https://crm.ohrana.ua/admin/customorder/zakaz-klienta/?searchLine= - at least 4 seconds, sometimes up to 10 seconds And should open in a split second https://crm.ohrana.ua /admin/shop/workflowstatus/516/interface/ 6 sechttps://crm.ohrana.ua/admin/shop/workflow/16/constructor/ 25 sec It may have been configured for 4 GB of RAM, but the database boldly consumed 7 GB https ://prnt.sc/uxtt9n
I will analyze the data of the pages and give an answer
about the database, then its consumption should be like this - since it plunges into RAM and works from it faster than from disk
13.10.2020, 07:53
Original comment available on version: ru
Ptashkin Sergey
Client wrote:
No improvements have been noticed yet. https://crm.ohrana.ua/admin/customorder/zakaz-klienta/?searchLine= - at least 4 seconds, sometimes up to 10 seconds And should open in a split second https://crm.ohrana.ua /admin/shop/workflowstatus/516/interface/ 6 sechttps://crm.ohrana.ua/admin/shop/workflow/16/constructor/ 25 sec It may have been configured for 4 GB of RAM, but the database boldly consumed 7 GB https ://prnt.sc/uxtt9n
Good afternoon
it turned out to optimize the page https://crm.ohrana.ua/admin/shop/workflow/16/constructor/
Can you tell me if she's faster?
13.10.2020, 21:47
Original comment available on version: ru
Igor, a miracle happened!
From 30 seconds to several seconds.
Excellent result. But I draw your attention to the fact that this page was indicative of the problem. But it is not decisive in the speed of work in general. Much more important is the page https://crm.ohrana.ua/admin/customorder/zakaz-klienta/?searchLine= which we open hundreds of times a day. Open the list - wait 3-5 seconds. Enter the number - search, again 3-5 seconds. open order 3-5 sec. As a result, it takes 10-15 seconds to find and open an order.
I kindly ask for help in this matter.
From 30 seconds to several seconds.
Excellent result. But I draw your attention to the fact that this page was indicative of the problem. But it is not decisive in the speed of work in general. Much more important is the page https://crm.ohrana.ua/admin/customorder/zakaz-klienta/?searchLine= which we open hundreds of times a day. Open the list - wait 3-5 seconds. Enter the number - search, again 3-5 seconds. open order 3-5 sec. As a result, it takes 10-15 seconds to find and open an order.
I kindly ask for help in this matter.
15.10.2020, 17:54
Original comment available on version: ru
Ptashkin Sergey
Client wrote:
Igor, a miracle happened! From 30 seconds to several seconds. Excellent result. But I draw your attention to the fact that this page was indicative of the problem. But it is not decisive in the speed of work in general. Much more important is the page https://crm.ohrana.ua/admin/customorder/zakaz-klienta/?searchLine= which we open hundreds of times a day. Open the list - wait 3-5 seconds. Enter the number - search, again 3-5 seconds. open order 3-5 sec. As a result, it takes 10-15 seconds to find and open an order. I kindly ask for help in this matter.
This page opens for me on average in 1.5-2 seconds
Even if it happens 3 - it's not super long.
Of these 3 seconds, it takes almost 1.5-2 seconds to count the total lines - if you do not need them, then you can turn on the setting Do not display total lines in the list of processes in the settings -> other and it will be faster
16.10.2020, 11:50
Original comment available on version: ru
Watched for a few days. There are positive changes.
Previously, the page could open in 3 seconds, or it could open in 10 seconds (perhaps it hung when the minute cron was processed). After the settings on your part, I do not observe this problem. After disabling the calculation of totals, we managed to save another 1 second. Now it's much more comfortable to work. However, 2 seconds is not the ultimate dream. How to achieve a time of 0.2 seconds? Does this need to be addressed on the performance side of the server? Or is it not possible due to the nature of boxing? Is it possible to test an existing server? Give recommendations on what parameter to pay attention to when choosing a server. Was it worth counting on better results in terms of speed?
Previously, the page could open in 3 seconds, or it could open in 10 seconds (perhaps it hung when the minute cron was processed). After the settings on your part, I do not observe this problem. After disabling the calculation of totals, we managed to save another 1 second. Now it's much more comfortable to work. However, 2 seconds is not the ultimate dream. How to achieve a time of 0.2 seconds? Does this need to be addressed on the performance side of the server? Or is it not possible due to the nature of boxing? Is it possible to test an existing server? Give recommendations on what parameter to pay attention to when choosing a server. Was it worth counting on better results in terms of speed?
20.10.2020, 11:31
Original comment available on version: ru
Ustimenko Igor OneBox CTO wrote:
Of these 3 seconds, it takes almost 1.5-2 seconds to count the total lines - if you do not need them, then you can turn on the setting Do not display total lines in the list of processes in the settings -> other and it will be faster
Good afternoon everyone! What is this setting responsible for, can you tell me more? What does it affect?
20.10.2020, 17:15
Original comment available on version: ru
Ptashkin Sergey
Client wrote:
Watched for a few days. There are positive changes.
Previously, the page could open in 3 seconds, or it could open in 10 seconds (perhaps it hung when the minute cron was processed). After the settings on your part, I do not observe this problem. After disabling the calculation of totals, we managed to save another 1 second. Now it's much more comfortable to work. However, 2 seconds is not the ultimate dream. How to achieve a time of 0.2 seconds? Does this need to be addressed on the performance side of the server? Or is it not possible due to the nature of boxing? Is it possible to test an existing server? Give recommendations on what parameter to pay attention to when choosing a server. Was it worth counting on better results in terms of speed?
it is not possible to make it straight 0.2 seconds on the current page - most likely it will be in the future
So far, the minimum timing that I saw here is 1 second
I don’t think that you should improve the server now for the sake of 1 second
21.10.2020, 07:56
Original comment available on version: ru
Igor, After the settings, boxing began to work faster. But there is a problem that I can not exactly catch. Pages that usually take 2-3 seconds to open sometimes take 15-30 seconds to open. Reloading is fast. i.e., it is impossible to reset the link and demonstrate it. Moreover, if at the 5th second I understand that the page opens for a long time, I refresh the page and it opens quickly. If you do not update, you will have to wait up to 30 seconds. Perhaps the moment of opening the page coincides with the minute crown? How can this be tracked and fixed.
Also, from time to time, goods are loaded into the process with a delay of 5-15 seconds. I opened the process - all the fields are there, but there is no block with goods. And after 10 seconds, the goods appear. But the reopening of the process is already happening without delay. I can't show either.
Also, from time to time, goods are loaded into the process with a delay of 5-15 seconds. I opened the process - all the fields are there, but there is no block with goods. And after 10 seconds, the goods appear. But the reopening of the process is already happening without delay. I can't show either.
27.10.2020, 14:37
Original comment available on version: ru
Ptashkin Sergey
Client wrote:
Igor, After the settings, boxing began to work faster. But there is a problem that I can not exactly catch. Pages that usually take 2-3 seconds to open sometimes take 15-30 seconds to open. Reloading is fast. i.e., it is impossible to reset the link and demonstrate it. Moreover, if at the 5th second I understand that the page opens for a long time, I refresh the page and it opens quickly. If you do not update, you will have to wait up to 30 seconds. Perhaps the moment of opening the page coincides with the minute crown? How can this be tracked and fixed.
Also, from time to time, goods are loaded into the process with a delay of 5-15 seconds. I opened the process - all the fields are there, but there is no block with goods. And after 10 seconds, the goods appear. But the reopening of the process is already happening without delay. I can't show either.
you need to do logs and server analytics to accurately answer
free will try to monitor
27.10.2020, 14:55
Original comment available on version: ru
Thank you. I'm waiting. I also reset the video with the freezing of goods in the order. But this is not always a problem. If you load the same order next, then most often it opens quickly. I'm ready for a paid service on your part, if you help me find errors in setting up the logic.
07.11.2020, 08:33
Original comment available on version: ru
Igor, good afternoon. Let's finish the job.
I think an hour of work of a specialist can radically change the situation. Willing to pay for work. Tired of guessing on the coffee grounds.
I think an hour of work of a specialist can radically change the situation. Willing to pay for work. Tired of guessing on the coffee grounds.
05.01.2021, 13:03
Original comment available on version: ru
Ptashkin Sergey
Client wrote:
Igor, good afternoon. Let's finish the job.
I think an hour of work of a specialist can radically change the situation. Willing to pay for work. Tired of guessing on the coffee grounds.
give the number of the process on which you measured it
10.01.2021, 22:53
Original comment available on version: ru
Ptashkin Sergey
Client wrote:
273512
your example - see screenshot
this indicates that you have a problem with the Internet connection or the PC itself. Since downloading in the browser directly depends on the speed of the Internet
11.01.2021, 09:39
Original comment available on version: ru
Ustimenko Igor
OneBox CTO wrote:
Ptashkin Sergey
Client wrote:
273512
your example - see screenshot
this indicates that you have a problem with the Internet connection or the PC itself. Since downloading in the browser directly depends on the speed of the Internet
Make me your screen at the moment
11.01.2021, 09:47
Original comment available on version: ru
If I understand the problem correctly, then
11.01.2021, 12:40
Original comment available on version: ru
Ptashkin Sergey
Client wrote:
If I understand the problem correctly, then
The page loaded in 2 seconds - did I understand your screenshot correctly?
11.01.2021, 12:48
Original comment available on version: ru
Boxing is not stable. Sometimes the page opens in 2 seconds, sometimes 10. Items in the order are sometimes loaded with a long delay. Sent the video above.
If you make a call with cpm, and then perform a stage change, then instead of 3 seconds it takes 15 seconds.
I want to use your product and I'm willing to pay for it. I'm even willing to pay for solving the problems I've encountered. On the screenshots, I give what I see, some processes take much longer than others. The problem is with them or something else, I don't know. You don't see the problem in the server. So it is necessary to conduct a program audit.
If you make a call with cpm, and then perform a stage change, then instead of 3 seconds it takes 15 seconds.
I want to use your product and I'm willing to pay for it. I'm even willing to pay for solving the problems I've encountered. On the screenshots, I give what I see, some processes take much longer than others. The problem is with them or something else, I don't know. You don't see the problem in the server. So it is necessary to conduct a program audit.
13.01.2021, 12:41
Original comment available on version: ru
Good afternoon.
I monitored your server for a week and found several nuances that make some peaks on the server in terms of load and at these moments there may be a long load.
For example :
At this stage https://crm.ohrana.ua/admin/shop/workflowstatus/316/action/new/ you check messages from clients and you will never leave this stage if the client does not write. The problem is that you are checking 11016 processes every minute, and the further you go, the more there are. In total, you make 50K requests, of which less than 1% will actually write to you where the client actually writes. I advise you to rethink this setting and switch the process in which the client has not written for more than a month (set the stage duration) to the stage where the process will simply close, and if the client writes, then a new process is created or this one is reopened if you set it up like that
I monitored your server for a week and found several nuances that make some peaks on the server in terms of load and at these moments there may be a long load.
For example :
At this stage https://crm.ohrana.ua/admin/shop/workflowstatus/316/action/new/ you check messages from clients and you will never leave this stage if the client does not write. The problem is that you are checking 11016 processes every minute, and the further you go, the more there are. In total, you make 50K requests, of which less than 1% will actually write to you where the client actually writes. I advise you to rethink this setting and switch the process in which the client has not written for more than a month (set the stage duration) to the stage where the process will simply close, and if the client writes, then a new process is created or this one is reopened if you set it up like that
19.01.2021, 13:23
Original comment available on version: ru
Ustimenko Igor
OneBox CTO wrote:
At this stage https://crm.ohrana.ua/admin/shop/workflowstatus/316/action/new/ you check messages from clients and you will never leave this stage if the client does not write. The problem is that you are checking 11016 processes every minute, and the further you go, the more there are. In total, you make 50K requests, of which less than 1% will actually write to you where the client actually writes. I advise you to rethink this setting and switch the process in which the client has not written for more than a month (set the stage duration) to the stage where the process will simply close, and if the client writes, then a new process is created or this one is reopened if you set it up like that
Igor, good afternoon! a bug has been created regarding this action (No. 2015727314), in which there is no solution yet. We want to change the settings, but before that we need to understand what exactly the problem is. From the moment this action was set, all messages written by customers in the viber bot began to arrive 2-3 times (each message), given that 3 pushes came in, your colleagues sent us to the viber support, after talking with both parties - it turned out that the problem was in this action. As soon as I turn it off - messages arrive correctly, turn it on - they are spent and kroner works out this stage for 12-14 seconds every minute. The problem is that the action goes through all 17 thousand processes and checks for the presence of comments in them? Why doesn't it check only open ones? There are about 500 of them daily. Please help to figure it out
28.01.2021, 10:33
Original comment available on version: ru
Irina wrote:
The problem is that the action goes through all 17 thousand processes and checks for the presence of comments in them? Why doesn't it check only open ones? There are about 500 of them daily. Please help to figure it out
it checks all processes on the status of which the action is set, where are the open ones? if the check is in progress...
I gave you the solution that you need to separate the stages and close 90% of the processes because there are no answers for them
do this and you will be ok
28.01.2021, 10:52
Original comment available on version: ru
Igor, we will reduce the number of processes, but still the task is from Sergey, so that communication with the client goes in one process, without closing the process and without creating a new one every time. How else can we notify an employee about a new message from a client? Are there other implementation options?
or all the same, the only way out is to close the processes, and when a new message is received, to create a new process?
or all the same, the only way out is to close the processes, and when a new message is received, to create a new process?
28.01.2021, 13:17
Original comment available on version: ru
Irina wrote:
Igor, we will reduce the number of processes, but still the task is from Sergey, so that communication with the client goes in one process, without closing the process and without creating a new one every time. How else can we notify an employee about a new message from a client? Are there other implementation options?
or all the same, the only way out is to close the processes, and when a new message is received, to create a new process?
By default, transfer them to the stage where there is no such monitoring.
At the moment when the client writes, reopen the found process from the closed state and already monitor on this status
You can discuss in more detail with the integrator with whom you work, judging by the fact that you gave the task number, you have it
28.01.2021, 15:24
Original comment available on version: ru
Good afternoon. Igor, please help me analyze the load on the server
We constantly see that the mysql process takes up a huge amount of memory and CPU time. When the server had 8GB, it occupied 6GB. Now 16GB and it takes 13GB and completely lays down percent. What causes such a load?
How much memory do you need to work? On your recommendation, we increased the memory allocation for cron, but there is no free memory. It seems that this only made the situation worse.
We constantly see that the mysql process takes up a huge amount of memory and CPU time. When the server had 8GB, it occupied 6GB. Now 16GB and it takes 13GB and completely lays down percent. What causes such a load?
How much memory do you need to work? On your recommendation, we increased the memory allocation for cron, but there is no free memory. It seems that this only made the situation worse.
02.03.2021, 11:49
Original comment available on version: ru
Ptashkin Sergey
Client wrote:
Good afternoon. Igor, please help me analyze the load on the server
We constantly see that the mysql process takes up a huge amount of memory and CPU time. When the server had 8GB, it occupied 6GB. Now 16GB and it takes 13GB and completely lays down percent. What causes such a load?
How much memory do you need to work? On your recommendation, we increased the memory allocation for cron, but there is no free memory. It seems that this only made the situation worse.
You increased the memory for cron incorrectly - you increased the total memory and did not change the cron launch config and this is a mistake!
The fact that the database takes up most of the RAM is normal and it should be so, since MYSQL plunges into RAM and works faster there
02.03.2021, 12:42
Original comment available on version: ru
Good afternoon, Igor. I re-read the entire thread. Thank you very much for your help. Some issues have been successfully resolved, but I would like to highlight the problems. left unchanged:
You made the right remark about the messages "The problem is that you check 11016 processes every minute" and we listened and fixed it, but this problem appeared a couple of days before, and it is not related to general issues and those issues that discussed. Previously you wrote:
- "Preliminarily, from what I saw, this is not the optimality of the system settings by your integrators, give me a few days, I will analyze the system and give more accurate information"
- "you need to do logs and server analytics to give an accurate answer. I'll try to monitor it in my freedom"
Now pages open 3-5 seconds. I don't think this is the limit of boxing.
https://crm.ohrana.ua/admin/customorder/zakaz-klienta/?searchLine= active time 4-5 seconds
If you see suboptimal settings, let's audit and identify bottlenecks.
You made the right remark about the messages "The problem is that you check 11016 processes every minute" and we listened and fixed it, but this problem appeared a couple of days before, and it is not related to general issues and those issues that discussed. Previously you wrote:
- "Preliminarily, from what I saw, this is not the optimality of the system settings by your integrators, give me a few days, I will analyze the system and give more accurate information"
- "you need to do logs and server analytics to give an accurate answer. I'll try to monitor it in my freedom"
Now pages open 3-5 seconds. I don't think this is the limit of boxing.
https://crm.ohrana.ua/admin/customorder/zakaz-klienta/?searchLine= active time 4-5 seconds
If you see suboptimal settings, let's audit and identify bottlenecks.
19.03.2021, 19:26
Original comment available on version: ru
Ptashkin Sergey wrote:
Good afternoon, Igor. I re-read the entire thread. Thank you very much for your help. Some issues have been successfully resolved, but I would like to highlight the problems. left unchanged:
You made the right remark about the messages "The problem is that you check 11016 processes every minute" and we listened and fixed it, but this problem appeared a couple of days before, and it is not related to general issues and those issues that discussed. Previously you wrote:
- "Preliminarily, from what I saw, this is not the optimality of the system settings by your integrators, give me a few days, I will analyze the system and give more accurate information"
- "you need to do logs and server analytics to give an accurate answer. I'll try to monitor it in my freedom"
Now pages open 3-5 seconds. I don't think this is the limit of boxing.
https://crm.ohrana.ua/admin/customorder/zakaz-klienta/?searchLine= active time 4-5 seconds
If you see suboptimal settings, let's audit and identify bottlenecks.
due to the heavy time load now I can not do the analysis
I can come back to the question a little later.
19.03.2021, 22:05
Original comment available on version: ru
Here's another example. Saving the process 5-7 seconds + another 2-3 seconds buttons are inactive
https://crm.ohrana.ua/admin/customorder/zakaz-klienta/440198/edit/ Stage "In progress"
https://crm.ohrana.ua/admin/customorder/zakaz-klienta/440198/edit/ Stage "In progress"
20.03.2021, 12:15
Original comment available on version: ru
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
Copyright © OneBox 2024
