\u540c\u6642\u63a5\u7d9a\u6570\u3068\u6700\u5927\u63a5\u7d9a\u6570\u3092\u78ba\u8a8d\u3059\u308b\u65b9\u6cd5<\/p>\n
Threads_connected\uff1a\u540c\u6642\u63a5\u7d9a\u6570<\/p>\n
show global status like ‘Threads_connected’;<\/p>\n
mysql> show global status like ‘Threads_connected’;
\n+——————-+——-+
\n| Variable_name | Value |
\n+——————-+——-+
\n| Threads_connected | 148 |
\n+——————-+——-+<\/p>\n
max_connections\uff1a\u6700\u5927\u63a5\u7d9a\u6570
\nshow global variables like ‘max_connections’;<\/p>\n
mysql> show global variables like ‘max_connections’;
\n+—————–+——-+
\n| Variable_name | Value |
\n+—————–+——-+
\n| max_connections | 150|
\n+—————–+——-+<\/p>\n
\u540c\u6642\u63a5\u7d9a\u6570\u3092\u5909\u66f4\u3059\u308b\u306b\u306f\u3001max_connections\u3092\u5909\u66f4\u3059\u308b\u3002<\/p>\n
mysql> set global max_connections = 100;
\nmysql> show global variables like ‘max_connections’;
\n+—————–+——-+
\n| Variable_name | Value |
\n+—————–+——-+
\n| max_connections | 256 |
\n+—————–+——-+<\/p>\n
SET\u53e5\u3067\u5909\u66f4\u3057\u305f\u5024\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u518d\u8d77\u52d5\u6642\u306b\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u5024\u3067\u4e0a\u66f8\u304d\u3055\u308c\u3066\u3057\u307e\u3046\u306e\u3067\u3001\u6c38\u7d9a\u7684\u306b\u5909\u66f4\u304c\u5fc5\u8981\u306a\u5834\u5408\u306f
\n\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\uff08my.cmf\u307e\u305f\u306fmy.ini\uff09\u306b\u306f\u6b21\u306e\u3088\u3046\u306b\u8a18\u8ff0\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u5024\u3092\u5909\u66f4\u3059\u308b\u3002<\/p>\n
max_connections=256<\/p>\n