Jump to content

Проблемы с доступностью сайта


Recommended Posts

Уважаемые форумчане.

 

Есть сайт игровой тематики на битриксе с посещаемостью 10-15к. В определенные моменты сайт недоступен, так как идет максимальная нагрузка на HDD. ТП хостинга пишут что нагрузку оказывает сервер mysql.

Судя по SQL process list, запросы выполнены через PMA:

+--------+------------+-----------+-----------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+------------+-----------+-----------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+
| 531472 | phpmyadmin | localhost | minecraft | Sleep | 678 | | NULL |
| 531473 | phpmyadmin | localhost | minecraft | Query | 588 | Sorting result | SELECT BE.NAME as NAME,B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,L.DIR as LANG_DIR,BE.SORT as SORT,BE.ID |
| 531839 | phpmyadmin | localhost | minecraft | Sleep | 577 | | NULL |
| 531841 | phpmyadmin | localhost | minecraft | Query | 3 | converting HEAP to MyISAM | SELECT BE.NAME as NAME,B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,L.DIR as LANG_DIR,BE.SORT as SORT,BE.ID |
| 531855 | phpmyadmin | localhost | minecraft | Sleep | 574 | | NULL |
| 531856 | phpmyadmin | localhost | minecraft | Query | 7 | Copying to tmp table on disk | SELECT BE.NAME as NAME,B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,L.DIR as LANG_DIR,BE.SORT as SORT,BE.ID |
| 531859 | phpmyadmin | localhost | minecraft | Sleep | 572 | | NULL |
| 531860 | phpmyadmin | localhost | minecraft | Query | 8 | Copying to tmp table on disk | SELECT BE.NAME as NAME,B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,L.DIR as LANG_DIR,BE.SORT as SORT,BE.ID |
| 531904 | phpmyadmin | localhost | minecraft | Sleep | 529 | | NULL |
| 531905 | phpmyadmin | localhost | minecraft | Query | 4 | converting HEAP to MyISAM | SELECT BE.NAME as NAME,B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,L.DIR as LANG_DIR,BE.SORT as SORT,BE.ID |
| 532071 | phpmyadmin | localhost | minecraft | Sleep | 320 | | NULL |
| 532072 | phpmyadmin | localhost | minecraft | Query | 64 | Sorting result | SELECT BE.NAME as NAME,B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,L.DIR as LANG_DIR,BE.SORT as SORT,BE.ID |

Есть здесь есть люди разбирающиеся в этом, посоветуйте что делать. Я в этом полный 0, если нужно еще информация пишите какая.

 

Если вы уверены сможете решить проблему - пишите в ЛС, деньги не проблема.

Link to post
Share on other sites

Есть вопрос? Задай его профессиональным веб-мастерам, SEO и другим специалистам!

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...