M
M
Maxim Timofeev2015-12-18 14:33:12
MySQL
Maxim Timofeev, 2015-12-18 14:33:12

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

3 answer(s)
M
Melkij, 2015-12-18
@webinar

And what, rucenter began to give SSD?

F
Fellowship, 2015-12-18
@Fellowship

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).

P
pantsarny, 2015-12-20
@pantsarny

32 & 64 bit axes maybe?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question