Page 1 of 1

Any ideas??

Posted: Tue Feb 09, 2010 5:16 pm
by Takenore
So, server development was based on L2J gracia final, now having such problem

Image

so when MySQL threads go more than 1 000 server "freezes", server machine is very powerful, so error is somewhere in Core part.

My Question is : Do you have any ideas, what may cause it? thx in advance

Re: Any ideas??

Posted: Tue Feb 09, 2010 5:18 pm
by Probe
what kind of custom additions do you have? do you close every DB connection you open?

Re: Any ideas??

Posted: Tue Feb 09, 2010 5:21 pm
by Takenore
yes, no customs in connect-to-base part

Re: Any ideas??

Posted: Tue Feb 09, 2010 5:28 pm
by janiii
some php web scripts that connect to l2j database?

Re: Any ideas??

Posted: Tue Feb 09, 2010 5:30 pm
by Takenore
janiii wrote:some php web scripts that connect to l2j database?
no, more to it "freezes" are in the nearly same time once at night, once at day

Re: Any ideas??

Posted: Tue Feb 09, 2010 5:50 pm
by BiggBoss
Do you have to restart the server or it become stable once the thread peek has pass?

Re: Any ideas??

Posted: Tue Feb 09, 2010 5:53 pm
by Takenore
BiggBoss wrote:Do you have to restart the server or it become stable once the thread peek has pass?
restarting

Re: Any ideas??

Posted: Tue Feb 09, 2010 6:14 pm
by BiggBoss
and you have a clean core/dp ?

Re: Any ideas??

Posted: Tue Feb 09, 2010 6:25 pm
by Takenore
server development was based on L2J
DP/Core not clean, so theme is in off-top :) ideas,ideas, i need ur ideas

Re: Any ideas??

Posted: Tue Feb 09, 2010 6:40 pm
by BiggBoss
i bet for non-closed db connections. How many times do you restart server at day? Same as peeks plotted in graph?

Re: Any ideas??

Posted: Tue Feb 09, 2010 6:42 pm
by ThePhoenixBird
Takenore wrote:
server development was based on L2J
DP/Core not clean, so theme is in off-top :) ideas,ideas, i need ur ideas
If DP/Core is not clean, that means that you have modified something from the original core, posting your modifications may help to find where is the mistake that you did and is causing this severe SQL stress