Оптимизация нагрузки на сервер / базу данных

Проблема в чрезмерном потреблении ресурсов выделенного хостинга, и провайдер постоянно блокирует наш сайт.

Интересует оптимизация нагрузки, чтобы не возникали подобные проблемы.

Наш сайт www.carnitec.com

Вот последнее сообщение от хостинга:

We detected that your website carnitec.com continuously consumes a higher than the reasonable percentage of the shared resources of the server it is hosted on. As a result, we had to temporarily put an upper limit to the shared server resources your account can use in order to maintain the stability of the server.

CAUSE OF HIGH RESOURCE CONSUMPTION:

We have conducted a detailed investigation and it turned out that WordPress executes slow queries towards its database, which eventually hogs the server. The server tries to execute your slow queries while putting other processes in the queue until some memory is freed. While they are waiting however, they stack up and cause further problems. There can be many reasons for slow database queries, but the following 3 are the most common ones:

1. Large database

2. Not well written scripts

3. Large number of internal links that query the database directly.

Here are some of the database queries that are slow and consume a lot of server resources:

Executed: 171 time for minumum: 1.746560 sec, maximum: 960.514011 sec

SELECT DISTINCT s.id, s.name, s.context, st.status, s.gettext_context, st.value AS tra, st.mo_string AS mo_string, s.value AS orig FROM car_icl_string_pages sp INNER JOIN car_icl_string_urls su ON su.id = sp.url_id INNER JOIN car_icl_strings s ON s.id = sp.string_id LEFT JOIN car_icl_string_translations st ON s.id=st.string_id AND st.language=su.language AND s.language!=su.language WHERE (su.language='en' and su.url='products/([^/] )(?:/([0-9] ))?/?$') or (su.language='en' and su.url IS NULL);

-------------------------------------------------------------------------------------------------------------------

=== Databases Info =======================================================================

  Database            Label Tables Views InnoDB MyISAM Slow Queries Slowest Query DB Size

  ------------------- ----- ------ ----- ------ ------ ------------ ------------- --------

  carnitec_carnew              115     0    114      1           23       901.197 274.8 MB

From the queries above we can conclude that your issue is caused by the database carnitec_carnew. 

RECOMMENDED SOLUTIONS:

----- START OF CASE SELECTION -----

1. Optimize or remove the problematic script

Having not well written scripts is a quite complex problem. It may be caused by an additionally installed extension/module that is not working properly, or it may be in the application itself.

If the reason is in an extension/module, the easiest solution would be to disable/remove it. This can usually be done from the application's admin area.

If the problem is in the application itself, solving it may take much more time and effort and will probably require advanced programming skills. In such cases it would be best to contact the application's developers and ask for further assistance. They should be able to examine the issue and offer a suitable solution for it.