CODEWITHSUNDEEP
mysqldatabasesocketsdatabase-connection
shekhar
shekhar

Reputation: 937

How to increase MySQL connections(max_connections)?

Every socket of MySQL Database will have defaults connections as 100 but I am looking for any way to increase the number of possible connections > 100 to a socket connection of MySQL Database.

Upvotes: 72

Views: 218266

Answers (4)

Jugal K Saini
Jugal K Saini

Reputation: 1

The best way to increase max. connections and all other RDS parameters is that we can create a new parameter group with desired requirements for our RDS parameters. after creating this parameter group , we can attach this and replace default parameter group. the benefit of creating parameter group is that we can attach this parameter group and have same properties in multiple RDS instances and whenever required we can update parameters value and it will take effect in all RDS instances which have parameter group associated.

Hope you find this Helpful.

Upvotes: 0

Guillaume
Guillaume

Reputation: 356

I had the same issue and I resolved it with MySQL workbench, as shown in the attached screenshot:

  1. in the navigator (on the left side), under the section "management", click on "Status and System variables",
  2. then choose "system variables" (tab at the top),
  3. then search for "connection" in the search field,
  4. and 5. you will see two fields that need to be adjusted to fit your needs (max_connections and mysqlx_max_connections).

Hope that helps!

The system does not allow me to upload pictures, instead please click on this link and you can see my screenshot...

Upvotes: 6

Abdul Manaf
Abdul Manaf

Reputation: 4888

If you need to increase MySQL Connections without MySQL restart do like below

mysql> show variables like 'max_connections';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 100   |
+-----------------+-------+
1 row in set (0.00 sec)

mysql> SET GLOBAL max_connections = 150;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like 'max_connections';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 150   |
+-----------------+-------+
1 row in set (0.00 sec)

These settings will change at MySQL Restart.

For permanent changes add below line in my.cnf and restart MySQL

max_connections = 150

Upvotes: 168

Rahul Tripathi
Rahul Tripathi

Reputation: 172448

From Increase MySQL connection limit:-

MySQL’s default configuration sets the maximum simultaneous connections to 100. If you need to increase it, you can do it fairly easily:

For MySQL 3.x:

# vi /etc/my.cnf
set-variable = max_connections = 250

For MySQL 4.x and 5.x:

# vi /etc/my.cnf
max_connections = 250

Restart MySQL once you’ve made the changes and verify with:

echo "show variables like 'max_connections';" | mysql

EDIT:-(From comments)

The maximum concurrent connection can be maximum range: 4,294,967,295. Check MYSQL docs

Upvotes: 12

Related Questions