Max User Connection

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
User avatar
KGB1st
Posts: 230
Joined: Sat Jul 26, 2014 5:58 pm

Max User Connection

Post by KGB1st »

How much (mysql)tcp connections l2js needs?
Sacrifice
Advanced User
Advanced User
Posts: 1026
Joined: Thu Aug 14, 2014 6:31 am

Re: Max User Connection

Post by Sacrifice »

100? :eh:
User avatar
KGB1st
Posts: 230
Joined: Sat Jul 26, 2014 5:58 pm

Re: Max User Connection

Post by KGB1st »

somebody put cfg for mysql for 10-30 people?
User avatar
stanik
Posts: 12
Joined: Sun Feb 19, 2017 10:05 pm

Re: Max User Connection

Post by stanik »

KGB1st wrote: Sat Mar 18, 2017 7:18 pm somebody put cfg for mysql for 10-30 people?
sort of 500
Although, when I run 2 servers, then through the phpmyadmin I can not go
User avatar
KGB1st
Posts: 230
Joined: Sat Jul 26, 2014 5:58 pm

Re: Max User Connection

Post by KGB1st »

Because you must configure your mysql.ini or .conf where type max_connection to 500+1 for another user, something as root or pma :crazy:

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 :cry:
Post Reply