How to increase MySQL connections(max_connections)?

by

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

More Related Contents:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. Remote connect to clearDB heroku database
  3. Reorder / reset auto increment primary key
  4. MySQL Trigger after update only if row has changed
  5. Error creating table: You have an error in your SQL syntax near ‘order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ‘ at line 1 [duplicate]
  6. MySQL Query to select data from last week?
  7. Select last N rows from MySQL
  8. How do I add a custom CHECK constraint on a MySQL table?
  9. How can I modify the size of column in a MySQL table?
  10. MySQL InnoDB foreign key between different databases
  11. How to insert data to MySQL with auto-incremented column(field)?
  12. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  13. Implementing a hierarchical data structure in a database
  14. Does MySQL allows to create database with dot?
  15. Commit data in a mysql container
  16. mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists
  17. MySQL – Persistent connection vs connection pooling
  18. Laravel join with 3 Tables
  19. Difference between two table structure
  20. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  21. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  22. Rename a table in MySQL
  23. Where does MySQL store database files on Windows and what are the names of the files?
  24. Should I normalize my DB or not?
  25. MySQL: how to do row-level security (like Oracle’s Virtual Private Database)?
  26. MySQL: Check if the user exists and drop it
  27. WooCommerce: Finding the products in database
  28. Are there any functions in MySQL like dense_rank() and row_number() like Oracle?
  29. Optimistic locking in MySQL
  30. mySQL SELECT upcoming birthdays

Leave a Comment