MYsql Data Exception.

[kioklo]

Hello, i got little bug in my server that do that and We can't log in, Major lag in game :S





I pray my screen will help to understand.

[Spirited]

Sleeping connections are maxing out the connection pool.

Add a new thread that runs that every 30 seconds and remember to DISPOSE of your connections..

[kioklo]

Thanks fang, u are very helpfull for me

ok you will probaly think i'm stupid but ...Where to put it lol

I'm looking for answer again :P Thanks for watching

[MidNewt]

Thanks for the code where i put it?

[Spirited]

Originally Posted by MidNewt

Thanks for the code where i put it?

Nobody on earth will tell you. I already told you want to do.
I don't help people who can't help themselves.

[MidNewt]

If i understand good i need to add new Thread so probaly in Thread.cs? and if i need to run that every 30 seconds probaly in programs.cs.

[kioklo]

Thanks for the code...my source crash and i can't fix it lol..

[Spirited]

Originally Posted by kioklo

Thanks for the code...my source crash and i can't fix it lol..

My code doesn't cause anything to crash.
You must be using it VERY VERY wrong then.