Подскажите пожалуйста:
Достался уже готовый сайт, раньше проблем не было, но недавно стал падать сайт и выдавать 504 ошибку, при этом все нормально, за исключением очень большой нагрузки на MySQL.
show processlist; выдает:
можете подсказать как с этим бороться.
Достался уже готовый сайт, раньше проблем не было, но недавно стал падать сайт и выдавать 504 ошибку, при этом все нормально, за исключением очень большой нагрузки на MySQL.
show processlist; выдает:
Скрытый текст |
---|
+-----+-----------+-----------+--------------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+-----------+-----------+--------------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+ | 624 | a15450_07 | localhost | a15450_bitom | Query | 14 | Updating | UPD ATE b_stat_adv_guest SET `DATE_HOST_HIT` = now() WHERE ADV_ID=5 and IP_NUMBER='2999996976' and BA | | 627 | a15450_07 | localhost | a15450_bitom | Sleep | 0 | | NULL | | 641 | a15450_07 | localhost | a15450_bitom | Query | 13 | Waiting for table level lock | UPD ATE b_stat_adv_guest SET `DATE_HOST_HIT` = now() WHERE ADV_ID=5 and IP_NUMBER='2999996976' and BA | | 654 | a15450_07 | localhost | a15450_bitom | Query | 0 | Waiting for table level lock | UPD ATE b_iblock_element SET TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | | 659 | a15450_07 | localhost | a15450_bitom | Query | 13 | Waiting for table level lock | UPD ATE b_stat_adv_guest SE T `DATE_HOST_HIT` = now() WHERE ADV_ID=7 and IP_NUMBER='2999996976' and BA | | 678 | a15450_07 | localhost | a15450_bitom | Query | 13 | Waiting for table level lock | SEL ECT 'x' FR OM b_stat_adv_guest WHERE ADV_ID=7 and GUEST_ID=738938 and BACK='Y' | | 695 | a15450_07 | localhost | a15450_bitom | Query | 5 | Waiting for table level lock | UPDATE b_iblock_element SE T TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | | 733 | a15450_07 | localhost | a15450_bitom | Sleep | 0 | | NULL | | 747 | a15450_07 | localhost | a15450_bitom | Sleep | 6 | | NULL | | 751 | a15450_07 | localhost | a15450_bitom | Query | 13 | Waiting for table level lock | SEL ECT 'x' FROM b_stat_adv_guest WH ERE ADV_ID=5 and GUEST_ID=724868 and BACK='Y' | | 758 | a15450_07 | localhost | a15450_bitom | Query | 13 | Waiting for table level lock | SEL ECT count(1) ADV_GUESTS, DATE_FORMAT(max(DATE_GUEST_HIT), '%d.%m.%Y') MAX_DATE_GUEST_HIT | | 776 | a15450_07 | localhost | a15450_bitom | Sleep | 15 | | NULL | | 777 | a15450_07 | localhost | a15450_bitom | Sleep | 1 | | NULL | | 781 | a15450_07 | localhost | a15450_bitom | Query | 1 | Sorting for group | SELECT stags.NAME ,COUNT(DISTINCT stags.SEARCH_CONTENT_ID) as CNT FR OM b_search_tags stags | | 789 | a15450_07 | localhost | a15450_bitom | Sleep | 37 | | NULL | | 796 | a15450_07 | localhost | a15450_bitom | Sleep | 30 | | NULL | | 805 | a15450_07 | localhost | a15450_bitom | Query | 7 | preparing | SELECT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_ID,IF(EXTRACT(HOUR_SECOND FR OM BE.ACTIVE_FROM)>0, DATE_FO | | 808 | a15450_07 | localhost | a15450_bitom | Sleep | 22 | | NULL | | 819 | a15450_07 | localhost | a15450_bitom | Query | 10 | Waiting for table level lock | SELECT count(1) ADV_HOSTS, DATE_FORMAT(max(DATE_HOST_HIT), '%d.%m.%Y') MAX_DATE_HOST_HIT | | 821 | a15450_07 | localhost | a15450_bitom | Query | 3 | Waiting for table level lock | SELECT COUNT('x') as C FR OM b_iblock B INNER JOIN b_lang L ON B.LID=L.LID INNER JOIN b_ibl | | 822 | a15450_07 | localhost | a15450_bitom | Query | 3 | 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 | | 823 | a15450_07 | localhost | a15450_bitom | Query | 5 | Waiting for table level lock | UPDATE b_iblock_element SE T TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | | 825 | a15450_07 | localhost | a15450_bitom | Query | 5 | Waiting for table level lock | UPDATE b_iblock_element SE T TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | | 826 | a15450_07 | localhost | a15450_bitom | Query | 4 | Waiting for table level lock | SELECT BE.ID as ID,BE.NAME as NAME,BE.IBLOCK_ID as IBLOCK_ID,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION | | 827 | a15450_07 | localhost | a15450_bitom | Query | 1 | Waiting for table level lock | SELECT BE.ID as ID,BE.NAME as NAME,BE.IBLOCK_ID as IBLOCK_ID,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION | | 828 | a15450_07 | localhost | a15450_bitom | Query | 3 | Waiting for table level lock | SELECT BE.ID as ID,BE.NAME as NAME,BE.IBLOCK_ID as IBLOCK_ID,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION | | 829 | a15450_07 | localhost | a15450_bitom | Query | 2 | Waiting for table level lock | SELECT BE.ID as ID,BE.NAME as NAME,BE.IBLOCK_ID as IBLOCK_ID,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION | | 830 | a15450_07 | localhost | a15450_bitom | Sleep | 5 | | NULL | | 831 | a15450_07 | localhost | a15450_bitom | Sleep | 1 | | NULL | | 832 | a15450_07 | localhost | a15450_bitom | Query | 1 | Waiting for table level lock | SELECT BE.ID as ID,BE.NAME as NAME,BE.IBLOCK_ID as IBLOCK_ID,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION | | 835 | a15450_07 | localhost | a15450_bitom | Sleep | 4 | | NULL | | 836 | a15450_07 | localhost | NULL | Query | 0 | NULL | show processlist | | 837 | a15450_07 | localhost | a15450_bitom | Query | 0 | Opening tables | SELECT CITY.ID CITY_ID ,CITY.COUNTRY_ID ,C.SHORT_NAME COUNTRY_SHORT_NAME ,C.NAME COU | | 838 | a15450_07 | localhost | a15450_bitom | Sleep | 3 | | NULL | | 839 | a15450_07 | localhost | a15450_bitom | Sleep | 2 | | NULL | | 840 | a15450_07 | localhost | a15450_bitom | Sleep | 0 | | NULL | | 841 | a15450_07 | localhost | a15450_bitom | Sleep | 0 | | NULL | +-----+-----------+-----------+--------------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+ |