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 ?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David Johnson, CD, MVPOwnerCommented:
MariaDB

The system variable max_connections determines the number of connections which MySQL/MariaDB will accept. The default value is 151 connections, which allows 150 normal connections plus one connection from the SUPER account.
The first thing to decide is what new maximum value you want to set for max_connections. There are several considerations to take into account when increasing the number of MySQL/MariaDB connections. The maximum number which can be supported by the system will depend on:

The amount of available RAM.
How much RAM each connection takes (simple queries will require less RAM than more labor-intensive connections).
The acceptable response time.
According to the MySQL documentation, most Linux systems should be able to support 500-1000 connections without difficulty.
https://www.1and1.com/cloud-community/learn/database/mysqlmariadb/solve-a-mysqlmariadb-too-many-connections-error/

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
0
marrowyungSenior Technical architecture (Data)Author Commented:
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 ?
0
Tomas Helgi JohannssonCommented:
Hi!

Please note that max connections for
MariaDB is set to a default of 151 concurrent connections but can range from 1 to 100000 see here for more info

DB2 has a default of 200 concurrent connections with a range from 1 to 64000 see here for more info

In short, maximum concurrent connections for
MariaDB : 100000
DB2 : 64000

Both databases allow this parameters to be set dynamically that is without rebooting the database service.

Regards,
      Tomas Helgi
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

marrowyungSenior Technical architecture (Data)Author Commented:
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 ?
0
Tomas Helgi JohannssonCommented:
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
0
marrowyungSenior Technical architecture (Data)Author Commented:
so is MS SQL max connection really 32767 only ?
0
Tomas Helgi JohannssonCommented:
Hi!

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

Regards,
     Tomas Helgi
0
marrowyungSenior Technical architecture (Data)Author Commented:
OMG!
0
marrowyungSenior Technical architecture (Data)Author Commented:
tks all.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MariaDB

From novice to tech pro — start learning today.