Any ideas??

[Takenore]

So, server development was based on L2J gracia final, now having such problem



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

[Probe]

what kind of custom additions do you have? do you close every DB connection you open?

[Takenore]

yes, no customs in connect-to-base part

[janiii]

some php web scripts that connect to l2j database?

[Takenore]

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

[BiggBoss]

Do you have to restart the server or it become stable once the thread peek has pass?

[Takenore]

Do you have to restart the server or it become stable once the thread peek has pass?

restarting

[BiggBoss]

and you have a clean core/dp ?

[Takenore]

server development was based on L2J

DP/Core not clean, so theme is in off-top ideas,ideas, i need ur ideas

[BiggBoss]

i bet for non-closed db connections. How many times do you restart server at day? Same as peeks plotted in graph?

[ThePhoenixBird]

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