|
You last visited: Today at 14:38
Advertisement
Too many connection
Discussion on Too many connection within the CO2 Private Server forum part of the Conquer Online 2 category.
05/23/2012, 11:06
|
#1
|
elite*gold: 0
Join Date: Oct 2008
Posts: 708
Received Thanks: 46
|
Too many connection
|
|
|
05/23/2012, 11:13
|
#2
|
elite*gold: 20
Join Date: Mar 2006
Posts: 6,125
Received Thanks: 2,518
|
Yes your correct thats exactly what it says.
|
|
|
05/23/2012, 11:20
|
#3
|
elite*gold: 21
Join Date: Jul 2005
Posts: 9,193
Received Thanks: 5,376
|
Solution obviously being...
#1: Hold a connection open and process all sql queries through it.
#2: Close your connections when you're done with them.
Problem solved!
|
|
|
05/23/2012, 11:25
|
#4
|
elite*gold: 0
Join Date: Oct 2008
Posts: 708
Received Thanks: 46
|
Quote:
Originally Posted by pro4never
Solution obviously being...
#1: Hold a connection open and process all sql queries through it.
#2: Close your connections when you're done with them.
Problem solved!
|
thanks for your help but can u explain more please i'm noop i'm use old mysql win (binary 95 mysql)
|
|
|
05/23/2012, 12:01
|
#5
|
elite*gold: 20
Join Date: Mar 2006
Posts: 6,125
Received Thanks: 2,518
|
I swear you should give like 80% of your donations to the community here, without us your server wouldnt be online >_>.
I mean come on, atleast try and fix it yourself, go research that error.
|
|
|
05/23/2012, 12:05
|
#6
|
elite*gold: 0
Join Date: Jun 2009
Posts: 611
Received Thanks: 195
|
Didn't Fang give people a killconnection system ?
|
|
|
05/23/2012, 13:04
|
#7
|
elite*gold: 0
Join Date: Apr 2009
Posts: 773
Received Thanks: 441
|
instead of using things like "kill all connection system"...
why not just use EO mysql functions??? its easy to extract and you can build your own sql wrapper.... its fast and better.... since you just need to read a little...
Btw... its just an idea ^^
|
|
|
05/23/2012, 13:53
|
#8
|
elite*gold: 0
Join Date: Oct 2008
Posts: 708
Received Thanks: 46
|
Quote:
Originally Posted by 12tails
instead of using things like "kill all connection system"...
why not just use EO mysql functions??? its easy to extract and you can build your own sql wrapper.... its fast and better.... since you just need to read a little...
Btw... its just an idea ^^
|
give me link please of that mysql
|
|
|
05/23/2012, 14:55
|
#9
|
elite*gold: 20
Join Date: Jun 2006
Posts: 3,296
Received Thanks: 924
|
Quote:
Originally Posted by magnon
give me link please of that mysql
|
Eudemons source code, find it.
|
|
|
05/23/2012, 19:43
|
#10
|
elite*gold: 12
Join Date: Jul 2011
Posts: 8,211
Received Thanks: 4,114
|
Solution... close and dispose of ALL connections after you're done using them or better yet, create a destructor method in the MySql read and write classes. Run the kill connections function I wrote and execute it on a thread within a while loop. Loop it every 5 minutes or so.
|
|
|
05/23/2012, 21:39
|
#11
|
elite*gold: 0
Join Date: May 2008
Posts: 1,769
Received Thanks: 1,142
|
Basically what Fang said. Sure, if you close all the connections you SHOULD be okay, but that's not always the case. You really should prune the ones that didn't get closed every [insert interval here]. Just make sure you're not killing any active connections in the process of doing so. Also, the real problem you're having is that you didn't set your MySQL Daemon's max_connections higher than the standard amount for a home computer, which you should have done during the setup process..
|
|
|
05/24/2012, 01:23
|
#12
|
elite*gold: 12
Join Date: Jul 2011
Posts: 8,211
Received Thanks: 4,114
|
Quote:
Originally Posted by Zeroxelli
Basically what Fang said. Sure, if you close all the connections you SHOULD be okay, but that's not always the case. You really should prune the ones that didn't get closed every [insert interval here]. Just make sure you're not killing any active connections in the process of doing so. Also, the real problem you're having is that you didn't set your MySQL Daemon's max_connections higher than the standard amount for a home computer, which you should have done during the setup process..
|
My function kill connections that are sleeping. You should close all connections after using them or you'll run into problems. My function doesn't make up for bad programing techniques.
|
|
|
05/24/2012, 01:39
|
#13
|
elite*gold: 0
Join Date: May 2008
Posts: 1,769
Received Thanks: 1,142
|
Quote:
Originally Posted by Fаng
My function kill connections that are sleeping. You should close all connections after using them or you'll run into problems. My function doesn't make up for bad programing techniques.
|
Well then that's good, I hadn't looked at it. And nothing really does clean up after bad programming.
|
|
|
05/24/2012, 10:31
|
#14
|
elite*gold: 0
Join Date: Dec 2011
Posts: 1,537
Received Thanks: 785
|
Solution:
>Connect
>Execute
>Close Connection
DON'T KEEP CONNECTIONS OPEN!!!!!!!!!!!!
**** MySQL anyways.
|
|
|
05/24/2012, 11:48
|
#15
|
elite*gold: 12
Join Date: Jul 2011
Posts: 8,211
Received Thanks: 4,114
|
Quote:
Originally Posted by I don't have a username
Solution:
>Connect
>Execute
>Close Connection
DON'T KEEP CONNECTIONS OPEN!!!!!!!!!!!!
**** MySQL anyways.
|
MsSql has the same problem with sleeping connections (I believe). I haven't gotten far enough to implement my function yet on my server. I'll do that tomorrow (maybe) and double check.
|
|
|
|
|
Similar Threads
|
New Connection
04/22/2012 - DarkOrbit - 5 Replies
Please i need help from profitional because i have connextion ADSL and when i click star to play darkorbit she give me new connection and logout and i format my pc and the problem still during please any one can help im waiting for any segues
|
Connection
10/06/2010 - Metin2 Private Server - 4 Replies
Im having a problem with connection with my dyndns server ive add all the port to my modem and set them up for my serverinfo.py but when i login it gets to char screen then kicks me
|
ERROR: Connection failed. Host 'Mcncc.com' is blocked because of many connection erro
04/10/2010 - Metin2 Private Server - 8 Replies
Hab ein Problem mit meinem DynDns Server nach einiger Zeit kommt bei der DB und Regi immer olgendes "ERROR: Connection failed. Host 'Mcncc.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'" kann mir jemand sagen woran das liegt?
|
connection: Connection refused
11/21/2009 - Metin2 Private Server - 16 Replies
Hi Leute,
ich wollte meinen server neu starten und dann kam etwas wie das hier.
http://www2.pic-upload.de/thumb/05.10.09/ug5fybhq f9b.jpg
Dann habe ich es neu versucht und dann kamen manchmal Core Fehler!!
Weiß jemand wie man diese Fehler beheben kann?
|
i cant connection
07/11/2008 - EO PServer Hosting - 3 Replies
http://www5.0zz0.com/2008/07/11/13/419569605.jpg
|
All times are GMT +2. The time now is 14:38.
|
|