這篇文章主要介紹MySQL中Galera cluster集群常用參數(shù)有哪些，文中介紹的非常詳細(xì)，具有一定的參考價(jià)值，感興趣的小伙伴們一定要看完！

網(wǎng)站建設(shè)哪家好，找成都創(chuàng)新互聯(lián)公司！專注于網(wǎng)頁(yè)設(shè)計(jì)、網(wǎng)站建設(shè)、微信開(kāi)發(fā)、小程序開(kāi)發(fā)、集團(tuán)企業(yè)網(wǎng)站建設(shè)等服務(wù)項(xiàng)目。為回饋新老客戶創(chuàng)新互聯(lián)還提供了博興免費(fèi)建站歡迎大家使用！

1、wsrep_local_state_uuid：
與集群的wsrep_cluster_state_uuid一致
root@[(none)]> show status like '%wsrep_%_state_uuid%';
+--------------------------+--------------------------------------+
| Variable_name            | Value                                |
+--------------------------+--------------------------------------+
| wsrep_local_state_uuid   | eebe303f-5262-11e8-9e80-8a8d79151541 |
| wsrep_cluster_state_uuid | eebe303f-5262-11e8-9e80-8a8d79151541 |
+--------------------------+--------------------------------------+

2、wsrep_last_committed：
集群已經(jīng)提交事務(wù)數(shù)目，是一個(gè)累計(jì)值，所有節(jié)點(diǎn)應(yīng)該相等，如果出現(xiàn)不一致，說(shuō)明事務(wù)有延遲，可以用來(lái)計(jì)算延遲。
root@[(none)]> show status like '%wsrep_last_committed%';
+----------------------+--------+
| Variable_name        | Value  |
+----------------------+--------+
| wsrep_last_committed | 115562 |
+----------------------+--------+

3、wsrep_replicated：
從本地節(jié)點(diǎn)復(fù)制出去的寫(xiě)集(write set)數(shù)目，wsrep_replicated_bytes為寫(xiě)集的總字節(jié)數(shù)；可以用于參考節(jié)點(diǎn)之間的負(fù)載均衡是否平衡；該值較大的節(jié)點(diǎn)較為繁忙。
root@[(none)]> show status like '%wsrep_replicated%';
+------------------------+----------+
| Variable_name          | Value    |
+------------------------+----------+
| wsrep_replicated       | 13579    |
| wsrep_replicated_bytes | 35585864 |
+------------------------+----------+

4、wsrep_received：
與wsrep_replicated對(duì)應(yīng)，表示接收來(lái)自其他節(jié)點(diǎn)的寫(xiě)集(write set)數(shù)目.
root@[(none)]> show status like '%wsrep_received%';
+----------------------+----------+
| Variable_name        | Value    |
+----------------------+----------+
| wsrep_received       | 11036    |
| wsrep_received_bytes | 35576367 |
+----------------------+----------+

5、wsrep_local_commits：
從本地節(jié)點(diǎn)發(fā)出的寫(xiě)集(write set)被提交的數(shù)目，不超過(guò)wsrep_replicated的數(shù)目。
root@[(none)]> show status like '%wsrep_local_commits%';
+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| wsrep_local_commits | 13582 |
+---------------------+-------+

6、wsrep_local_cert_failures：
同步過(guò)程中節(jié)點(diǎn)認(rèn)證失敗計(jì)數(shù)，沖突來(lái)自本地提交的事務(wù)和同步隊(duì)列中事務(wù)存在鎖沖突，則本地驗(yàn)證失?。ūＷC全局?jǐn)?shù)據(jù)一致性）。
root@[(none)]> show status like '%wsrep_local_cert_failures%';
+---------------------------+-------+
| Variable_name             | Value |
+---------------------------+-------+
| wsrep_local_cert_failures | 0     |
+---------------------------+-------+

7、wsrep_local_bf_aborts：
強(qiáng)制放棄的寫(xiě)集數(shù)目，本地事務(wù)和同步隊(duì)列中正在執(zhí)行的事務(wù)存在鎖沖突時(shí)，將強(qiáng)制保證先提交的事務(wù)成功，后者回滾或報(bào)錯(cuò)。
root@[(none)]> show status like '%wsrep_local_bf_aborts%';
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| wsrep_local_bf_aborts | 1     |
+-----------------------+-------+

8、wsrep_local_send_queue：
發(fā)送隊(duì)列的長(zhǎng)度。wsrep_local_send_queue_avg：從上次查詢狀態(tài)到目前發(fā)送隊(duì)列的平均長(zhǎng)度，>0.0意味著復(fù)制過(guò)程被節(jié)流了。
root@[(none)]> show status like '%wsrep_local_send_queue%';
+----------------------------+----------+
| Variable_name              | Value    |
+----------------------------+----------+
| wsrep_local_send_queue     | 0        |
| wsrep_local_send_queue_max | 2        |
| wsrep_local_send_queue_min | 0        |
| wsrep_local_send_queue_avg | 0.000145 |
+----------------------------+----------+

9、wsrep_local_recv_queue：
接收隊(duì)列的長(zhǎng)度，與wsrep_local_send_queue對(duì)應(yīng)。
root@[(none)]> show status like '%wsrep_local_send_queue%';
+----------------------------+----------+
| Variable_name              | Value    |
+----------------------------+----------+
| wsrep_local_send_queue     | 0        |
| wsrep_local_send_queue_max | 2        |
| wsrep_local_send_queue_min | 0        |
| wsrep_local_send_queue_avg | 0.000145 |
+----------------------------+----------+

