Проблема с пингом игроков

[Romanbalzhik]

Ошибка

При смене карты в начале у всех игроков поднимается от 100 и выше на пару секунд + подвисает

ОС

Linux

Amx Mod X

AMX Mod X 1.9.0.5294

Билд

ReHLDS version: 3.11.0.767-dev

ReGamedll

ReGameDLL version: 5.21.0.540-dev

Версия Metamod

Metamod-r v1.3.0.128, API (5:13)

Список метамодулей

[ 1] SafeNameAndChat  RUN   -    SafeNameAndChat.so          v1.1             ini  ANY   ANY  

 [ 2] Reunion          RUN   -    reunion_mm_i386.so          v0.1.92d         ini  Start Never

 [ 3] VoiceTranscoder  RUN   -    VoiceTranscoder.so          v2017RC5         ini  ANY   ANY  

 [ 4] AMX Mod X        RUN   -    amxmodx_mm_i386.so          v1.9.0.5294      ini  Start ANY  

 [ 5] ReSemiclip       RUN   -    resemiclip_mm_i386.so       v2.3.9           ini  Chlvl ANY  

 [ 6] WHBlocker        RUN   -    whblocker_mm_i386.so        v1.5.697         ini  Chlvl ANY  

 [ 7] Rechecker        RUN   -    rechecker_mm_i386.so        v2.7             ini  Chlvl ANY  

 [ 8] ReAuthCheck      RUN   -    reauthcheck_mm_i386.so      v0.1.6           ini  Start Never

 [ 9] ReSRDetector     RUN   -    resrdetector_mm_i386.so     v0.1.0           ini  Chlvl ANY  

 [10] MySQL            RUN   -    mysql_amxx_i386.so          v1.9.0.5294      pl4  ANY   ANY  

 [11] Ham Sandwich     RUN   -    hamsandwich_amxx_i386.so    v1.9.0.5294      pl4  ANY   ANY  

 [12] CStrike          RUN   -    cstrike_amxx_i386.so        v1.9.0.5294      pl4  ANY   ANY  

 [13] Engine           RUN   -    engine_amxx_i386.so         v1.9.0.5294      pl4  ANY   ANY  

 [14] FakeMeta         RUN   -    fakemeta_amxx_i386.so       v1.9.0.5294      pl4  ANY   ANY  

 [15] ReAimDetector    RUN   -    reaimdetector_amxx_i386.so  v0.2.2           pl4  ANY   Never

 [16] SxGeo            RUN   -    sxgeo_amxx_i386.so          v2.2             pl4  ANY   Never

 [17] CSX              RUN   -    csx_amxx_i386.so            v1.9.0.5294      pl4  ANY   ANY  

 [18] ReAPI            RUN   -    reapi_amxx_i386.so          v5.21.0.252-dev  pl4  ANY   Never

18 plugins, 18 running

Список плагинов

