Форум

Здравствуйте,

Есть сайт на bitirix еще 2010 года. При переносе на новый хостинг он стал сильно грузить баззу данных, что аш происходили падения.

Лог активных служб при падение.

Скрытый текст

LA=8 PIDS=10 CPU=0% MEM=1.8% SQL=218% PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ UID COMMAND (TOP) ----------------------------------------------------------------------- 11613 ecigare+ 30 10 586876 67976 35712 S 0.0 0.2 0:00.27 1374 /usr/sbin/apache253 -D php53 -k start 15501 ecigare+ 30 10 587892 67480 34140 S 0.0 0.2 0:00.34 1374 /usr/sbin/apache253 -D php53 -k start 19959 ecigare+ 30 10 586112 67692 36124 S 0.0 0.2 0:00.26 1374 /usr/sbin/apache253 -D php53 -k start 24601 ecigare+ 30 10 587360 69156 36376 S 0.0 0.2 0:00.34 1374 /usr/sbin/apache253 -D php53 -k start 24638 ecigare+ 30 10 584948 63156 32668 S 0.0 0.2 0:00.07 1374 /usr/sbin/apache253 -D php53 -k start 24709 ecigare+ 30 10 586112 67688 36124 S 0.0 0.2 0:00.28 1374 /usr/sbin/apache253 -D php53 -k start 25976 ecigare+ 30 10 579936 48236 22736 S 0.0 0.1 0:00.02 1374 /usr/sbin/apache253 -D php53 -k start 26879 ecigare+ 30 10 585308 65760 35164 S 0.0 0.2 0:00.15 1374 /usr/sbin/apache253 -D php53 -k start 27916 ecigare+ 30 10 579936 48236 22736 S 0.0 0.1 0:00.02 1374 /usr/sbin/apache253 -D php53 -k start 28748 ecigare+ 30 10 587568 66568 33436 S 0.0 0.2 0:00.42 1374 /usr/sbin/apache253 -D php53 -k start Id User Host db Command Time State Info (SQL) ----------------------------------------------------------------------- 1505616 ecigarette_defau localhost ecigarette_defau Query 748 statistics SEL ECT DISTINCT BE.ID as ID,BE.NAME as NAME,BE.CODE as CODE,DATE_FORMAT(BE.DATE_CREATE, '%d.%m.%Y %H 1506616 ecigarette_defau localhost ecigarette_defau Query 676 statistics SELECT DISTINCT BE.ID as ID,BE.NAME as NAME,BE.CODE as CODE,DATE_FORMAT(BE.DATE_CREATE, '%d.%m.%Y %H 1507612 ecigarette_defau localhost ecigarette_defau Query 603 statistics SELECT DISTINCT BE.ID as ID,BE.NAME as NAME,BE.CODE as CODE,DATE_FORMAT(BE.DATE_CREATE, '%d.%m.%Y %H 1508683 ecigarette_defau localhost ecigarette_defau Query 533 statistics SELECT DISTINCT BE.ID as ID,BE.NAME as NAME,BE.CODE as CODE,DATE_FORMAT(BE.DATE_CREATE, '%d.%m.%Y %H 1515941 ecigarette_defau localhost ecigarette_defau Query 480 Waiting for table level lock UPD ATE b_iblock_element SE T TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST 1515966 ecigarette_defau localhost ecigarette_defau Query 479 Waiting for table level lock SELECT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_ID,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,BE.NAME as N 1516614 ecigarette_defau localhost ecigarette_defau Query 434 Waiting for table level lock SELECT COUNT(DISTINCT BE.ID) as C FR OM b_iblock B INNER JOIN b_lang L ON B.LID=L.LID INNER JOIN b_ 1517076 ecigarette_defau localhost ecigarette_defau Query 405 Waiting for table level lock SELECT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_ID,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,BE.NAME as N Srv PID Acc M CPU SS Req Conn Child Slot Client VHost Request (APACHE) ----------------------------------------------------------------------- 1-41 16038 0/527/107217 W 0.00 994 0 0.0 11.33 2360.09 141.8.184.13 e-cigarette.su:8083 GET /e-store/e-liquid/filter/?arrFilter_pf[flakon][]=173&arrFil 2-41 26453 0/821/105764 W 0.00 1228 0 0.0 16.60 2304.11 130.193.51.50 e-cigarette.su:8083 GET /e-store/e-liquid/filter/?arrFilter_pf[flakon][]=173&arrFil 3-41 9692 0/812/106522 W 0.00 433 0 0.0 15.76 2322.84 40.77.167.30 e-cigarette.su:8083 GET /e-store/e-liquid/filter/?PAGEN_66=3&PAGEN_95=83&PAGEN_97=1 4-41 10334 0/938/107296 W 0.00 404 0 0.0 16.47 2329.87 130.193.51.50 e-cigarette.su:8083 GET /e-store/e-liquid/index.php?SECTION_ID=1027&ELEMENT_ID=4329 6-41 12634 0/570/106108 W 0.00 479 0 0.0 10.31 2346.86 130.193.51.50 e-cigarette.su:8083 GET /e-store/e-liquid/index.php?SECTION_ID=1027&ELEMENT_ID=4329 7-41 27899 0/841/103664 W 0.10 1153 0 0.0 17.71 2278.82 130.193.51.50 e-cigarette.su:8083 GET /e-store/e-liquid/filter/?arrFilter_pf[flakon][]=173&arrFil 9-41 14551 0/505/101888 W 0.00 478 0 0.0 9.56 2225.69 5.143.231.8 e-cigarette.su:8083 GET /forum/index.php?register=yes&PAGE_NAME=profile_view&UID=90 11-41 19074 0/338/98296 W 0.97 448 0 0.0 6.17 2142.22 5.143.231.8 e-cigarette.su:8083 GET /forum/index.php?register=yes&PAGE_NAME=profile_view&UID=90 15-41 19451 0/374/87582 W 0.03 418 0 0.0 7.31 1991.86 5.143.231.8 e-cigarette.su:8083 GET /forum/index.php?register=yes&PAGE_NAME=profile_view&UID=90 18-41 6523 0/664/57537 W 0.00 1078 0 0.0 12.75 1247.75 130.193.51.50 e-cigarette.su:8083 GET /e-store/e-liquid/filter/?arrFilter_pf[flakon][]=173&arrFil

Есть специалисты которые знают в чем проблема и могут помочь ?