MySql Usage 85% sometimes higher, rep++

[Dalale]

Hello Otlanders

I got a problem with my otserver.
Mysql is getting up to 85-95% Cpu usage.
And this make the server lagging.

When its not so many players online the Mysql usage is around 20%

here is a screenshoot



what could i do to fix this?

xampp version. 1.6.6a

rep++

 

[wlj]

You using your own computer and you call that dedicated? lol...

giv ure ip wanna make a thing, Dont insult my friends thx

its dedi and if u have 9 9 post why play cool
as you even have money for dedi 1 week might 1 day :huh:

-.-

Are you freaking dumb?
I am using dedicated server, Company : serverloft in germany, what are you talking about

well i like ger funny lang

 

[Quaro]

Try to install another OS?
windows 7 is pretty nice

 

[wlj]

hey, I got that one, in db, and its empty

¨

msg me on msn and i send a code with it

Try to install another OS?
windows 7 is pretty nice

well i have it on my other comp my dad says xp is better or vista

((
its a dedi not a normal comp remember that hehe

 

[Dalale]

bump

 

[chojrak]

Don't host server on Windows XP/Vista? Use Win. Server or Linux?

 

[Dalale]

Don't host server on Windows XP/Vista? Use Win. Server or Linux?

It's working fine for others, there somth wrong..

 

[wlj]

bump for bump hahha

 

[chojrak]

It's working fine for others, there somth wrong..

I know but win. is not good for hosting.

 

[wlj]

I know but win. is not good for hosting.

not the prob... its that mysql takes 85% -.-

and windows server and xp,7 only vista is the bad one that i know...

 

[wlj]

Bump i will spamm mi=spammerò

 

[wlj]

.....

 

[Dalale]

bump

 

[wlj]

Bimp

 

[jamil]

WLJ@
You said that you were Dalale's scripter, no?

Thus, are you using the same scripts as he does?
In that case, its obvious that there is something with the lua that messes up with the MySQL connection.

Check your .lua scripts and try to remember if you have edited something since the lagging began to take place.

 

[Quaro]

Do you have good processor?

 

[Dalale]

Do you have good processor?

Please check my post before, there it says my ram,and cpu

 

[wlj]

WLJ@
You said that you were Dalale's scripter, no?

Thus, are you using the same scripts as he does?
In that case, its obvious that there is something with the lua that messes up with the MySQL connection.

Check your .lua scripts and try to remember if you have edited something since the lagging began to take place.

im hes scripter and no we havent input the 0.3.5 yet if u are a player of roxxor or kernkraft. And im not the best in exe im best in microsoft

 

[misery]

Hit ctrl+alt+delete, goto processes, then right click the mysql thing>set priority>then choose 'realtime' or 'high'. I wonder if that would help?

 

[Dalale]

Hit ctrl+alt+delete, goto processes, then right click the mysql thing>set priority>then choose 'realtime' or 'high'. I wonder if that would help?

Thank you, already done this.

 

[wlj]

Bump