MTA paradise server performance

[Solstice.]

Hello,

Working on a small RP gamemode for me and some friends using MTA paradise. Thing is server performance is just horrid. There's a lot of lag. The host is perfectly fine though. I first thought it was an issue with the MySQL server but it's on the same server, so this can't be it.

I get CPU spikes on the sql and players resource, and sometimes the vehicles resource. I have bandwidth reduction disabled and bullet sync is enabled in the configuration files.

IPB Warning: sql is using 206% CPU

IPB Warning: vehicles is using 156% CPU

IPB Warning: players is using 84% CPU

There's two events, CallIdle1 and CallIdle2, that seem to trigger every minute and cause a lagspike, but I'm not sure where to find these events. I don't think they're part of the paradise gamemode but it's all I'm running. I've checked all paradise documents for an event with this name but it doesn't exist.

15:52:41.433 - Started timing checkpoints [Ver:1.3.5-9.06162] [Date:2014-03-01] 
15:52:53.788 - >Detected slow frame: 854ms    (Prev frame was 5ms)  (Game time 00:00) 
15:52:53.789 -     Frame slow points: [CorePostFrame2 847ms (calls:1)]   [OnPresent2 6ms (calls:1)]   
15:52:56.306 - >Detected slow frame: 1800ms    (Prev frame was 2ms)  (Game time 12:00) 
15:52:56.311 -     Frame slow points: [CallIdle1 118ms (calls:1)]   [CGame_Process 112ms (calls:1)]   [CClientGame::DoPulses 62ms (calls:1)]   [NetPulse 62ms (calls:1)]   
15:53:02.076 - >Detected slow frame: 128ms    (Prev frame was 1ms)  (Game time 09:51) 
15:53:02.076 -     Frame slow points: [CallIdle2 127ms (calls:1)]   [CClientGame::DoPulses 127ms (calls:1)]   [NetPulse 126ms (calls:1)]   
15:53:02.157 - >Detected slow frame: 54ms    (Prev frame was 1ms)  (Game time 09:51) 
15:53:02.157 -     Frame slow points: [CallIdle2 53ms (calls:1)]   [CClientGame::DoPulses 53ms (calls:1)]   [NetPulse 52ms (calls:1)]   [pcall 11ms (calls:60)] 

How do I fix this lag?

[myonlake]

I am not receiving that amount of lag on my end. Could it be your custom code that causes this?

[Solstice.]

I am not receiving that amount of lag on my end. Could it be your custom code that causes this?

I barely modified the players resource and sql is left untouched. Idk if you're running it with multiple people on the server. The lag is only noticable when you have around ten people on it, and more causes more and heavier lagspikes. I'll try running a clean paradise mod and see what happens.