Jump to content

Game Performance Discussion / MySQL Indexing / Other Options

iMeleys
 Share

Recommended Posts

iMeleys Community Regular

iMeleys 312

Posted
Posted

1) How i can use MySQL Indexing with the M2 Database
2) What we can do about the "lags" ingame to improve the Players Game Quality
3) What we can do to optimize the MySQL Performance is it better to use MariaDB ?
4) What we also have for Options to improve the Players Game Quality. ?
5) Should i disable useless Logs to improve the Performance ?

Tipp) it reduce the lags if you run your database just on "localhost" and you can also use
navicat if u use a SSH Tunel with SSH Keys and you will see a change after u do that and maybe someone
doesnt have it allready and i help him with it i know its nothing but hey its a begining..

Tipp2) it reduce the lags if you compiler your Binary in distribute Option its faster then the
other options as release and debug ! realy meleys why you say that? (bcs newer users dont know that!)
and by the way work together as a community together we find better solutions

Link to comment
Share on other sites
  • Replies 17
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

flexio
flexio

Primary problem with lags is in packet delay- I fixed it by disable packet encryption and little change in void CPythonNetworkStream::GamePhase()   *inspired by martysama*

WeedHex
WeedHex

I suggest also: 5) How can I disable every useless log that will kill my memory during the months.

WeedHex
WeedHex

I told "Useless" I don't understand your english very well but I understand that you don't like to get help. It was a suggestion from my experience. 

iMeleys Community Regular

iMeleys 312

Posted
  • Author
Posted
On 7/25/2019 at 3:47 PM, WeedHex said:

5) How can I disable every useless log that will kill my memory.

i do not wanna disable any logs ? i need it i do not know what
u dont like but (maybe because my english is shit) you dont have to
be harsh or "funny for the community" i allready know that im not the best but i learn everyday.

Link to comment
Share on other sites
iMeleys Community Regular

iMeleys 312

Posted
  • Author
Posted
On 7/25/2019 at 3:51 PM, WeedHex said:

I told "Useless"

I don't understand your english very well but I understand that you don't like to get help.

It was a suggestion from my experience. 

 im sorry that i say that to you. i report my answer to remove it now.. im sorry realy.
 it was just a misstake xD

Link to comment
Share on other sites
flexio Collaborator

flexio 83

Posted
Posted

About server performance. You don't need anything big, server is ready for X thousand players by default. Just do not be paranoid about perfomance things.

I use novaline only with rewrited select querys to smart pointers, and updated boost. Tested with 2500+ online players without problem (i7-6700, freebsd 12, 32GB RAM, 6 channels). 

About client perfomance. First - Do not touch ymir texture files, Second - Do not use a lot of trees and objects on the map, Three - Be a good c++ programmer for rewrite some things (btw. i am not). 

 

 

 

  • Love 1
Link to comment
Share on other sites
iMeleys Community Regular

iMeleys 312

Posted
  • Author
Posted
vor 7 Stunden schrieb flexio:

About server performance. You don't need anything big, server is ready for X thousand players by default. Just do not be paranoid about perfomance things.

I use novaline only with rewrited select querys to smart pointers, and updated boost. Tested with 2500+ online players without problem (i7-6700, freebsd 12, 32GB RAM, 6 channels). 

About client perfomance. First - Do not touch ymir texture files, Second - Do not use a lot of trees and objects on the map, Three - Be a good c++ programmer for rewrite some things (btw. i am not). 

 

 

 

The Problem in my mind is following situation i know that on Metin2.DE on the first map1 blue , there stands arround mhm maybe 900 Players and the server doesnt give any lags out and i do not realy understand it i can make everything against it buy a perfect server and optimize so many things but it its not like on .DE and i do not understand that and thats why i learning so intensive C++ to understand that problem and solve it.. thats the problem whats going on in my "crazy" mind. (and i also learn C++ to help the community and work as a Coder)

Link to comment
Share on other sites
flexio Collaborator

flexio 83

Posted
Posted (edited)
1 minute ago, iMeleys said:

The Problem in my mind is following situation i know that on Metin2.DE on the first map1 blue , there stands arround mhm maybe 900 Players and the server doesnt give any lags out and i do not realy understand it i can make everything against it buy a perfect server and optimize so many things but it is not like on .DE and i do not understand that and thats why i learning so intensive C++ to understand that problem and solve it.. thats the problem whats going on in my mind.

Primary problem with lags is in packet delay- I fixed it by disable packet encryption and little change in void CPythonNetworkStream::GamePhase()

 

DaH0.png

*inspired by martysama*

Edited by Metin2 Dev
Core X - External 2 Internal
  • Love 4
Link to comment
Share on other sites
iMeleys Community Regular

iMeleys 312

Posted
  • Author
Posted
vor 25 Minuten schrieb flexio:

Primary problem with lags is in packet delay- I fixed it by disable packet encryption and little change in void CPythonNetworkStream::GamePhase

*inspired by martysama*

Thank you for posting it but maybe this is only one problem from manys inside
the branch and yeah but everbody know now whats going on in my mind

maybe someone know more about it i will let this thread open for everyone and
together we can find a real solution for it.  (not mean your solution is not a
solution i mean its one thing to make it better but theres other solutions too)

Sincerly
Meleys

Link to comment
Share on other sites
iMeleys Community Regular

iMeleys 312

Posted
  • Author
Posted
vor 5 Stunden schrieb Kori:

In my opinion I don't remove the packet encryption and I can't find lags on my server but your screen is a good thing I will test @flexio

sorry that i write so much today but all what i wanna say if u run a test and load the metin2 client from
the official homepage u can run over the map1 and see (theeres no single lag) and if u make it on
your server u will see "micro lags" its sounds much less important then it is because if you have much

players like 2,000 on a daily base with "beautiful shinings" and much "objects" on maps u will get hard lags
and i mean this seriously its not a happy thing if your community suffer under that and "DE" had find a solution
and if they can do that we can also do it rubinum has also find a little solution not a perfect one but they give users

the option to hide this armore shinings and other stuff in the systemoptions and maybe other coders read this
think about this topic and have somenthing to say about it too i would be happy to see it

Sincerly
Your Meleys

Link to comment
Share on other sites
flexio Collaborator

flexio 83

Posted
Posted
1 hour ago, Kori said:

In my opinion I don't remove the packet encryption and I can't find lags on my server but your screen is a good thing I will test @flexio

For me lags happend when was 100+ players in view distance. Example delays for equip items. Edit from screen fix problem. And right, packet encryption primary changes auth/loading screen speed

  • Love 1
Link to comment
Share on other sites
iMeleys Community Regular

iMeleys 312

Posted
  • Author
Posted
vor 4 Stunden schrieb flexio:

For me lags happend when was 100+ players in view distance. Example delays for equip items. Edit from screen fix problem. And right, packet encryption primary changes auth/loading screen speed

right and this not happen on the official servers but what is the solution to it ? it must be a
realy simple solution.. and maybe someone have more knowledge about it then we have actually

was my last answer today and it was a realy hot day here 41*c here unbelivable hot and i couldnt even
thinking right over what i writing to the community ..

Sincerly
Meleys

Link to comment
Share on other sites
  • Active Member
Exygo Experienced

Exygo 1044

Posted
  • Active Member
Posted (edited)
4 hours ago, flexio said:

Primary problem with lags is in packet delay- I fixed it by disable packet encryption and little change in void CPythonNetworkStream::GamePhase()

 

DaH0.png

*inspired by martysama*

It's logic, they are set for the oldtimes when the hardware were not so advanced and very expensive and also ymir paranoia

Edited by Metin2 Dev
Core X - External 2 Internal
  • Love 1

qnZf3zg.png

https://www.youtube.com/channel/UCQ8mAeda9TWq6SsTzB53emw/videos

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share
Go to topic listing

Announcements



  • Similar Content

  • Activity

    1. 0

      We are looking for a C++ and Python programmer

      We are looking for a C++ and Python programmer for systems development and warfare for Metin2
      boloca in Paid Support / Searching / Recruiting
    2. 0

      [Quest Scheduler Request] Is there a way to make a quest run independet of player events? Lets say start quest automatically at server startup?

      The idea is, i want this quest to run regardless of player actions, at the moment it seems to start at player login ideally the quest would start at day Y(could have daily flag) hour X so basically a scheduler, so it won't be dependent on any player events quest test_npcmove begin state start begin when letter begin chat("Started") set_state("spawn_monster_in_map_boss_1") end end -- State to check for/spawn boss 1 state spawn_monster_in_map_boss_1 begin when letter begin chat("Spawning first boss") local mob_vnum = 102 -- Adjust VNUM for boss 1 local map_index = 352 local mobs = find_mobs_in_map(mob_vnum, map_index) local vid_boss1 = 0 local mobs_str = "BOSS 1 VIDs: {" .. table.concat(mobs, ", ") .. "}" chat(mobs_str) chat("Player X: " .. 339 .. " Y: " .. 363) if table.getn(mobs) > 0 then vid_boss1 = mobs[1] chat("Boss 1 found, using existing with VID: " .. tostring(vid_boss1)) else local vids = spawn_monster_in_map(mob_vnum, 1, false, map_index, 339, 363 + 10, true) vid_boss1 = vids[1] if vids[1] ~= nil then vid_boss1 = vids[1] chat("Boss 1 spawned with VID: " .. tostring(vid_boss1)) else vids = find_mobs_in_map(mob_vnum, map_index) vid_boss1 = vids[1] chat("Boss 2 fetched vid for spwaned mob: " .. tostring(vid_boss1)) end end pc.setqf("vid_boss1", vid_boss1) set_state("spawn_monster_in_map_boss_2") end end -- State to check for/spawn boss 2 state spawn_monster_in_map_boss_2 begin when letter begin local mob_vnum = 101 -- Adjust VNUM for boss 2 local map_index = 352 local mobs = find_mobs_in_map(mob_vnum, map_index) local vid_boss2 = 0 local mobs_str = "BOSS 2 VIDs: {" .. table.concat(mobs, ", ") .. "}" chat(mobs_str) if table.getn(mobs) > 0 then vid_boss2 = mobs[1] chat("Boss 2 found, using existing with VID: " .. tostring(vid_boss2)) else local vids = spawn_monster_in_map(mob_vnum, 1, false, map_index, 339, 363 - 10, true) vid_boss2 = vids[1] if vids[1] ~= nil then vid_boss2 = vids[1] chat("Boss 1 spawned with VID: " .. tostring(vid_boss2)) else vids = find_mobs_in_map(mob_vnum, map_index) vid_boss2 = vids[1] chat("Boss 2 fetched vid for spwaned mob: " .. tostring(vid_boss2)) end end pc.setqf("vid_boss2", vid_boss2) set_state("move_bosses") end end -- State to move both bosses state move_bosses begin when letter begin local vid_boss1 = pc.getqf("vid_boss1") local vid_boss2 = pc.getqf("vid_boss2") local target_x = 339 local target_y = 363 mob_move(vid_boss1, target_x, target_y) mob_move(vid_boss2, target_x, target_y) chat("Both bosses moved to player's position.") set_state("bosses_fight") end end -- State where bosses fight state bosses_fight begin when letter begin local vid_boss1 = pc.getqf("vid_boss1") local vid_boss2 = pc.getqf("vid_boss2") local map_index = 352 chat("Boss 1 VID: " .. tostring(vid_boss1)) chat("Boss 2 VID: " .. tostring(vid_boss2)) local success2, message2 = set_pc_can_attack_monster(vid_boss1, false, map_index) local success3, message3 = set_pc_can_attack_monster(vid_boss2, false, map_index) chat("Attempt to make boss 1 invinciple " .. tostring(success2) .. " - " .. message2) chat("Attempt to make boss 2 invinciple " .. tostring(success3) .. " - " .. message3) -- Attempt to make boss 1 attack boss 2 local success1, message1 = attack_mob(vid_boss1, vid_boss2, map_index) if success1 ~= nil and message1 ~= nil then chat("Attack attempt from Boss 1 to Boss 2: " .. tostring(success1) .. " - " .. message1) else chat("Attack attempt from Boss 1 to Boss 2: success or message is nil") end -- Attempt to make boss 2 attack boss 1 local success2, message2 = attack_mob(vid_boss2, vid_boss1, map_index) if success2 ~= nil and message2 ~= nil then chat("Attack attempt from Boss 2 to Boss 1: " .. tostring(success2) .. " - " .. message2) else chat("Attack attempt from Boss 2 to Boss 1: success or message is nil") end chat("Bosses are now set to fight each other.") chat("---------------------------------END------------------------------------") set_state("bosses_alive") end end state bosses_alive begin when letter begin chat("Checking if boss died") local vid_boss1 = pc.getqf("vid_boss1") local vid_boss2 = pc.getqf("vid_boss2") local map_index = 352 -- Check if Boss 1 is alive local is_boss1_alive, boss1_msg = is_mob_alive_in_map(vid_boss1, map_index) chat("Boss 1 alive check: " .. tostring(is_boss1_alive) .. " - " .. boss1_msg) -- Check if Boss 2 is alive local is_boss2_alive, boss2_msg = is_mob_alive_in_map(vid_boss2, map_index) chat("Boss 2 alive check: " .. tostring(is_boss2_alive) .. " - " .. boss2_msg) -- Determine the next state based on the bosses' statuses if not is_boss1_alive or not is_boss2_alive then if is_mob_alive_in_map(vid_boss1, map_index) then local success2, message2 = set_pc_can_attack_monster(vid_boss1, true, map_index) chat("Resetting invicibility for boss1 " .. tostring(success2) .. " - " .. message2) end if is_mob_alive_in_map(vid_boss2, map_index) then local success3, message3 = set_pc_can_attack_monster(vid_boss2, true, map_index) chat("Resetting invicibility for boss2 " .. tostring(success3) .. " - " .. message3) end chat("One of the bosses is dead. Resetting quest.") set_state("start") else chat("Both bosses are alive. Continuing the fight.") set_state("bosses_alive") end end end end And the last state, called bosses_alive seems to also reexecute only at player relog (login) Is there a way to make it so the states are independent of player events and just execute as soon as sv starts?
      astroNOT in Community Support - Questions & Answers
    3. 20

      Translate LUA ( 15 Languages )

      thank
      gong in Quests
    4. 111

      Ulthar SF V2 (TMP4 Base)

      Can someone help me? .. rafinement still not working for me..
      robertbode in Binaries
    5. 37

      Quest Translator

      thank
      gong in Tools & Programs
    6. 0

      Quest function when 102.kill definition whereabouts help

      Hello, So I m trying to find where this vnum.kill function is defined on serverside, seems quite tricky, if anybody knows where it is defined and what name it has, please lmk Thanks, Gabi might be this guy void CQuestManager::Kill(unsigned int pc, unsigned int npc) { //m_CurrentNPCRace = npc; PC * pPC; sys_log(0, "CQuestManager::Kill QUEST_KILL_EVENT (pc=%d, npc=%d)", pc, npc); if ((pPC = GetPC(pc))) { if (!CheckQuestLoaded(pPC)) return; // kill call script if (npc >= MAIN_RACE_MAX_NUM) //@fixme109 m_mapNPC[npc].OnKill(*pPC); //@warme004 m_mapNPC[QUEST_NO_NPC].OnKill(*pPC); #ifdef ENABLE_PARTYKILL // party_kill call script LPCHARACTER ch = GetCurrentCharacterPtr(); LPPARTY pParty = ch->GetParty(); LPCHARACTER leader = pParty ? pParty->GetLeaderCharacter() : ch; if (leader) { m_pCurrentPartyMember = ch; if (npc >= MAIN_RACE_MAX_NUM) //@fixme109 m_mapNPC[npc].OnPartyKill(*GetPC(leader->GetPlayerID())); //@warme004 m_mapNPC[QUEST_NO_NPC].OnPartyKill(*GetPC(leader->GetPlayerID())); pPC = GetPC(pc); } #endif } else sys_err("QUEST: no such pc id : %d", pc); }
      astroNOT in Community Support - Questions & Answers
    7. 5

      [M2 FILTER] Customized Client Filter

      ENB Mode, a graphic enhancer for dx that people used on SA:MP to make it look better, i didn't see a metin2 server using this since 2017 . [Hidden Content]
      envy in Features & Metin2 Systems
    8. 19

      Chat / Whisper Emoji

      Simpson1 in Features & Metin2 Systems
    9. 0

      [INGAME] RGB Color on chat broken

      Hello all, It's my own created bug. I made many changes(implenting of systems) and I didn't noticed until now, so I'm not sure what invoke the below bug. If anyone could help me. The below there is a description of bug, feel free to ask parts of code etc... This text is CHAT_TYPE_SHOUT --> Call. But when add the Chatlogs Window above, the result of color is correct. The same happends with all kinds of chat.(Guild,party etc..) I'm not sure for reason but I can see the correct color in chat, when the screen/background/frontground is darker. (E.g. I tried to take a screenshot of bug with Lightshot the screen became darker and then the color of text was correct(green in this case).
      nora in Community Support - Questions & Answers

  • Recently Browsing

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.