Arch Linux

Thor@Flanders

Member

Registered: 2010-08-27

Posts: 266

(solved)MySQL running out of connections...

Hi,

Not really a _problem_ as such, but I may have to look into this in the (near?) future, if my project goes live...

I have an Applet that shows data from a server (on my network) - if I turn off the applet (stop Firefox all the way) and re-connect and do that several times, the server has "too many connections" and (obviously) will refuse to serve any further.

Is there a way to effectively kill a connection?

There is (scetchy) what I do at "unload"

try
{
  cn.close();
  cn = null;
}
catch(exception e)
  {}
// no need to handle this?

Fair enuff, the Applet does release the connection, but something still "lingers" on in the server...how do I clean that up as well?

Any thoughts are welcome...no pressure here...

Coolness to all

Thor

Edit - not really solved, but more "timed out"...

Last edited by Thor@Flanders (2010-12-10 12:43:21)

skunktrader

Member

From: Brisbane, Australia

Registered: 2010-02-14

Posts: 1,580

Re: (solved)MySQL running out of connections...

What about checking to see if any exception is thrown?  Especially if you might have any active transactions.

Last edited by skunktrader (2010-12-01 17:40:01)

Thor@Flanders

Member

Registered: 2010-08-27

Posts: 266

Re: (solved)MySQL running out of connections...

Hi Skunktrader,

Nope, the exception still happens. I'll set up the server to do a garbage collect. And redirect the closing page/applet to a close page where I'd run a PHP script to close mysql down...by means of cleaning up...

The thing is, if/when I wait a while, the exception does not manifest itself and the applet does start up. As if the server needs time to clean up...something I want to force it doing...right away.

More to follow

Thor
Edit1 : still no luck - of course, the server is a recycled PC (256Mb ram) and CentOS 5.2, still more than 20Gb disk left. But... I am the only one on this thing...
Any (I really mean ANY) thoughts (no matter how funny or off-topic, I could use SOME feedback here) are more than welcome...
Edit2 : is it normal that my local JVM just ... stops? I've set the thing to display the console, just to see anything locally getting lost in the fog, but the panel stops, after a "ps -A" there is no more JVM inthe shop...
I have to restart the applet several times to get it working, of course, every attempt leaves its marks on the server in still-open connections...
I still invite ANYONE for thoughts, inputs, off-topics, ...

Last edited by Thor@Flanders (2010-12-05 17:59:40)