asked on

max concurrent connection MariaDB and DB2

hi,

I am comparing major DB concurrent connection limit, what is the max concurrent connection MariaDB and DB2 can accept ?

SOLUTION

David Johnson, CD

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

marrowyung

ASKER

MariaDB max CONCURRENT connection is only 151 connections ?? very less. but this is ONLY the default one, how MAX we can enlarge it?
no limit as long as RAM and performance support ?

"DB2 configurable maximum is 64000
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.config.doc/doc/r0052306.html"

that link doesn't say 64000, please let me know.

one similiar thing is , will there any connection limit diff between Oracle on Windows and Oracle on oracle linux ?

ASKER CERTIFIED SOLUTION

Tomas Helgi Johannsson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

marrowyung

ASKER

ok.

MariaDB is good then.

now, I have checked out that oracle only allow 2048 concurrent connection, is that still hold truth for Oracle ?

MS SQL only allow for 32767 ?

Tomas Helgi Johannsson

Hi,

Oracle max concurrent connections is a very high number see the link below for more detail.

https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams220.htm#REFRN10197

As always max concurrent connections for any database depends also on other factors as well like number of CPUs etc.

Regards,
Tomas Helgi

marrowyung

ASKER

so is MS SQL max connection really 32767 only ?

Tomas Helgi Johannsson

Hi!

>so is MS SQL max connection really 32767 only ?
Yes, unfortunately.

Regards,
Tomas Helgi

marrowyung

ASKER

OMG!

marrowyung

ASKER

tks all.