Register for your free account! | Forgot your password?

Go Back   elitepvpers > Conquer Online 2 > CO2 PServer - Discussions / Questions
You last visited: Today at 00:26

  • Please register to post and access all features, it's quick, easy and FREE!

 

1040 Too many connection Mysql5.1

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Oct 2011
Posts: 267
Received Thanks: 58
1040 Too many connection Mysql5.1

hi guys,

Im having error on my console mysql pool conenction has reached the max connection. Is it possible that someone is flooding me or what? any idea guys would be apreciated. My concurrent connection is 1000.



-Sensei- is offline  
Old   #2
 
elite*gold: 0
Join Date: Dec 2011
Posts: 1,537
Received Thanks: 782
Why do you even have a max connection?

A proper way to handle sql queries would be "connection -> handle -> disconnect" everytime you have to do anything database related. Never keep a connection open, if you aren't going to use it.

But this has also been discussed a lot of time, if you searched. Just find the kill thing released by Fang, tho it's still a poor way to handle MySQL.


I don't have a username is offline  
Old   #3
 
elite*gold: 0
Join Date: May 2008
Posts: 1,769
Received Thanks: 1,137
You're obviously not closing your connections properly. Set your MaxConnections to 50 and see how fast it takes to kill the server. If it lasts less than a few minutes, it's most likely your code.
Zeroxelli is offline  
Old   #4
 
elite*gold: 0
Join Date: Jul 2008
Posts: 13
Received Thanks: 11
in your server look for the mysql folder and edit the my.ini file. Lok=ok for
MAX CONNECTION =
And input a rediculously high number like 1000000000
should solve your issue.


Nespheratu is offline  
Old   #5
 
elite*gold: 0
Join Date: May 2008
Posts: 1,769
Received Thanks: 1,137
Quote:
Originally Posted by Nespheratu View Post
in your server look for the mysql folder and edit the my.ini file. Lok=ok for
MAX CONNECTION =
And input a rediculously high number like 1000000000
should solve your issue.
That's.. not a solution at all.
Zeroxelli is offline  
Old   #6
 
elite*gold: 0
Join Date: Dec 2011
Posts: 1,537
Received Thanks: 782
Quote:
Originally Posted by Zeroxelli View Post
That's.. not a solution at all.
It is a solution, but an idiotic one.
I don't have a username is offline  
Old   #7
 
elite*gold: 81
Join Date: Sep 2006
Posts: 716
Received Thanks: 1,135
Quote:
Originally Posted by I don't have a username View Post
It is a solution, but an idiotic one.
hehe
MeGaMaX. is offline  
Old   #8
 
elite*gold: 0
Join Date: Oct 2011
Posts: 267
Received Thanks: 58
Thanks for the reply guys i fixed it already .
something wrong in my mysqlcommand execute. it gives pool++ in every execute.
-Sensei- is offline  
Old   #9
 
elite*gold: 0
Join Date: Aug 2007
Posts: 1,524
Received Thanks: 230
Quote:
Originally Posted by -Sensei- View Post
Thanks for the reply guys i fixed it already .
something wrong in my mysqlcommand execute. it gives pool++ in every execute.
Glad for ya Dude ...Wish u the best of luck ever
shadowman123 is offline  
Thanks
1 User
Old   #10
 
elite*gold: 0
Join Date: Oct 2011
Posts: 267
Received Thanks: 58
Quote:
Originally Posted by shadowman123 View Post
Glad for ya Dude ...Wish u the best of luck ever
Thank you and same to you.


-Sensei- is offline  
Thanks
1 User
Reply



« Previous Thread | Next Thread »

Similar Threads
I'm "EAT" Attack (#1040 Too many connection) or DDOS :(
http://e1207.hizliresim.com/z/m/9v4tc.png Please help me friends. Difficult situation. Each lag gives this error when the putty How do I prevent...
5 Replies - Metin2 PServer - Discussions / Questions
Mysql5 hash converter
Hey Com, ich frage mich schon lange ob man die Passwörter in der Mysql Datenbank in die ursprünglichen Passwörter umwandeln kann (Hashcode -->...
11 Replies - Metin2 PServer - Discussions / Questions
hilfe bei mysql5
15a6fc60209aa00e85938009810130dc7d39e170 übersetzt das pls
3 Replies - General Coding



All times are GMT +1. The time now is 00:26.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.