Alright, This is How I fixed my CPU issue and made errors come less often:
If you look in Worldserver.conf
You have
I hope this helps people, This helped me My server was on 10 hours without erroring out.
Now if you look after restarting your server, You'll see a 10% drop on CPU usage as well.
If you look in Worldserver.conf
You have
Code:
[DATABASE]
mysql_host=localhost
mysql_user=xxx
mysql_pass=xxx
mysql_database=rose
mysql_port=3306
AutoQueryTime=1500 <--- Heres the part that matter's set that higher and thats a timer for things to be saved to mysql, So you want to save at a decent time but not too long so the server saves regularily, This is 9 minutes.
Then you have:
savetime=590
mapdelay=35
visualdelay=90
worlddelay=90
The save time is around 7 minutes or so, So you aren't saving characters and everything at the same time
causing a lot of load on mysql
I hope this helps people, This helped me My server was on 10 hours without erroring out.
Now if you look after restarting your server, You'll see a 10% drop on CPU usage as well.