[SOLVED]Minor server hangs [help]

Help and Support Help and Support
1

Server configuration.
Ubunt-16,04-x86_64
CPU frequency
2400 MHz
RAM
3072 MiB
Number of processors
3
HDD
92160 MiB (8445 MiB is used)
Traffic is unlimited. 100mb channel

Created the server. Online ran 7 bodies (including me) at all stable ping 50-70
There is almost no load on the servo. Busy almost always 500MB of RAM from 3g.
I start the server through the screen.
What changed. Made server currency through the already available. I deleted the square that gave this currency.
Sometimes when you learn skills, there is a pause in 1 second or even 5.
The whole server complains that there are jams.
Assembling off Trinity. As I understood the last revision. I compiled everything myself! I also tuned everything myself.
In TrinityAdmin sometimes shows an update of Diff under 2k is this the norm?

Tell me where to pick?
Strange server logs

Spell Id 6940 has DBC ProcFlags 699048, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 7366 has DBC ProcFlags 69972, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 18499 has DBC ProcFlags 139944, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 28313 has DBC ProcFlags 1581224, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 32065 has DBC ProcFlags 262144, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 33891 has DBC ProcFlags 174624, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 35244 has DBC ProcFlags 262144, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 36659 has DBC ProcFlags 262144, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 40453 has DBC ProcFlags 1581224, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 40879 has DBC ProcFlags 664096, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 41341 has DBC ProcFlags 1747624, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 44586 has DBC ProcFlags 697000, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 45092 has DBC ProcFlags 664232, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 49145 has DBC ProcFlags 131072, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 50462 has DBC ProcFlags 131752, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 50498 has DBC ProcFlags 16, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 51809 has DBC ProcFlags 131752, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 53032 has DBC ProcFlags 81936, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 53578 has DBC ProcFlags 16, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 53579 has DBC ProcFlags 16, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 53580 has DBC ProcFlags 16, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 53581 has DBC ProcFlags 16, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 53582 has DBC ProcFlags 16, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 62142 has DBC ProcFlags 69648, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 64205 has DBC ProcFlags 699048, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 66334 has DBC ProcFlags 245760, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 67905 has DBC ProcFlags 245760, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 67906 has DBC ProcFlags 245760, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 67907 has DBC ProcFlags 245760, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 72151 has DBC ProcFlags 69972, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 72648 has DBC ProcFlags 69972, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 72649 has DBC ProcFlags 69972, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 72650 has DBC ProcFlags 69972, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Item (Entry: 5828) has wrong (non-existing?) stat_type1 (51)
Item (Entry: 5828) has wrong (non-existing?) stat_type2 (52)
Item (Entry: 5828) has wrong (non-existing?) stat_type3 (54)
Item (Entry: 5828) has wrong (non-existing?) stat_type4 (56)
Item (Entry: 5828) has wrong (non-existing?) stat_type5 (55)
Item (Entry: 17802) has wrong (non-existing?) stat_type3 (51)
Item (Entry: 17802) has wrong (non-existing?) stat_type4 (55)
Item (Entry: 18881) has wrong (non-existing?) stat_type3 (51)
Item (Entry: 19065) has wrong (non-existing?) stat_type3 (50)
Item (Entry: 19158) has wrong (non-existing?) stat_type3 (51)
Item (Entry: 20142) has wrong (non-existing?) stat_type3 (50)
Item (Entry: 20142) has wrong (non-existing?) stat_type4 (51)
Item (Entry: 20142) has wrong (non-existing?) stat_type5 (52)
Item (Entry: 20142) has wrong (non-existing?) stat_type6 (54)
Item (Entry: 20142) has wrong (non-existing?) stat_type7 (56)
Item (Entry: 20142) has wrong (non-existing?) stat_type8 (55)
Item (Entry: 20522) has wrong (non-existing?) stat_type3 (50)
Item (Entry: 20524) has wrong (non-existing?) stat_type3 (50)
Item (Entry: 20524) has wrong (non-existing?) stat_type4 (54)
Item (Entry: 21614) has wrong (non-existing?) stat_type3 (55)
Item (Entry: 22230) has wrong (non-existing?) stat_type2 (50)
Item (Entry: 23362) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 23362) has wrong (non-existing?) stat_type6 (51)
Item (Entry: 23362) has wrong (non-existing?) stat_type7 (54)
Item (Entry: 23363) has wrong (non-existing?) stat_type5 (55)
Item (Entry: 23363) has wrong (non-existing?) stat_type6 (56)
Item (Entry: 32113) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32114) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32115) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32116) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32117) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32118) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32119) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32121) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32122) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32123) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32128) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32129) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32130) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32131) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32132) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 34187) has wrong (non-existing?) stat_type1 (50)
Item (Entry: 34967) has deprecated stat_type4 (41)
Item (Entry: 34967) has deprecated stat_type5 (42)
Item (Entry: 36942) does not have a correct SoundOverrideSubclass (-1), must be 8 .
Item (Entry: 36942) does not have a correct material (1), must be -1 .
Item (Entry: 36942) does not have a correct display id (65153), must be 46609 .
Item (Entry: 40762) has wrong (non-existing?) stat_type5 (51)
Item (Entry: 45860) has wrong (non-existing?) stat_type1 (50)
Item (Entry: 48945) has wrong (non-existing?) stat_type2 (50)
Item (Entry: 49312) has wrong (non-existing?) stat_type3 (51)
Item (Entry: 49314) has wrong (non-existing?) stat_type5 (51)
Creature template (Entry: 50100) does not exist but has a record in creature_equip_template
Table creature has creature (GUID: 213876) with non existing creature entry 50100, skipped.
Table creature has creature (GUID: 213896 Entry: 36597) with creature_template.flags_extra including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature is not in instance.
Table creature_queststarter: Quest 12170 listed for entry 27120 does not exist.
Table creature_queststarter: Quest 12443 listed for entry 27495 does not exist.
Table creature_queststarter: Quest 12314 listed for entry 27520 does not exist.
Table creature_queststarter: Quest 12315 listed for entry 27532 does not exist.
Table creature_queststarter: Quest 12317 listed for entry 27563 does not exist.
Table creature_queststarter: Quest 12323 listed for entry 27602 does not exist.
Table creature_queststarter: Quest 12432 listed for entry 27708 does not exist.
Table creature_queststarter: Quest 12444 listed for entry 27783 does not exist.
Table creature_questender: Quest 12170 listed for entry 27120 does not exist.
Table creature_questender: Quest 12443 listed for entry 27495 does not exist.
Table creature_questender: Quest 12314 listed for entry 27520 does not exist.
Table creature_questender: Quest 12315 listed for entry 27532 does not exist.
Table creature_questender: Quest 12317 listed for entry 27563 does not exist.
Table creature_questender: Quest 12323 listed for entry 27602 does not exist.
Table creature_questender: Quest 12432 listed for entry 27708 does not exist.
Table creature_questender: Quest 12444 listed for entry 27783 does not exist.
Table ‘creature_loot_template’ Entry 50100 isn’t creature entry and not referenced from loot, and thus useless.
Table ‘item_loot_template’ Entry 50100 isn’t item entry and not referenced from loot, and thus useless.
[Condition SourceType: 4 (GameObject Loot), SourceGroup: 24095, SourceEntry: 37664, ConditionType: 9 (Quest Taken)] points to non-existing quest (12434), skipped.
[Condition SourceType: 4 (GameObject Loot), SourceGroup: 24095, SourceEntry: 37664, ConditionType: 9 (Quest Taken)] points to non-existing quest (12443), skipped.
[Condition SourceType: 4 (GameObject Loot), SourceGroup: 24095, SourceEntry: 37664, ConditionType: 9 (Quest Taken)] points to non-existing quest (12432), skipped.
Quest 12323 (alliance_id) referenced in player_factionchange_quests does not exist, pair skipped!
SQL(p): INSERT INTO character_queststatus_seasonal (guid, quest, event) VALUES (70, 11915, 1)
[ERROR]: [1062] Duplicate entry ‘70-11915’ for key ‘PRIMARY’
SQL(p): INSERT INTO character_queststatus_seasonal (guid, quest, event) VALUES (70, 11915, 1)
[ERROR]: [1062] Duplicate entry ‘70-11915’ for key ‘PRIMARY’
Spell Id 6940 has DBC ProcFlags 699048, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 7366 has DBC ProcFlags 69972, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 18499 has DBC ProcFlags 139944, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 28313 has DBC ProcFlags 1581224, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 32065 has DBC ProcFlags 262144, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 33891 has DBC ProcFlags 174624, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 35244 has DBC ProcFlags 262144, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 36659 has DBC ProcFlags 262144, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 40453 has DBC ProcFlags 1581224, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 40879 has DBC ProcFlags 664096, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 41341 has DBC ProcFlags 1747624, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 44586 has DBC ProcFlags 697000, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 45092 has DBC ProcFlags 664232, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 49145 has DBC ProcFlags 131072, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 50462 has DBC ProcFlags 131752, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 50498 has DBC ProcFlags 16, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 51809 has DBC ProcFlags 131752, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 53032 has DBC ProcFlags 81936, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 53578 has DBC ProcFlags 16, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 53579 has DBC ProcFlags 16, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 53580 has DBC ProcFlags 16, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 53581 has DBC ProcFlags 16, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 53582 has DBC ProcFlags 16, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 62142 has DBC ProcFlags 69648, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 64205 has DBC ProcFlags 699048, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 66334 has DBC ProcFlags 245760, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 67905 has DBC ProcFlags 245760, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 67906 has DBC ProcFlags 245760, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 67907 has DBC ProcFlags 245760, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 72151 has DBC ProcFlags 69972, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 72648 has DBC ProcFlags 69972, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 72649 has DBC ProcFlags 69972, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Spell Id 72650 has DBC ProcFlags 69972, but it’s of non-proc aura type, it probably needs an entry in spell_proc table to be handled correctly.
Item (Entry: 5828) has wrong (non-existing?) stat_type1 (51)
Item (Entry: 5828) has wrong (non-existing?) stat_type2 (52)
Item (Entry: 5828) has wrong (non-existing?) stat_type3 (54)
Item (Entry: 5828) has wrong (non-existing?) stat_type4 (56)
Item (Entry: 5828) has wrong (non-existing?) stat_type5 (55)
Item (Entry: 17802) has wrong (non-existing?) stat_type3 (51)
Item (Entry: 17802) has wrong (non-existing?) stat_type4 (55)
Item (Entry: 18881) has wrong (non-existing?) stat_type3 (51)
Item (Entry: 19065) has wrong (non-existing?) stat_type3 (50)
Item (Entry: 19158) has wrong (non-existing?) stat_type3 (51)
Item (Entry: 20142) has wrong (non-existing?) stat_type3 (50)
Item (Entry: 20142) has wrong (non-existing?) stat_type4 (51)
Item (Entry: 20142) has wrong (non-existing?) stat_type5 (52)
Item (Entry: 20142) has wrong (non-existing?) stat_type6 (54)
Item (Entry: 20142) has wrong (non-existing?) stat_type7 (56)
Item (Entry: 20142) has wrong (non-existing?) stat_type8 (55)
Item (Entry: 20522) has wrong (non-existing?) stat_type3 (50)
Item (Entry: 20524) has wrong (non-existing?) stat_type3 (50)
Item (Entry: 20524) has wrong (non-existing?) stat_type4 (54)
Item (Entry: 21614) has wrong (non-existing?) stat_type3 (55)
Item (Entry: 22230) has wrong (non-existing?) stat_type2 (50)
Item (Entry: 23362) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 23362) has wrong (non-existing?) stat_type6 (51)
Item (Entry: 23362) has wrong (non-existing?) stat_type7 (54)
Item (Entry: 23363) has wrong (non-existing?) stat_type5 (55)
Item (Entry: 23363) has wrong (non-existing?) stat_type6 (56)
Item (Entry: 32113) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32114) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32115) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32116) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32117) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32118) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32119) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32121) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32122) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32123) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32128) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32129) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32130) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32131) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 32132) has wrong (non-existing?) stat_type5 (50)
Item (Entry: 34187) has wrong (non-existing?) stat_type1 (50)
Item (Entry: 34967) has deprecated stat_type4 (41)
Item (Entry: 34967) has deprecated stat_type5 (42)
Item (Entry: 36942) does not have a correct SoundOverrideSubclass (-1), must be 8 .
Item (Entry: 36942) does not have a correct material (1), must be -1 .
Item (Entry: 36942) does not have a correct display id (65153), must be 46609 .
Item (Entry: 40762) has wrong (non-existing?) stat_type5 (51)
Item (Entry: 45860) has wrong (non-existing?) stat_type1 (50)
Item (Entry: 48945) has wrong (non-existing?) stat_type2 (50)
Item (Entry: 49312) has wrong (non-existing?) stat_type3 (51)
Item (Entry: 49314) has wrong (non-existing?) stat_type5 (51)
Creature template (Entry: 50100) does not exist but has a record in creature_equip_template
Table creature has creature (GUID: 213876) with non existing creature entry 50100, skipped.
Table creature_queststarter: Quest 12170 listed for entry 27120 does not exist.
Table creature_queststarter: Quest 12443 listed for entry 27495 does not exist.
Table creature_queststarter: Quest 12314 listed for entry 27520 does not exist.
Table creature_queststarter: Quest 12315 listed for entry 27532 does not exist.
Table creature_queststarter: Quest 12317 listed for entry 27563 does not exist.
Table creature_queststarter: Quest 12323 listed for entry 27602 does not exist.
Table creature_queststarter: Quest 12432 listed for entry 27708 does not exist.
Table creature_queststarter: Quest 12444 listed for entry 27783 does not exist.
Table creature_questender: Quest 12170 listed for entry 27120 does not exist.
Table creature_questender: Quest 12443 listed for entry 27495 does not exist.
Table creature_questender: Quest 12314 listed for entry 27520 does not exist.
Table creature_questender: Quest 12315 listed for entry 27532 does not exist.
Table creature_questender: Quest 12317 listed for entry 27563 does not exist.
Table creature_questender: Quest 12323 listed for entry 27602 does not exist.
Table creature_questender: Quest 12432 listed for entry 27708 does not exist.
Table creature_questender: Quest 12444 listed for entry 27783 does not exist.
Table ‘item_loot_template’ Entry 50100 isn’t item entry and not referenced from loot, and thus useless.
[Condition SourceType: 4 (GameObject Loot), SourceGroup: 24095, SourceEntry: 37664, ConditionType: 9 (Quest Taken)] points to non-existing quest (12434), skipped.
[Condition SourceType: 4 (GameObject Loot), SourceGroup: 24095, SourceEntry: 37664, ConditionType: 9 (Quest Taken)] points to non-existing quest (12443), skipped.
[Condition SourceType: 4 (GameObject Loot), SourceGroup: 24095, SourceEntry: 37664, ConditionType: 9 (Quest Taken)] points to non-existing quest (12432), skipped.
Quest 12323 (alliance_id) referenced in player_factionchange_quests does not exist, pair skipped!
SQL(p): INSERT INTO character_queststatus_seasonal (guid, quest, event) VALUES (31, 11882, 1)
[ERROR]: [1062] Duplicate entry ‘31-11882’ for key ‘PRIMARY’

[ATTACH]2181._xfImport[/ATTACH]

2

That may be your DB that needs more memory allocated. Assuming that your DB is running on the same node.
Try learning all spells for one craft. Log out, clear cache, log back in and open your craft. For example if you open up Blacksmith there should almost no hesitation, if there is, then you need to beef up your DB.

There should be no hesitation when reading the DB. Also, there seems to be some missing entries from your DB as well.

3

I deleted the old world database, installed the updated database of TBD_Full_World …
Put high priority and 4 cores in the worldserver.conf, I checked
Server speed is this command: curl -s https://raw.githubusercontent.com/sivel/speedtest-cli/master/speedtest.py | python

Here’s what I got:

Image |

The suspensions remained … I do not understand what the problem is, help me)

[ATTACH]2182._xfImport[/ATTACH]

4

And even if it hangs, it hangs around the entire server and all the players. For 5-10 seconds, you can not use anything (abilities, sit on the mount, change weapons or armor, all run on the spot and the chat also hangs in this moment)

[ATTACH]2183._xfImport[/ATTACH]

5

Your network seems fine. Especially with an upload of over 20mbits

What are the errors that the server complains about?

Unfortunately, I don’t use TrinityAdmin.

6

I did not understand the essence of the question.

Players complain about server hangs - this means that every 1-2 minutes the server hangs. Players stand still or run on the spot, you can not use any spells, you can not mount, put on or remove a thing, the chat is not updated, the chat message is not sent,
None of the players can not beat the mobs, since the mobs are standing still or running on the spot, and the autoattack is not used, in general the servo hangs dully for 5-10 seconds, it happens for 20 seconds. And I do not understand what’s the matter, there is no wild online on the server, a maximum of 9 people play. On the server is unlimited traffic 100mb / sec, 4 gigabytes of RAM, 4 cores. My English is very bad, so I use Google translater.

Used resources when online 9 people:

RAM - 500 / 4000mb
Traffic - 0.258 Gib
Processor% 6%
Input / output operations - 2 IOPS
Memory Usage - 50%
Average system load 0.31
Open Processes - 101
Open files - 1201

I hope you penny me, I’m new, this is my first server.

The server is located on the VDS - firstvds.ru
Please, help.

7

run nload while all 9 players are playing and tell me if Incoming or Outgoing is spiking.

This is a test on my server with 8 people playing who volunteered

Your outgoing should be less
[FONT=‘Courier New’]Avg: 27.46 kBit/s[/FONT]

Your Incoming should be less
[FONT=‘Courier New’]Avg: 12.59 kBit/s[/FONT]

Does this happen when only you play by yourself?

If you are getting spikes only with other players, then there is other activity going on. Possible that one of the players is DDOS’ing your network?

8

Hmm, I do not know exactly, but maybe I solved the problem, I created somewhere 10 users for Mysql and did not use them, I deleted them and there were almost no freezes.

9

It still sounded like an issue with your DB in the beginning… Creating users on the DB won’t solve it, unless it needed a restart.

10

And how can you strengthen the database?

11

If you are using mysql, dedicate more memory to increase your speed. Use more RAM to increase data storage going back and forth from memory and not use your physical hard drive to write, then upload.

Make a backup of my.cnf file and do minor increases to:
key_buffer_size
sort_buffer
read_buffer
table_cache
innodb_buffer_pool_size

Then restart MySQL. Be sure to keep an eye on your memory usage. You don’t want MySQL to much RAM.

Also, see about increasing RAM in your computer. If I’m reading that correctly, you only have 3Gbs of RAM which is extremely low if you have more than 10 players in the future.

12

close

13

— Canned message start —
It appears the issue in the original post was solved, so this thread shall be closed.
Should you encounter any other difficulties, please open a new thread.
— Canned message end —