[Guide] Guide for lowering CPU Usage and Errors

Status
Not open for further replies.
Experienced Elementalist
Joined
Sep 11, 2006
Messages
291
Reaction score
10
Location
Canada
Alright, This is How I fixed my CPU issue and made errors come less often:

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.
 
how many player connect
what happen after 10 hours
wamp, xampp ?

This isn't a help thread bub, Lol.
And 80 connected.
I get errors like these, Its any user, Not just a certain one.

Could not execute query: Commands out of sync; you can't run this command now
Query: INSERT INTO list_quest (owner,questid,nitems,active) VALUES (1625,2006,'0|0|0|0|0',0)

And I have all sql files ;p
And the day I use Windows as a Webserver is the day I shove socks down my throat.
Well seriously for users/players. Personally maybe.

Its a Apache web server I'm using, I have a web host.
MySQL is up to date and is on localhost, I manage it using Navicat.
 
Status
Not open for further replies.
Back