How to increase MySQL Connections limit Друк

  • 389

If you need to increase MySQL Connections without MySQL restart do below step, also if you don't know configuration file, below use the MySQL workbench or PHPMyAdmin or command prompt to run below queries.

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

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

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

These settings will change at MySQL Restart.


Ця відповідь Вам допомогла?

« Назад

Powered by WHMCompleteSolution