Problem In Channel

08/29/2012 17:08 Metin2 AR#1
Where I'm start 2 Channel
and go to start Channel 3
Putty Send Me This Message
mysql_real_connect: Too many connections
cannot open direct sql connection to host: localhost user: mt2 db: common
cannot start server while no common sql connected
And NaviCat Give Me 1040 - Too many connections


how fix and start 4 Channel and open Navicat ??
08/29/2012 18:09 Al.Pacino#2
You have to set up the "max_connections" of mysql. Set them to something like 3000, 3500, 4000 etc.
08/29/2012 21:55 Metin2 AR#3
I'm Start Channel 2
But Channel 3 Or 4 Give Me
mysql_real_connect: Too many connections
cannot open direct sql connection to host: localhost user: mt2 db: common
cannot start server while no common sql connected
08/29/2012 22:00 iSouli~#4
Go into putty and insert "mysql -p" and input your Password.
Next insert in putty "SET GLOBAL max_connections=40000;" and restart MySql per "service mysql-server restart" .
08/29/2012 22:04 Al.Pacino#5
Quote:
Originally Posted by -Soulution- View Post
Go into putty and insert "mysql -p" and input your Password.
Next insert in putty "SET GLOBAL max_connections=40000;" and restart MySql per "service mysql-server restart" .
9999 ist maximum.
08/29/2012 22:36 iSouli~#6
Quote:
Originally Posted by Al.Pacino View Post
9999 ist maximum.
Ja er kanns so machen wie er es möchte das war nur ein Beispiel , am besten wäre sowieso sich eine my.cnf einzurichten.
08/29/2012 22:37 Metin2 AR#7
Not Fixet

I'm Start 2 Channel And I Can't start Channel 3 Or 4

Help Me !!
08/30/2012 11:47 Al.Pacino#8
Quote:
Originally Posted by Metin2 AR View Post
Not Fixet

I'm Start 2 Channel And I Can't start Channel 3 Or 4

Help Me !!
Once you restarted the dedicated server, you have to set up the "max_connections" again. Alternative you can create a my.cnf and don't have to change the "max_connections" on every reboot.
08/30/2012 12:28 Metin2 AR#9
How create a my.cnf
08/30/2012 12:51 IgorGlock#10
Turn your homepage offline, reboot the server, try to start your server again.
08/31/2012 13:33 Metin2 AR#11
Quote:
Originally Posted by IgorGlock View Post
Turn your homepage offline, reboot the server, try to start your server again.
Why ??
08/31/2012 13:49 IgorGlock#12
Don't ask badass - just do!
08/31/2012 15:43 Metin2 AR#13
Ok
But Peoblem Not fix !
08/31/2012 16:58 Al.Pacino#14
Quote:
Originally Posted by Metin2 AR View Post
Ok
But Peoblem Not fix !
mysql -u root -p

PHP Code:
SET GLOBAL max_connections=9999
start server -> win
08/31/2012 17:42 Metin2 AR#15
[Only registered and activated users can see links. Click Here To Register...]
OK ??