Untuk merubah temporary tanpa merestart server

SET GLOBAL max_connections = [nilai];

Contoh

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

mysql> SHOW VARIABLES LIKE "max_connections";
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 5000  |
+-----------------+-------+
1 row in set (0.00 sec)

Leave a Reply

Your email address will not be published. Required fields are marked *