10、wsrep_cert_deps_distance：
可以并行執(zhí)行的寫(xiě)集(write set)的最大seqno與最小seqno之間的平均差值。
root@[(none)]> show status like '%wsrep_cert_deps_distance%';
+--------------------------+-----------+
| Variable_name            | Value     |
+--------------------------+-----------+
| wsrep_cert_deps_distance | 33.977434 |
+--------------------------+-----------+

11、wsrep_apply_oooe：
隊(duì)列中事務(wù)并發(fā)執(zhí)行占比，值越高意味著效率越高。
root@[(none)]> show status like '%wsrep_apply_oooe%';
+------------------+----------+
| Variable_name    | Value    |
+------------------+----------+
| wsrep_apply_oooe | 0.006204 |
+------------------+----------+

12、wsrep_commit_window：
平均并發(fā)提交窗口大小。
root@[(none)]> show status like '%wsrep_commit_window%';
+---------------------+----------+
| Variable_name       | Value    |
+---------------------+----------+
| wsrep_commit_window | 1.000423 |
+---------------------+----------+

13、wsrep_local_state：
節(jié)點(diǎn)的狀態(tài),取值1-6。
取值1：The node starts and establishes a connection to the Primary Component.
取值2：When the node succeeds with a state transfer request, it begins to cache write-sets.
取值3：The node receives a State Snapshot Transfer. It now has all cluster data and begins to apply the cached write-sets.
Here the node enables Flow Control to ensure an eventual decrease in the slave queue.
取值4：The node finishes catching up with the cluster. Its slave queue is now empty and it enables Flow Control to keep it empty.
The node sets the MySQL status variable wsrep_ready to the value 1. The node is now allowed to process transactions.
取值5：The node receives a state transfer request. Flow Control relaxes to DONOR. The node caches all write-sets it cannot apply.
取值6：The node completes the state transfer to joiner node.
root@[(none)]> show status like '%wsrep_local_state%';
+---------------------------+--------------------------------------+
| Variable_name             | Value                                |
+---------------------------+--------------------------------------+
| wsrep_local_state_uuid    | eebe303f-5262-11e8-9e80-8a8d79151541 |
| wsrep_local_state         | 4                                    |
| wsrep_local_state_comment | Synced                               |
+---------------------------+--------------------------------------+

14、wsrep_incoming_addresses：
集群中其它節(jié)點(diǎn)的地址，多個(gè)地址之間用逗號(hào)分隔。
root@[(none)]> show status like '%wsrep_incoming_addresses%';
+--------------------------+-------------------------- -+
| Variable_name            | Value                      |
+--------------------------+-------------------------- -+
| wsrep_incoming_addresses | IP1:3306,IP2:3306,IP3:3306 |
+--------------------------+----------------------------+

15、wsrep_cluster_conf_id：
集群節(jié)點(diǎn)關(guān)系改變的次數(shù)（每次增加/刪除都會(huì)+1）。
root@[(none)]> show status like '%wsrep_cluster_conf_id%';
+-----------------------+-------+                        
| Variable_name         | Value |                        
+-----------------------+-------+                        
| wsrep_cluster_conf_id | 53    |                        
+-----------------------+-------+      

16、wsrep_cluster_size：集群節(jié)點(diǎn)個(gè)數(shù)。
root@[(none)]> show status like '%wsrep_cluster_size%';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| wsrep_cluster_size | 3     |
+--------------------+-------+
17、wsrep_cluster_status：
集群的目前狀態(tài)，取值：PRIMARY（正常）/NON_PRIMARY（不一致）。
root@[(none)]> show status like '%wsrep_cluster_status';
+----------------------+---------+
| Variable_name        | Value   |
+----------------------+---------+
| wsrep_cluster_status | Primary |
+----------------------+---------+
18、wsrep_connected：
節(jié)點(diǎn)是否連接到集群，取值：ON/OFF。
root@[(none)]> show status like 'wsrep_connected';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| wsrep_connected | ON    |
+-----------------+-------+

19、wsrep_local_index：
節(jié)點(diǎn)id，取值從0開(kāi)始。This node index in the cluster (base 0).
root@[(none)]> show status like 'wsrep_local_index';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| wsrep_local_index | 0     |
+-------------------+-------+

20、wsrep_ready：
節(jié)點(diǎn)是否接收查詢，即節(jié)點(diǎn)是否可正常使用。
root@[(none)]> show status like '%wsrep_ready%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wsrep_ready   | ON    |
+---------------+-------+

以上是“MySQL中Galera cluster集群常用參數(shù)有哪些”這篇文章的所有內(nèi)容，感謝各位的閱讀！希望分享的內(nèi)容對(duì)大家有幫助，更多相關(guān)知識(shí)，歡迎關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道！

當(dāng)前標(biāo)題：MySQL中Galeracluster集群常用參數(shù)有哪些
文章來(lái)源：http://jinyejixie.com/article28/gggejp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供云服務(wù)器、企業(yè)網(wǎng)站制作、自適應(yīng)網(wǎng)站、網(wǎng)站收錄、網(wǎng)站營(yíng)銷、網(wǎng)頁(yè)設(shè)計(jì)公司

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)