Freeze / Lag

[scRO]

Good afternoon everyone.
I encountered the following problem:
Players and monsters periodically freeze, but at the moment of freezing, the monsters freeze in the same way as the players.
CPU, network, RAM, SQL, do not show more than 5%, where should I look for the problem?

VSP: 
4 CPU 3.3 
16 GB RAM
200mb/sec
 

[LearningRO]

maybe you have Slow Queery on SQL

or maybe you have bad script with timer

[Rivers]

Make sure your firewall settings are allowing all the ports through or you will experience blocks ind ata, such as that. This is usually an issue with the data not sending/recieving properly from server to client and back.
I resolved this issue by allowing all ports to be open through the firewall and granting rwx permissions to all files in the rAthena folder.

[scRO]

Thanks, I think the option with SQL is more likely

[pandabro]

Are you using InnoDB in the SQL?

[scRO]

On 1/15/2024 at 5:30 AM, pandabro said:

Are you using InnoDB in the SQL?

Good afternoon.
I have already dealt with this problem.
I came to the conclusion that the provider provided me with weaker processors than originally stated.

Previously, scripts loaded in about 40 seconds, now the server does the same in 2-3 seconds.