[  1] GameCMS_API             5.5.5       zhorzh78          gamecms_api_5.5  running  

 [  2] GameCMS_Registration    1.5         zhorzh78          gamecms_registr  running  

 [  3] GameCMS BonusSystem     1.1         +- DUKKHAZ0R      gamecms_bonus.a  running  

 [  4] [190] AMXBans RBS       20.06.06    SKAJIbnEJIb & La  amxbans_rbs.amx  running  

 [  5] ReAimDetector API       0.2.2       ReHLDS Team       reaimdetector.a  running  

 [  6] ReChecker Logging       1.0         custom            rc_logging.amxx  running  

 [  7] Anti Flood              1.9.0.5294  AMXX Dev Team     antiflood.amxx   running  

 [  8] [190] FG RconShop       21.09.12    SKAJIbnEJIb       fg_rconshop.amx  running  

 [  9] [190] Cvar On Map       20.06.06    SKAJIbnEJIb       cvar_on_map.amx  running  

 [ 10] [190] Ultimate Weapons  21.08.23BE  SKAJIbnEJIb       ultimate_weapon  running  

 [ 11] [190] Ultimate Gag      21.01.02BE  SKAJIbnEJIb       ultimate_gag.am  running  

 [ 12] [190] VIP RBS           21.08.23BE  SKAJIbnEJIb       vip_rbs.amxx     running  

 [ 13] [190] Skill ELO         21.08.22BE  SKAJIbnEJIb       skill_elo.amxx   running  

 [ 14] [190] CsStats MySQL     21.08.22BE  SKAJIbnEJIb       csstats_mysql.a  running  

 [ 15] [190] BonusMenu RBS     21.08.23BE  SKAJIbnEJIb       bonusmenu_rbs.a  running  

 [ 16] [190] Army Ranks Ultim  20.06.06    SKAJIbnEJIb       army_ranks_ulti  running  

 [ 17] [190] Stimulation RBS   20.06.06    SKAJIbnEJIb       stimulation_rbs  running  

 [ 18] [190] Chat RBS          20.10.24BE  SKAJIbnEJIb       chat_rbs.amxx    running  

 [ 19] [190] MapsMenu RBS      20.06.06    SKAJIbnEJIb & AM  mapsmenu_rbs.am  running  

 [ 20] [190] AdminCmd RBS      21.08.22BE  SKAJIbnEJIb & AM  admincmd_rbs.am  running  

 [ 21] Menus Front-End         20.06.06    SKAJIbnEJIb & AM  amxmodmenu_rbs.  running  

 [ 22] [190] Damager RBS       20.06.06    SKAJIbnEJIb       damager_rbs.amx  running  

 [ 23] [190] Stats Configurat  20.06.06    SKAJIbnEJIb & AM  statscfg_rbs.am  running  

 [ 24] [190] StatsX RBS        21.03.23    SKAJIbnEJIb & AM  statsx_rbs.amxx  running  

 [ 25] [190] Ultimate Flags    21.03.24BE  SKAJIbnEJIb       ultimate_flags.  running  

 [ 26] [190] Ad From Server    20.06.06    SKAJIbnEJIb       ad_from_server.  running  

 [ 27] [190] MapChooser RBS    20.08.02    SKAJIbnEJIb & UF  mapchooser_rbs.  running  

 [ 28] [190] Screen Player     20.06.06    SKAJIbnEJIb       screen_player.a  running  

 [ 29] [190] Ultimate Informe  21.03.23    SKAJIbnEJIb       ultimate_inform  running  

 [ 30] [190] Ultimate Models   21.08.23BE  SKAJIbnEJIb       ultimate_models  running  

 [ 31] [190] VoteBan RBS       20.06.06    SKAJIbnEJIb       voteban_rbs.amx  running  

 [ 32] [190] Top Award RBS     20.06.06    SKAJIbnEJIb       topaward_rbs.am  running  

 [ 33] [190] BonusTime RBS     20.08.08    SKAJIbnEJIb       bonustime_rbs.a  running  

 [ 34] [190] WallHack Viewer   20.06.06    SKAJIbnEJIb       wallhack_viewer  running  

 [ 35] [190] No Team Flash     20.06.06    SKAJIbnEJIb       NoTeamFlash.amx  running  

 [ 36] [190] DemoRecorder RBS  20.06.06    SKAJIbnEJIb       demorecorder_rb  running  

 [ 37] [190] CsStats ResetSco  20.06.06    SKAJIbnEJIb       csstats_resetsc  running  

 [ 38] [190] RestMenu RBS      20.06.06    SKAJIbnEJIb & AM  restmenu_rbs.am  running  

 [ 39] [190] High Ping Kicker  20.06.06    SKAJIbnEJIb       hpk_rbs.amxx     running  

 [ 40] [190] Parachute RBS     20.08.22BE  SKAJIbnEJIb & KR  parachute_rbs.a  running  

 [ 41] [190] BackWeapons RBS   20.06.06    SKAJIbnEJIb & ho  backweapons_rbs  running  

 [ 42] [190] AfkKicker RBS     21.08.22BE  SKAJIbnEJIb       afkkicker_rbs.a  running  

 [ 43] [190] Kill Assist RBS   20.06.06    SKAJIbnEJIb & Di  killassist_rbs.  running  

 [ 44] [190] Snipers RBS       20.06.06    SKAJIbnEJIb       snipers_rbs.amx  running  

 [ 45] [190] Bets RBS          20.10.24BE  SKAJIbnEJIb       bets_rbs.amxx    running  

 [ 46] [190] PTB RBS           20.06.06    SKAJIbnEJIb       ptb_rbs.amxx     running  

 [ 47] [190] NextMap           18.09.25    SKAJIbnEJIb & AM  nextmap.amxx     running  

 [ 48] [190] TimeLeft          18.09.25    SKAJIbnEJIb & AM  timeleft.amxx    running  

 [ 49] [190] ESP RBS           20.06.06    SKAJIbnEJIb & Ko  esp_rbs.amxx     running  

 [ 50] [190] Block Reconnect   20.06.06    ShaTalKiN         Block_Reconnect  running  

 [ 51] [190] Radio RBS         20.06.06    SKAJIbnEJIb       radio_rbs.amxx   running  

 [ 52] [190] MOTD RBS          21.03.23    SKAJIbnEJIb       motd_rbs.amxx    running  

 [ 53] [190] AdminChat RBS     21.08.22BE  SKAJIbnEJIb       adminchat_rbs.a  running  

 [ 54] CheckSteamID            1.0         ApXuTekToR        CheckSteamID.am  running  

 [ 55] Music Connect           1.1         Leo_[BH]          music_connect.a  running  

 [ 56] MOTD Model              1.1.0       fl0wer            motd_model.amxx  running  

 [ 57] Ultimate Sounds         1.7         Dizzy / Bmann_42  f_ultimate_soun  running  

 [ 58] [ReAPI] Healthnade      0.0.2       F@nt0M            reapi_healthnad  running  

 [ 59] Weapon Model + Sound R  1.2         GHW_Chronic       new_weapons.amx  running  

 [ 60] [SxGeo] Connect Info    1.0         s1lent            sxgeo_connect_i  running  

 [ 61] Custom Smoke            1.1         medusa            custom_smoke_st  running  

 [ 62] [DD] Quick defuse       1.0         Deadly|Darkness   dd_qdefuse.amxx  running  

 [ 63] [MG] Sky                1.0         Nickron           mg_sky.amxx      running  

 [ 64] [ReAPI] AdminFreeLook   1.0         ReHLDS Team       adminfreelook.a  running  

 [ 65] WalkGuard               1.3.2       mogel             walkguard.amxx   running  

 [ 66] Mode 2x2                2.5re       s1lent            mode_2x2.amxx    running  

 [ 67] Weapon Kill             1.2         Slove. & AcE      weaponkill.amxx  running  

 [ 68] [ReAPI] Random Weapons  2.4.9       neugomon/h1k3     random_weapons_  running  

 [ 69] Kills Counter           1.0         Safety1st         killscounter.am  running  

 [ 70] C4 Timer on roundtime   0.3.3a      neygomon          c4timer.amxx     running  

70 plugins, 70 running

При смене карты в начале у всех игроков поднимается от 100 и выше на пару секунд + подвисает. Человек подсказал что проблема может быть с подключением к бд. Надеюсь на вашу помощь)

6 Мар 2022

И вообще не помешала бы диагностика сервера

 

[Алексеич]

Romanbalzhik, так отключи плагины, которые работают с БД. выясни виновника.

 

[Romanbalzhik]

Понял, всё же проблема с подключением плагинов к бд. Как решать? плагины эти нужны) запрос скорее всего не сразу приходит

 

[Алексеич]

Romanbalzhik, не вижу проблем выключить плагины на одну карту. потом на следующую другой кусок плагинов.
ничего не вижу криминального, если кто-то поиграет без випки, статы, админки и так далее одну, две, три карты.

 

[Romanbalzhik]

Алексеич, уже выявил. вот 3 плагина которые подключатся к бд
AMXBans RBS
GameCMS_API
CsStats MySQL
Дело в том что они все нужны на сервере

 

[RockTheStreet]

Проблема со стороны БД, а не со стороны плагинов. Ответ от БД долгий, отсюда и проблема.

 

[XyLiGaN]

Romanbalzhik, Раздели на каждый плагин по БД. Ну и AMXBans RBS, лучше будет заменить на Fresh Bans.

 

[RockTheStreet]

Ну и AMXBans RBS, лучше будет заменить на Fresh Bans

Почему?

 

[XyLiGaN]

RockTheStreet, Патаму шта гладиолус.