A
A
Airat Kadyrmaev2014-06-11 08:51:43
MySQL
Airat Kadyrmaev, 2014-06-11 08:51:43

Optimization does not help reduce load

We have a site on wordpress, attendance is about 5000 hosts per day, hosting is chosen as the most powerful for our money (1000 rubles per month), Permissible load on the tariff for cpu: 500 for mysql: 5000, and in the last month we exceed it, mysql - 6800-7000 - something like this.
We did two optimizations: We grouped requests for displaying the right block of brands and also grouped requests for displaying full name with avatars. did the second optimization for the full name on the subdomain, then moved it! At first, the load decreased almost twice, and then increased again.
What do you advise to do?

Answer the question

In order to leave comments, you need to log in

5 answer(s)
M
Mikhail Alekseev, 2014-06-11
@Fandorin

For public pages, you can configure caching of html pages on a proxy server (on nginx it is a proxy cache), and for personalized pages, find the requests that are most often executed and cache the result in memory.

K
kolesnevg, 2014-06-11
@kolesnevg

View the most frequent requests and try to cache their results.

P
Puma Thailand, 2014-06-11
@opium

install cache plugin
total super cache or w3 cache
load will drop to almost zero

T
Timur Biktashev, 2014-06-11
@tizar

I agree with opium's answer. The caching plugin will greatly reduce the load.
I will add another MaxCache caching script (paid). I didn’t use it myself, but the reviews on the network are just mi-mi-mi)))

V
Vlad Zhivotnev, 2014-06-15
@inkvizitor68sl

Get off this host. Virtual machines on ssd, even in Russia, already cost 250 rubles, not to mention 150-ruble Europeans.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question