Answer the question
In order to leave comments, you need to log in
Why does the amount of memory consumed vary greatly on different servers?
Moved the project. Servers are similar. Old digitalocean without isp manager, new rucenter with isp manager. Looking at panel debugging data:
old 4 MB RAM
new 11 MB RAM
Looking at Performance Profiling:
old:
15 14:24:17.883 5.3 ms yii\db\Command::execute UPDATE `article_statistic` SET `view_count`=670 WHERE `id`= 2326
new:
11 14:25:16.031 24.4 ms yii\db\Command::execute UPDATE `article_statistic` SET `view_count`=56 WHERE `id`=2326
some things are faster on the new one. But why can execute be so different?
On the new one, for the most part, everything is up to 1 ms, and here 24.
Who will tell you where to dig?
Answer the question
In order to leave comments, you need to log in
At a minimum, database performance can be affected by: different OS settings, disk cache, hardware, and a lot of things.
Ocean, if I remember correctly, is generally located on ssd disks. In the center, I doubt that there is ssd, most likely hard and not very fast yet.
I myself worked with rucenter, the iron is not very good there.
The problem is most likely not in your settings, but in their hypervisor (or any other system responsible for virtualization).
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question