marrowyung
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 ?
I am comparing major DB concurrent connection limit, what is the max concurrent connection MariaDB and DB2 can accept ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 ?
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 ?
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
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
ASKER
so is MS SQL max connection really 32767 only ?
Hi!
>so is MS SQL max connection really 32767 only ?
Yes, unfortunately.
Regards,
Tomas Helgi
>so is MS SQL max connection really 32767 only ?
Yes, unfortunately.
Regards,
Tomas Helgi
ASKER
OMG!
ASKER
tks all.
ASKER
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 ?