Percona XtraDB Cluster - HA scalable solution for MySQL

FLUSH STATUS zeroes up wsrep_cluster_size and wsrep_local_index

Reported by Alex Yurchenko on 2013-09-29
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Status tracked in 5.6
5.5
Medium
Vladislav Klyachin
5.6
Medium
Vladislav Klyachin
Percona XtraDB Cluster
Status tracked in Trunk
5.6
Undecided
Unassigned
Trunk
Undecided
Unassigned

Bug Description

This is likely because wsrep_cluster_size and wsrep_local_index reside in mysqld unlike the rest of status variables.

Before FLUSH STATUS:

+----------------------------+-------------------------------------------------+
| Variable_name | Value |
+----------------------------+-------------------------------------------------+
| wsrep_local_state_uuid | b88da040-2721-11e3-a23c-ea75bf4d1b2a |
| wsrep_protocol_version | 5 |
| wsrep_last_committed | 0 |
| wsrep_replicated | 0 |
| wsrep_replicated_bytes | 0 |
| wsrep_repl_keys | 0 |
| wsrep_repl_keys_bytes | 0 |
| wsrep_repl_data_bytes | 0 |
| wsrep_repl_other_bytes | 0 |
| wsrep_received | 7 |
| wsrep_received_bytes | 1008 |
| wsrep_local_commits | 0 |
| wsrep_local_cert_failures | 0 |
| wsrep_local_replays | 0 |
| wsrep_local_send_queue | 0 |
| wsrep_local_send_queue_avg | 0.000000 |
| wsrep_local_recv_queue | 0 |
| wsrep_local_recv_queue_avg | 0.250000 |
| wsrep_flow_control_paused | 0.000000 |
| wsrep_flow_control_sent | 0 |
| wsrep_flow_control_recv | 0 |
| wsrep_cert_deps_distance | 0.000000 |
| wsrep_apply_oooe | 0.000000 |
| wsrep_apply_oool | 0.000000 |
| wsrep_apply_window | 0.000000 |
| wsrep_commit_oooe | 0.000000 |
| wsrep_commit_oool | 0.000000 |
| wsrep_commit_window | 0.000000 |
| wsrep_local_state | 4 |
| wsrep_local_state_comment | Synced |
| wsrep_cert_index_size | 0 |
| wsrep_causal_reads | 0 |
| wsrep_incoming_addresses | 10.21.32.1:3305,10.21.32.1:3303,10.21.32.1:3304 |
| wsrep_cluster_conf_id | 4 |
| wsrep_cluster_size | 3 |
| wsrep_cluster_state_uuid | b88da040-2721-11e3-a23c-ea75bf4d1b2a |
| wsrep_cluster_status | Primary |
| wsrep_connected | ON |
| wsrep_local_index | 1 |
| wsrep_provider_name | Galera |
| wsrep_provider_vendor | Codership Oy <email address hidden> |
| wsrep_provider_version | 3.1dev(r1978) |
| wsrep_ready | ON |
+----------------------------+-------------------------------------------------+
43 rows in set (0.00 sec)

mysql> flush status;
Query OK, 0 rows affected (0.01 sec)

mysql> show status like 'wsrep%';
+----------------------------+-------------------------------------------------+
| Variable_name | Value |
+----------------------------+-------------------------------------------------+
| wsrep_local_state_uuid | b88da040-2721-11e3-a23c-ea75bf4d1b2a |
| wsrep_protocol_version | 5 |
| wsrep_last_committed | 0 |
| wsrep_replicated | 0 |
| wsrep_replicated_bytes | 0 |
| wsrep_repl_keys | 0 |
| wsrep_repl_keys_bytes | 0 |
| wsrep_repl_data_bytes | 0 |
| wsrep_repl_other_bytes | 0 |
| wsrep_received | 7 |
| wsrep_received_bytes | 1008 |
| wsrep_local_commits | 0 |
| wsrep_local_cert_failures | 0 |
| wsrep_local_replays | 0 |
| wsrep_local_send_queue | 0 |
| wsrep_local_send_queue_avg | 0.000000 |
| wsrep_local_recv_queue | 0 |
| wsrep_local_recv_queue_avg | 0.000000 |
| wsrep_flow_control_paused | 0.000000 |
| wsrep_flow_control_sent | 0 |
| wsrep_flow_control_recv | 0 |
| wsrep_cert_deps_distance | 0.000000 |
| wsrep_apply_oooe | 0.000000 |
| wsrep_apply_oool | 0.000000 |
| wsrep_apply_window | 0.000000 |
| wsrep_commit_oooe | 0.000000 |
| wsrep_commit_oool | 0.000000 |
| wsrep_commit_window | 0.000000 |
| wsrep_local_state | 4 |
| wsrep_local_state_comment | Synced |
| wsrep_cert_index_size | 0 |
| wsrep_causal_reads | 0 |
| wsrep_incoming_addresses | 10.21.32.1:3305,10.21.32.1:3303,10.21.32.1:3304 |
| wsrep_cluster_conf_id | 4 |
| wsrep_cluster_size | 0 |
| wsrep_cluster_state_uuid | b88da040-2721-11e3-a23c-ea75bf4d1b2a |
| wsrep_cluster_status | Primary |
| wsrep_connected | ON |
| wsrep_local_index | 0 |
| wsrep_provider_name | Galera |
| wsrep_provider_vendor | Codership Oy <email address hidden> |
| wsrep_provider_version | 3.1dev(r1978) |
| wsrep_ready | ON |
+----------------------------+-------------------------------------------------+
43 rows in set (0.01 sec)

This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers