Delay just before creating new characters

[Schultz]

Hello,

 

I have an issue on my server that's driving me mad :(

 

Basically, we are experiencing some random 15/20 seconds server FPS drops, at random times.

 

I noticed with AWOL that in HiveExt.log there's a delay before the creation of a new character so I think that's the problem!

2014-02-26 23:30:04 HiveExt: [Information] Method: 101 Params: 104319686:24:Schwarzfluss:
2014-02-26 23:30:04 HiveExt: [Information] Created a new player 104319686 named 'Schwarzfluss'
2014-02-26 23:30:29 HiveExt: [Information] Created a new character 4959 for player 'Schwarzfluss' (104319686)
2014-02-26 23:30:29 HiveExt: [Information] Result: ["PASS",true,"4959",0,"",0.96]

In this case, the delay lasted 25 seconds. Do you have any ideas on what could generate this?

 

RPT at the same timestamp shows this:

23:28:45 Warning: Cleanup player - person 25:5 not found
23:30:03 Unit 32:3 not found, cannot update
23:30:29 Server: Object 21:123 not found (message 91)
23:30:29 Server: Object 21:122 not found (message 99)
23:30:30 Server: Object 32:9 not found (message 70)
23:30:30 Server: Object 32:8 not found (message 89)
23:30:30 Server: Object info 24:159 not found during Changing Owner
23:30:30 Server: Object info 24:158 not found during Changing Owner
23:30:31 "infiSTAR.de Player-Log: Schwarzfluss(104319686) - 0h 24min"
23:30:31 "infiSTAR.de Player-Log: SoulFly(90308998) - 0h 24min"

[Schultz]

Another hint: in my MySQL slow.log, everytime there's that delay I see this kind of query taking up to 30 seconds and being logged of course:

SET timestamp=1393453802;
INSERT INTO `Character_DATA` (`PlayerUID`, `InstanceID`, `Worldspace`, `Inventory`, `Backpack`, `Medical`, `Generation`, `Datestamp`, `LastLogin`, `LastAte`, `LastDrank`, `Humanity`) VALUES ('90308998', 24, '[]', '[]', '[]', '[]', [truncated, 342 bytes total]

Start Time, User@Host, Query Time, Lock Time, Rows Sent, Rows Examined, Detail
140226 23:30:02, dayz[dayz] @ localhost [127.0.0.1]  Id:     3, 25.220442, 0.000000, 0, 72562476, SET timestamp=1393453802;
INSERT INTO `Character_DATA` (`PlayerUID`, `InstanceID`, `Worldspace`, `Inventory`, `Backpack`, `Medical`, `Generation`, `Datestamp`, `LastLogin`, `LastAte`, `LastDrank`, `Humanity`) VALUES ('90308998', 24, '[]', '[]', '[]', '[]', [truncated, 342 bytes total]