About Memory

This is not a Support area! Discuss about the Server here. Non-Server related discussion goes in Off-Topic Discussion.
Forum rules
READ NOW: L2j Forums Rules of Conduct
User avatar
Szponiasty
Advanced User
Advanced User
Posts: 557
Joined: Mon Apr 21, 2008 1:31 pm
Location: Eastern Poland

Re: About Memory

Post by Szponiasty »

LaraCroft wrote:Is to prevent this:
viewtopic.php?f=81&t=17010&start=15&hilit=mysql+close
Mhm. Found that usefull tons of times myself (instead of crashing everything, even without stack trace or slightest smallest error text in logs, it tends to throw 200kb of error logs per minute, in your face :)), but really. Take a closer look if your max statements isnt too low. It doesnt have to be, 150 is what i've used no prob (until server became, hmm... fat), now like I say - often 1k+ statements. If I had limited that to 150 then... Hate to hear that at some point you had to shutdown and work on inconsistent database, with missing pets, augments, rolled back levels xD Besides I don't think setting it even much higher would make this "prevention method" any less usefull. What matter most - is the max time you let idlying connection to live, until its closed. That's the problem maker in most cases (running out of available connections) :)
And in the next chronicle they went into space, fighting the evil empire... In a galaxy far, far away xD
User avatar
LaraCroft
Posts: 360
Joined: Sat Aug 08, 2009 1:37 am

Re: About Memory

Post by LaraCroft »

Thx a lot for this explanation...
It is very useful...
:mrgreen:
I will test the weekend with low value...
Next week I will use a high value...
If something goes wrong I'll post here...
:wink:
!!!knowledge and intelligence must be shared!!!
User avatar
Raikkon35
Posts: 178
Joined: Sat Mar 08, 2008 2:54 pm

Re: About Memory

Post by Raikkon35 »

Hey!

It would be better, not using -Dc3p0 options from the beginning?
Post Reply