Max User Connection
Forum rules
READ NOW: L2j Forums Rules of Conduct
READ NOW: L2j Forums Rules of Conduct
-
KGB1st
- Posts: 230
- Joined: Sat Jul 26, 2014 5:58 pm
Max User Connection
How much (mysql)tcp connections l2js needs?
-
Sacrifice
- Advanced User
- Posts: 1027
- Joined: Thu Aug 14, 2014 6:31 am
-
KGB1st
- Posts: 230
- Joined: Sat Jul 26, 2014 5:58 pm
Re: Max User Connection
somebody put cfg for mysql for 10-30 people?
-
stanik
- Posts: 12
- Joined: Sun Feb 19, 2017 10:05 pm
-
KGB1st
- Posts: 230
- Joined: Sat Jul 26, 2014 5:58 pm
Re: Max User Connection
Because you must configure your mysql.ini or .conf where type max_connection to 500+1 for another user, something as root or pma 
Light optimization for mysql.conf
- look at server.properties and check MaximumDbConnections param
- set in your mysql.conf max_connections to MaximumDbConnections + 1
I have allocated about 1k mb of ram for clear GS, LS DBs (this's after my optimizations for ibd tables)
p.s. max_connections it's a global param, instead you can override mysql configuration by derectives in db for each user personally. I use max_connections because it's simple and I debug my srv. What your server doing, i don't know
Light optimization for mysql.conf
- look at server.properties and check MaximumDbConnections param
- set in your mysql.conf max_connections to MaximumDbConnections + 1
I have allocated about 1k mb of ram for clear GS, LS DBs (this's after my optimizations for ibd tables)
p.s. max_connections it's a global param, instead you can override mysql configuration by derectives in db for each user personally. I use max_connections because it's simple and I debug my srv. What your server doing, i don't know