\u9ed8\u8ba4\u7684MySQL\u6570\u636e\u5e93\uff0c\u5176\u6700\u5927\u8fde\u63a5\u6570max_connections= 100<\/p>\n
\u67e5\u770b\u5f53\u524d\u7cfb\u7edf\u8fde\u63a5\u6570\u8bbe\u7f6e
\nMariaDB [(none)]> show variables like ‘max_connections’;<\/p>\n
max_connections\u4ee3\u8868\u7684\u610f\u4e49\u662f<\/p>\n
\u67e5\u770b\u5f53\u524d\u8fde\u63a5\u8be6\u7ec6<\/p>\n
show processlist;
\nshow full processlist;<\/p>\n
\u67e5\u770b\u5f53\u524d\u7684\u8fde\u63a5\u6570<\/p>\n
show status like “Threads%”;
\n+—————————+——-+
\n| Variable_name | Value |
\n+—————————+——-+
\n| Threads_cached | 4 |
\n| Threads_connected | 3 |
\n| Threads_connected_reserve | 1 |
\n| Threads_created | 7 |
\n| Threads_running | 3 |
\n+—————————+——-+
\n5 rows in set (0.00 sec)<\/p>\n
status\u4e5f\u53ef\u4ee5\u67e5\u770b\u5f53\u524d\u8fde\u63a5\u7684id\u53f7\uff0cThreads\u4e5f\u662f\u8fde\u63a5\u6570<\/p>\n
MariaDB [(none)]> status;
\n————–
\nmysql Ver 15.1 Distrib 5.5.33a-MariaDB, for Linux (x86_64) using readline 5.1<\/p>\n
Connection id:\t\t6213994
\nCurrent database:
\nCurrent user:\t\troot@localhost
\nSSL:\t\t\tNot in use
\nCurrent pager:\t\tstdout
\nUsing outfile:\t\t”
\nUsing delimiter:\t;
\nServer:\t\t\tMariaDB
\nServer version:\t\t5.5.33a-MariaDB-log MariaDB Server, wsrep_23.7.6.rXXXX
\nProtocol version:\t10
\nConnection:\t\tLocalhost via UNIX socket
\nServer characterset:\tlatin1
\nDb characterset:\tlatin1
\nClient characterset:\tutf8
\nConn. characterset:\tutf8
\nUNIX socket:\t\t\/tmp\/mysql.sock
\nUptime:\t\t\t236 days 16 hours 13 min 48 sec<\/p>\n
Threads: 95 Questions: 160672130 Slow queries: 2410 Opens: 102274 Flush tables: 2 Open tables: 400 Queries per second avg: 7.857
\n————–<\/p>\n","protected":false},"excerpt":{"rendered":"
\u9ed8\u8ba4\u7684MySQL\u6570\u636e\u5e93\uff0c\u5176\u6700\u5927\u8fde\u63a5\u6570max_connections= 100 \u67e5\u770b\u5f53\u524d\u7cfb\u7edf\u8fde\u63a5\u6570\u8bbe\u7f6e MariaDB [(none)]> show variables like ‘max_connections’; max_connections\u4ee3\u8868\u7684\u610f\u4e49\u662f \u67e5\u770b\u5f53\u524d\u8fde\u63a5\u8be6\u7ec6 show processlist; show full processlist; \u67e5\u770b\u5f53\u524d\u7684\u8fde\u63a5\u6570 show status like “Threads%”; +—————————+——-+ | Variable_name | Value | +—————————+——-+ | Threads_cached | 4 | | Threads_connected | 3 | | Threads_connected_reserve | 1 | | Threads_created | 7 | | Threads_running | 3 | +—————————+——-+ 5 […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-6470","post","type-post","status-publish","format-standard","hentry","category-life"],"_links":{"self":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/6470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6470"}],"version-history":[{"count":4,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/6470\/revisions"}],"predecessor-version":[{"id":6475,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/6470\/revisions\/6475"}],"wp:attachment":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}