Cpu Usage Problem

[magnon]

I have Problem My Cpu Usage take alot i have 6 Cpu and take 91%

Mysqld it's only take all usage

[Korvacs]

I take it this is while your running a server?

[magnon]

Yea when i close Server Cpu back to 0 usage it's big Vps 16 gigaRam and 6 Cpu

[Korvacs]

Yeah, the problem is that your server is written badly, no real surprise there.

[magnon]

Originally Posted by Korvacs

Yeah, the problem is that your server is written badly, no real surprise there.

So....

32 Viewer and no Resolved

[Korvacs]

Originally Posted by magnon

So....

32 Viewer and no Resolved

Nope, the only way to resolve this is to rewrite your server, and since you have copy pasted most of your server from other servers its no wonder its broken to ****. lol

[Super Aids]

Do you run any infinite loops that doesn't sleep for at least 1 miillisecond?

[magnon]

I Resolved it it's was from programe.cs have alot of Save i just Delete it

[Korvacs]

Originally Posted by magnon

I Resolved it it's was from programe.cs have alot of Save i just Delete it

Unbelievable

[_Emme_]

Good job! I usually do like that too, delete the saving parts. Mehh, who cares what they do - just select it all and delete! As long as it works, right?

Do you do consultant job?

[go for it]

well i really would want to be sarcastic but i suck at it anyway
why would you save everything with loop from "programe.cs" instead of saving them from the event itself ?
what i mean is
lets assume that you are smart and only saving for online players
and lets assume that you give a good sleep for your saving maybe 5 ms or something
that will end you up saving maybe 200 variable for 50 players which is an avg of updating the database with 10,000 variable each 5 ms which is 120k variable per min
instead of saving variables at there own events
ex.
when someone jump you save check for the coords to be valid or not then save them as current , save the old as previous , calculate whatever you want for eliminating speedhacks (what's what i was personally doin in nextco if i recall correctly)

[marcbacor6666]

how about memoryusage high , any tip where would i look

[U2_Caparzo]

Originally Posted by marcbacor6666

how about memoryusage high , any tip where would i look

Maps? :| That is the reason that servers will have a high memory usage, what u have to worry is how scalable is what u are coding, not the "base memory usage"

[LordGragen.]

if you ask me the only good way to save is,

when the player logoff and when the server shutdown. thats all.

[go for it]

Originally Posted by LordGragen.

if you ask me the only good way to save is,

when the player logoff and when the server shutdown. thats all.

so when player buy something you don't update his cps/gold until he relogin ?
when player trade/sellthrowbooth you don't remove the items from his inventory or update cps until he relogin ?
and count on that so many stuff :\

i still insist that the best way for updating the db is on the event itself , not with a timer and not on player logging off or even server shutting down
maybe you do not suffer from that at trinity as it's all well coded on changing cps it update the clients but if it wasn't done you was to understand why it should be there