max concurrent connection MariaDB and DB2

marrowyung
marrowyung used Ask the Experts™
on
hi,

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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
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
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 ?
Database Administrator / Software Engineer
Commented:
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
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

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 ?
Tomas Helgi JohannssonDatabase Administrator / Software Engineer

Commented:
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
marrowyungSenior Technical architecture (Data)

Author

Commented:
so is MS SQL max connection really 32767 only ?
Tomas Helgi JohannssonDatabase Administrator / Software Engineer

Commented:
Hi!

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

Regards,
     Tomas Helgi
marrowyungSenior Technical architecture (Data)

Author

Commented:
OMG!
marrowyungSenior Technical architecture (Data)

Author

Commented:
tks all.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial