Max User Connection
Posted: Sat Mar 18, 2017 1:10 pm
How much (mysql)tcp connections l2js needs?
Page 1 of 1
Re: Max User Connection
Posted: Sat Mar 18, 2017 3:44 pm
100?
Re: Max User Connection
Posted: Sat Mar 18, 2017 7:18 pm
somebody put cfg for mysql for 10-30 people?
Re: Max User Connection
Posted: Sat Mar 18, 2017 9:11 pm
Re: Max User Connection
Posted: Tue Mar 21, 2017 4:19 pm
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