XF 1.5 Превышены лимиты нагрузки

[zayka42]

Хостер отключил сайт, говорит что проблема у меня, выдал вот это

спойлер

LA=5
PIDS=
CPU=%
MEM=%
SQL=308%

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ UID COMMAND (TOP)
-----------------------------------------------------------------------


Id User Host db Command Time State Info (SQL)
-----------------------------------------------------------------------
7525 zayka42_horka localhost zayka42_horka Execute 57383 Creating delayed handler REPLACE DELAYED INTO xf_search_index
                                (content_type, content_id,
                                title, message, metadata,

15947 zayka42_horka localhost zayka42_horka Execute 57097 Creating delayed handler INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                ('5303')
16537 zayka42_horka localhost zayka42_horka Execute 57074 Creating delayed handler INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                ('5303')
29269 zayka42_horka localhost zayka42_horka Execute 56631 Waiting for table metadata lock TRUNCATE TABLE xf_thread_view
30058 zayka42_horka localhost zayka42_horka Execute 56605 Creating delayed handler REPLACE DELAYED INTO xf_search_index
                                (content_type, content_id,
                                title, message, metadata,

30755 zayka42_horka localhost zayka42_horka Execute 56580 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                                (attachment_id)
                        VALUES
                                ('381')
31208 zayka42_horka localhost zayka42_horka Execute 56566 Creating delayed handler REPLACE DELAYED INTO xf_search_index
                                (content_type, content_id,
                                title, message, metadata,

32043 zayka42_horka localhost zayka42_horka Execute 56534 Creating delayed handler REPLACE DELAYED INTO xf_search_index
                                (content_type, content_id,
                                title, message, metadata,

32580 zayka42_horka localhost zayka42_horka Prepare 56515 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
32729 zayka42_horka localhost zayka42_horka Prepare 56509 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
518591 zayka42_horka localhost zayka42_horka Prepare 36912 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
519329 zayka42_horka localhost zayka42_horka Prepare 36870 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
519421 zayka42_horka localhost zayka42_horka Prepare 36864 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
520114 zayka42_horka localhost zayka42_horka Prepare 36823 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
521864 zayka42_horka localhost zayka42_horka Prepare 36725 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
523298 zayka42_horka localhost zayka42_horka Prepare 36650 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
523787 zayka42_horka localhost zayka42_horka Prepare 36621 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
523959 zayka42_horka localhost zayka42_horka Prepare 36610 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
524693 zayka42_horka localhost zayka42_horka Prepare 36575 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
525725 zayka42_horka localhost zayka42_horka Prepare 36523 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
696518 zayka42_horka localhost zayka42_horka Prepare 27119 Waiting for table metadata lock UPDATE xf_thread
                        INNER JOIN (
                                SELECT thread_id, COUNT(*) AS total
                                FROM xf_thread_view

696666 zayka42_horka localhost zayka42_horka Prepare 27111 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
700092 zayka42_horka localhost zayka42_horka Prepare 26899 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
702174 zayka42_horka localhost zayka42_horka Prepare 26771 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
703523 zayka42_horka localhost zayka42_horka Prepare 26689 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
703996 zayka42_horka localhost zayka42_horka Prepare 26663 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
704612 zayka42_horka localhost zayka42_horka Prepare 26626 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
706518 zayka42_horka localhost zayka42_horka Prepare 26522 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
706886 zayka42_horka localhost zayka42_horka Prepare 26503 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
715309 zayka42_horka localhost zayka42_horka Execute 25986 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                                (attachment_id)
                        VALUES
                                ('175')
715725 zayka42_horka localhost zayka42_horka Prepare 25959 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
716587 zayka42_horka localhost zayka42_horka Execute 25911 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                                (attachment_id)
                        VALUES
                                ('175')
936362 zayka42_horka localhost zayka42_horka Prepare 13143 Waiting for table metadata lock UPDATE xf_thread
                        INNER JOIN (
                                SELECT thread_id, COUNT(*) AS total
                                FROM xf_thread_view

936455 zayka42_horka localhost zayka42_horka Prepare 13140 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
939757 zayka42_horka localhost zayka42_horka Prepare 12960 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
939803 zayka42_horka localhost zayka42_horka Prepare 12958 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
940072 zayka42_horka localhost zayka42_horka Prepare 12943 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
940341 zayka42_horka localhost zayka42_horka Prepare 12928 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
940395 zayka42_horka localhost zayka42_horka Prepare 12925 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
941162 zayka42_horka localhost zayka42_horka Execute 12883 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                                (attachment_id)
                        VALUES
                                ('938')
941164 zayka42_horka localhost zayka42_horka Execute 12883 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                                (attachment_id)
                        VALUES
                                ('940')
941299 zayka42_horka localhost zayka42_horka Prepare 12875 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
947586 zayka42_horka localhost zayka42_horka Prepare 12547 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
947686 zayka42_horka localhost zayka42_horka Prepare 12542 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
951858 zayka42_horka localhost zayka42_horka Prepare 12332 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
952108 zayka42_horka localhost zayka42_horka Prepare 12318 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
952725 zayka42_horka localhost zayka42_horka Prepare 12283 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
953094 zayka42_horka localhost zayka42_horka Prepare 12261 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
953225 zayka42_horka localhost zayka42_horka Prepare 12255 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
955808 zayka42_horka localhost zayka42_horka Prepare 12128 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                                (thread_id)
                        VALUES
                                (?)
1155523 zayka42_tmp_ localhost zayka42_horka Query 2893 Waiting for table metadata lock REPAIR TABLE `EWRporta2_articles`, `EWRporta2_authors`, `EWRporta2_categories`, `EWRporta2_catlinks`
1155525 zayka42_tmp_ localhost  Sleep 2893
1208114 zayka42_tmp_ localhost zayka42_horka Query 851 Waiting for table metadata lock SELECT * FROM `EWRporta2_articles` LIMIT 0, 25
1208115 zayka42_tmp_ localhost  Sleep 851
1209501 zayka42_tmp_ localhost zayka42_horka Query 797 Waiting for table metadata lock SELECT * FROM `EWRporta2_articles` LIMIT 0, 25
1209502 zayka42_tmp_ localhost  Sleep 797
1210439 zayka42_tmp_ localhost zayka42_horka Query 764 Waiting for table metadata lock SELECT * FROM `EWRporta2_articles` LIMIT 0, 25
1210440 zayka42_tmp_ localhost  Sleep 764
1211737 zayka42_tmp_ localhost zayka42_horka Query 719 Waiting for table metadata lock SELECT COUNT(*) FROM `zayka42_horka`.`EWRporta2_articles`
1211738 zayka42_tmp_ localhost  Sleep 720


Srv PID Acc M CPU  SS Req Conn Child Slot Client VHost Request (APACHE)

 

[grisha2217]

zayka42, попробуйте.


а также, смените хостинг.

 

[zayka42]

где такая опция ?

 

[tnAnGel]

zayka42, admin.php?options/list/performance

 

[zayka42]

нет доступа к админке, буду клянчить хостера включить акк

 

[Экстрим]

нет доступа к админке, буду клянчить хостера включить акк

а как так, что нет доступа к админке форума? Форум Ваш? Значит и доступ должен быть. К хостеру никак он не относится

 

[grisha2217]

Экстрим, человеку отключили сайт полностью

 

[Экстрим]

Экстрим, человеку отключили сайт полностью

а, ну если только так...

 

[zayka42]

написали что включен, выдает ошибку 503 The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

логи

LA=5
PIDS=13
CPU=0%
MEM=2%
SQL=3.1%

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ UID COMMAND (TOP)
-----------------------------------------------------------------------
 1583 zayka42 30 10 1017032 66412 22012 S 0.0 0.2 0:00.02 1195 /usr/sbin/apache2 -k restart
 4778 zayka42 30 10 1017032 66432 22032 S 0.0 0.2 0:00.02 1195 /usr/sbin/apache2 -k restart
 5377 zayka42 30 10 1017032 66432 22032 S 0.0 0.2 0:00.03 1195 /usr/sbin/apache2 -k restart
 8339 zayka42 30 10 1017032 66316 22032 S 0.0 0.2 0:00.03 1195 /usr/sbin/apache2 -k restart
 11525 zayka42 30 10 1014984 64324 21968 S 0.0 0.2 0:00.02 1195 /usr/sbin/apache2 -k restart
 13611 zayka42 20 0 109752 8392 6096 S 0.0 0.0 0:00.01 1195 proftpd: zayka42_1 - 176.196.101.118: IDLE
 15032 zayka42 20 0 110632 9376 6096 S 0.0 0.0 0:00.34 1195 proftpd: zayka42_1 - 176.196.101.118: RETR 15147-e02674707d12e1c+
 15360 zayka42 30 10 1014984 64324 21968 S 0.0 0.2 0:00.02 1195 /usr/sbin/apache2 -k restart
 16185 zayka42 20 0 110376 9112 6096 S 0.0 0.0 0:00.25 1195 proftpd: zayka42_1 - 176.196.101.118: RETR 15795-366b489611847a6+
 16452 zayka42 30 10 1017004 65048 20660 S 0.0 0.2 0:00.05 1195 /usr/sbin/apache2 -k restart
 17511 zayka42 30 10 1014984 64132 21776 S 0.0 0.2 0:00.02 1195 /usr/sbin/apache2 -k restart
 26410 zayka42 30 10 1014984 64324 21968 S 0.0 0.2 0:00.02 1195 /usr/sbin/apache2 -k restart
 29944 zayka42 30 10 1017032 66316 22032 S 0.0 0.2 0:00.03 1195 /usr/sbin/apache2 -k restart


Id User Host DB Command Time State Info (SQL)
-----------------------------------------------------------------------
7525 zayka42_horka localhost zayka42_horka Killed 67042 Creating delayed handler REPLACE DELAYED INTO xf_search_index
                (content_type, content_id,
                title, message, metadata,
        
15947 zayka42_horka localhost zayka42_horka Killed 66756 Creating delayed handler INSERT DELAYED INTO xf_thread_view
                (thread_id)
            VALUES
                ('5303')
16537 zayka42_horka localhost zayka42_horka Killed 66733 Creating delayed handler INSERT DELAYED INTO xf_thread_view
                (thread_id)
            VALUES
                ('5303')
30058 zayka42_horka localhost zayka42_horka Killed 66264 Creating delayed handler REPLACE DELAYED INTO xf_search_index
                (content_type, content_id,
                title, message, metadata,
        
30755 zayka42_horka localhost zayka42_horka Killed 66239 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                (attachment_id)
            VALUES
                ('381')
31208 zayka42_horka localhost zayka42_horka Killed 66225 Creating delayed handler REPLACE DELAYED INTO xf_search_index
                (content_type, content_id,
                title, message, metadata,
        
32043 zayka42_horka localhost zayka42_horka Killed 66193 Creating delayed handler REPLACE DELAYED INTO xf_search_index
                (content_type, content_id,
                title, message, metadata,
        
715309 zayka42_horka localhost zayka42_horka Killed 35645 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                (attachment_id)
            VALUES
                ('175')
716587 zayka42_horka localhost zayka42_horka Killed 35570 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                (attachment_id)
            VALUES
                ('175')
941162 zayka42_horka localhost zayka42_horka Killed 22542 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                (attachment_id)
            VALUES
                ('938')
941164 zayka42_horka localhost zayka42_horka Killed 22542 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                (attachment_id)
            VALUES
                ('940')
1240452 zayka42_horka localhost zayka42_horka Execute 9227 Creating delayed handler INSERT DELAYED INTO xf_thread_view
                (thread_id)
            VALUES
                ('2043')
1240595 zayka42_horka localhost zayka42_horka Execute 9221 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                (attachment_id)
            VALUES
                ('559')
1241509 zayka42_horka localhost zayka42_horka Execute 9184 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                (attachment_id)
            VALUES
                ('938')
1242488 zayka42_horka localhost zayka42_horka Execute 9148 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                (attachment_id)
            VALUES
                ('939')
1242538 zayka42_horka localhost zayka42_horka Execute 9146 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                (attachment_id)
            VALUES
                ('559')
1244521 zayka42_horka localhost zayka42_horka Execute 9071 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                (attachment_id)
            VALUES
                ('559')
1244825 zayka42_horka localhost zayka42_horka Execute 9060 Creating delayed handler INSERT DELAYED INTO xf_thread_view
                (thread_id)
            VALUES
                ('4836')
1245007 zayka42_horka localhost zayka42_horka Execute 9055 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                (attachment_id)
            VALUES
                ('920')
1246616 zayka42_horka localhost zayka42_horka Execute 8996 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                (attachment_id)
            VALUES
                ('559')
1250546 zayka42_horka localhost zayka42_horka Execute 8847 Creating delayed handler INSERT DELAYED INTO xf_thread_view
                (thread_id)
            VALUES
                ('4063')
1288849 zayka42_horka localhost zayka42_horka Execute 7406 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                (attachment_id)
            VALUES
                ('150')
1290959 zayka42_horka localhost zayka42_horka Execute 7331 Creating delayed handler INSERT DELAYED INTO xf_thread_view
                (thread_id)
            VALUES
                ('3892')
1293056 zayka42_horka localhost zayka42_horka Execute 7256 Creating delayed handler INSERT DELAYED INTO xf_thread_view
                (thread_id)
            VALUES
                ('3892')
1295020 zayka42_horka localhost zayka42_horka Execute 7181 Creating delayed handler INSERT DELAYED INTO xf_thread_view
                (thread_id)
            VALUES
                ('3892')
1295379 zayka42_horka localhost zayka42_horka Execute 7168 Creating delayed handler INSERT DELAYED INTO xf_thread_view
                (thread_id)
            VALUES
                ('2915')
1296928 zayka42_horka localhost zayka42_horka Execute 7106 Creating delayed handler INSERT DELAYED INTO xf_thread_view
                (thread_id)
            VALUES
                ('3892')
1298745 zayka42_horka localhost zayka42_horka Execute 7031 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                (attachment_id)
            VALUES
                ('150')
1300617 zayka42_horka localhost zayka42_horka Execute 6956 Creating delayed handler INSERT DELAYED INTO xf_attachment_view
                (attachment_id)
            VALUES
                ('150')
1301307 zayka42_horka localhost zayka42_horka Execute 6934 Waiting for table metadata lock TRUNCATE TABLE xf_thread_view
1301910 zayka42_horka localhost zayka42_horka Prepare 6911 Waiting for table metadata lock INSERT DELAYED INTO xf_thread_view
                (thread_id)
            VALUES
                (?)


Srv PID Acc M CPU  SS Req Conn Child Slot Client VHost Request (APACHE)
-----------------------------------------------------------------------
9-12 6496 0/615/19137 G 0.00 7031 0 0.0 13.14 407.12 130.193.50.7 promoney.org:8070 GET /attachments/1-logog-jpg.150/ HTTP/1.0
10-12 12518 0/65/7923 G 0.07 6934 0 0.0 1.00 178.75 5.44.172.69 promoney.org:8070 POST /deferred.php HTTP/1.0
11-12 6497 0/670/24805 G 0.00 6956 0 0.0 14.02 514.90 130.193.37.11 promoney.org:8070 GET /attachments/1-logog-jpg.150/ HTTP/1.0
18-17 16746 0/50/9707 _ 0.00 0 1 0.0 1.28 220.64 207.46.13.98 promoney.org:8070 GET /threads/gold-clicks-ru.4269/ HTTP/1.0
29-12 6513 0/294/9023 G 0.00 7406 0 0.0 7.22 183.38 141.8.142.142 promoney.org:8070 GET /attachments/1-logog-jpg.150/ HTTP/1.0
43-12 6583 0/484/814 G 0.00 7167 0 0.0 11.65 18.95 40.77.167.36 promoney.org:8070 GET /threads/forexpalm-www-forexpalm-com.2915/ HTTP/1.0
45-12 6586 0/479/479 G 0.01 7181 0 0.0 10.59 10.59 141.8.142.50 promoney.org:8070 GET /threads/analiz-rynka-ot-icmarkets.3892/ HTTP/1.0
46-12 6589 0/538/538 G 0.00 7106 0 0.0 12.26 12.26 93.158.152.14 promoney.org:8070 GET /threads/analiz-rynka-ot-icmarkets.3892/ HTTP/1.0
47-12 6590 0/425/425 G 0.06 7256 0 0.0 9.08 9.08 5.255.253.66 promoney.org:8070 GET /threads/analiz-rynka-ot-icmarkets.3892/ HTTP/1.0
49-12 6594 0/705/705 G 0.02 6911 0 0.0 15.57 15.57 5.44.172.69 promoney.org:8070 GET /threads/paroli-na-frirolly.5205/page-3 HTTP/1.0
56-12 6604 0/362/362 G 0.02 7331 0 0.0 7.93 7.93 5.255.253.45 promoney.org:8070 GET /threads/analiz-rynka-ot-icmarkets.3892/ HTTP/1.0

 

[tnAnGel]

zayka42, видно же, что лимиты превышает. Выкачивай бекап сейчас и ставь к примеру на OpenServer. Заходим в панель и редактируем в адмике. Далее обратно заливаем бд. Лучше переехать или сменить тариф, а еще лучше снять VPS'ку и не будет никаких ограничений, кроме как железа.

 

[zayka42]

теперь решил vps купить у ovh ждать только надо пока документы подтвердят и карту. Как то резко лимиты превысились посетителей почти нет

отложенная вставка была включена, я так понимаю только менять хостера ?

 

[Hope]

я так понимаю только менять хостера ?

Да.

 

[zayka42]

кое как за сутки переехал, долго мучился с импортом бд, в итоге выставив max_execution_time и max_input_time 330000000 импорт прошёл. Думаю памяти 512Mb маловато, веста уже кажет загрузку почти на максимум

 

[Mirovinger]

Малова-то, но знаю что форумы работают уже не один год и на таких ВДС, а БД нужно было через консоль импортировать.

 

[zayka42]

в итоге с третьего раза через консоль встала