25.4.3.9 MySQL Server Options and Variables for NDB Cluster (original) (raw)

This section provides detailed information about MySQL server status variables that relate to NDB Cluster and theNDB storage engine. For status variables not specific to NDB Cluster, and for general information on using status variables, seeSection 7.1.10, “Server Status Variables”.

• Handler_discover
  The MySQL server can ask theNDBCLUSTER storage engine if it knows about a table with a given name. This is called discovery. Handler_discover indicates the number of times that tables have been discovered using this mechanism.
• Ndb_api_adaptive_send_deferred_count
  Number of adaptive send calls that were not actually sent.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_adaptive_send_deferred_count_session
  Number of adaptive send calls that were not actually sent.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_adaptive_send_deferred_count_replica
  Number of adaptive send calls that were not actually sent by this replica.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_adaptive_send_deferred_count_slave
  Deprecated synonym forNdb_api_adaptive_send_deferred_count_replica.
• Ndb_api_adaptive_send_forced_count
  Number of adaptive send calls using forced-send sent by this MySQL Server (SQL node).
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_adaptive_send_forced_count_session
  Number of adaptive send calls using forced-send sent in this client session.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_adaptive_send_forced_count_replica
  Number of adaptive send calls using forced-send sent by this replica.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_adaptive_send_forced_count_slave
  Deprecated synonym forNdb_api_adaptive_send_forced_count_replica.
• Ndb_api_adaptive_send_unforced_count
  Number of adaptive send calls without forced-send sent by this MySQL server (SQL node).
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_adaptive_send_unforced_count_session
  Number of adaptive send calls without forced-send sent in this client session.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_adaptive_send_unforced_count_replica
  Number of adaptive send calls without forced-send sent by this replica.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_adaptive_send_unforced_count_slave
  Deprecated synonym forNdb_api_adaptive_send_unforced_count_replica.
• Ndb_api_bytes_sent_count_session
  Amount of data (in bytes) sent to the data nodes in this client session.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it relates to the current session only, and is not affected by any other clients of thismysqld.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_bytes_sent_count_replica
  Amount of data (in bytes) sent to the data nodes by this replica.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_bytes_sent_count_slave
  Deprecated synonym forNdb_api_bytes_sent_count_replica.
• Ndb_api_bytes_sent_count
  Amount of data (in bytes) sent to the data nodes by this MySQL Server (SQL node).
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_bytes_received_count_session
  Amount of data (in bytes) received from the data nodes in this client session.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it relates to the current session only, and is not affected by any other clients of thismysqld.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_bytes_received_count_replica
  Amount of data (in bytes) received from the data nodes by this replica.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_bytes_received_count_slave
  Deprecated synonym forNdb_api_bytes_received_count_replica.
• Ndb_api_bytes_received_count
  Amount of data (in bytes) received from the data nodes by this MySQL Server (SQL node).
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_event_data_count_injector
  The number of row change events received by the NDB binlog injector thread.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_event_data_count
  The number of row change events received by this MySQL Server (SQL node).
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_event_nondata_count_injector
  The number of events received, other than row change events, by the NDB binary log injector thread.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_event_nondata_count
  The number of events received, other than row change events, by this MySQL Server (SQL node).
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_event_bytes_count_injector
  The number of bytes of events received by the NDB binlog injector thread.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_event_bytes_count
  The number of bytes of events received by this MySQL Server (SQL node).
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_pk_op_count_session
  The number of operations in this client session based on or using primary keys. This includes operations on blob tables, implicit unlock operations, and auto-increment operations, as well as user-visible primary key operations.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it relates to the current session only, and is not affected by any other clients of thismysqld.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_pk_op_count_replica
  The number of operations by this replica based on or using primary keys. This includes operations on blob tables, implicit unlock operations, and auto-increment operations, as well as user-visible primary key operations.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_pk_op_count_slave
  Deprecated synonym forNdb_api_pk_op_count_replica.
• Ndb_api_pk_op_count
  The number of operations by this MySQL Server (SQL node) based on or using primary keys. This includes operations on blob tables, implicit unlock operations, and auto-increment operations, as well as user-visible primary key operations.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_pruned_scan_count_session
  The number of scans in this client session that have been pruned to a single partition.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it relates to the current session only, and is not affected by any other clients of thismysqld.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_pruned_scan_count_replica
  The number of scans by this replica that have been pruned to a single partition.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_pruned_scan_count_slave
  Deprecated synonym forNdb_api_pruned_scan_count_replica.
• Ndb_api_pruned_scan_count
  The number of scans by this MySQL Server (SQL node) that have been pruned to a single partition.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_range_scan_count_session
  The number of range scans that have been started in this client session.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it relates to the current session only, and is not affected by any other clients of thismysqld.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_range_scan_count_replica
  The number of range scans that have been started by this replica.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_range_scan_count_slave
  Deprecated synonym forNdb_api_range_scan_count_replica.
• Ndb_api_range_scan_count
  The number of range scans that have been started by this MySQL Server (SQL node).
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_read_row_count_session
  The total number of rows that have been read in this client session. This includes all rows read by any primary key, unique key, or scan operation made in this client session.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it relates to the current session only, and is not affected by any other clients of thismysqld.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_read_row_count_replica
  The total number of rows that have been read by this replica. This includes all rows read by any primary key, unique key, or scan operation made by this replica.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_read_row_count_slave
  Deprecated synonym forNdb_api_read_row_count_replica.
• Ndb_api_read_row_count
  The total number of rows that have been read by this MySQL Server (SQL node). This includes all rows read by any primary key, unique key, or scan operation made by this MySQL Server (SQL node).
  You should be aware that this value may not be completely accurate with regard to rows read bySELECT COUNT(*) queries, due to the fact that, in this case, the MySQL server actually reads pseudo-rows in the form [_`table fragment ID`_]:[_`number of rows in fragment`_] and sums the rows per fragment for all fragments in the table to derive an estimated count for all rows. Ndb_api_read_row_count uses this estimate and not the actual number of rows in the table.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_scan_batch_count_session
  The number of batches of rows received in this client session. 1 batch is defined as 1 set of scan results from a single fragment.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it relates to the current session only, and is not affected by any other clients of thismysqld.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_scan_batch_count_replica
  The number of batches of rows received by this replica. 1 batch is defined as 1 set of scan results from a single fragment.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_scan_batch_count_slave
  Deprecated synonym forNdb_api_scan_batch_count_replica.
• Ndb_api_scan_batch_count
  The number of batches of rows received by this MySQL Server (SQL node). 1 batch is defined as 1 set of scan results from a single fragment.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_table_scan_count_session
  The number of table scans that have been started in this client session, including scans of internal tables,.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it relates to the current session only, and is not affected by any other clients of thismysqld.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_table_scan_count_replica
  The number of table scans that have been started by this replica, including scans of internal tables.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_table_scan_count_slave
  Deprecated synonym forNdb_api_table_scan_count_replica.
• Ndb_api_table_scan_count
  The number of table scans that have been started by this MySQL Server (SQL node), including scans of internal tables,.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_trans_abort_count_session
  The number of transactions aborted in this client session.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it relates to the current session only, and is not affected by any other clients of thismysqld.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_trans_abort_count_replica
  The number of transactions aborted by this replica.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_trans_abort_count_slave
  Deprecated synonym forNdb_api_trans_abort_count_replica.
• Ndb_api_trans_abort_count
  The number of transactions aborted by this MySQL Server (SQL node).
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_trans_close_count_session
  The number of transactions closed in this client session. This value may be greater than the sum ofNdb_api_trans_commit_count_session andNdb_api_trans_abort_count_session, since some transactions may have been rolled back.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it relates to the current session only, and is not affected by any other clients of thismysqld.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_trans_close_count_replica
  The number of transactions closed by this replica. This value may be greater than the sum ofNdb_api_trans_commit_count_replica andNdb_api_trans_abort_count_replica, since some transactions may have been rolled back.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_trans_close_count_slave
  Deprecated synonym forNdb_api_trans_close_count_replica.
• Ndb_api_trans_close_count
  The number of transactions closed by this MySQL Server (SQL node). This value may be greater than the sum ofNdb_api_trans_commit_count andNdb_api_trans_abort_count, since some transactions may have been rolled back.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_trans_commit_count_session
  The number of transactions committed in this client session.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it relates to the current session only, and is not affected by any other clients of thismysqld.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_trans_commit_count_replica
  The number of transactions committed by this replica.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_trans_commit_count_slave
  Deprecated synonym forNdb_api_trans_commit_count_replica.
• Ndb_api_trans_commit_count
  The number of transactions committed by this MySQL Server (SQL node).
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_trans_local_read_row_count_session
  The total number of rows that have been read in this client session. This includes all rows read by any primary key, unique key, or scan operation made in this client session.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it relates to the current session only, and is not affected by any other clients of thismysqld.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_trans_local_read_row_count_replica
  The total number of rows that have been read by this replica. This includes all rows read by any primary key, unique key, or scan operation made by this replica.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_trans_local_read_row_count_slave
  Deprecated synonym forNdb_api_trans_local_read_row_count_replica.
• Ndb_api_trans_local_read_row_count
  The total number of rows that have been read by this MySQL Server (SQL node). This includes all rows read by any primary key, unique key, or scan operation made by this MySQL Server (SQL node).
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_trans_start_count_session
  The number of transactions started in this client session.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it relates to the current session only, and is not affected by any other clients of thismysqld.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_trans_start_count_replica
  The number of transactions started by this replica.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_trans_start_count_slave
  Deprecated synonym forNdb_api_trans_start_count_replica.
• Ndb_api_trans_start_count
  The number of transactions started by this MySQL Server (SQL node).
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_uk_op_count_session
  The number of operations in this client session based on or using unique keys.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it relates to the current session only, and is not affected by any other clients of thismysqld.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_uk_op_count_replica
  The number of operations by this replica based on or using unique keys.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_uk_op_count_slave
  Deprecated synonym forNdb_api_uk_op_count_replica.
• Ndb_api_uk_op_count
  The number of operations by this MySQL Server (SQL node) based on or using unique keys.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_wait_exec_complete_count_session
  The number of times a thread has been blocked in this client session while waiting for execution of an operation to complete. This includes allexecute() calls as well as implicit executes for blob and auto-increment operations not visible to clients.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it relates to the current session only, and is not affected by any other clients of thismysqld.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_wait_exec_complete_count_replica
  The number of times a thread has been blocked by this replica while waiting for execution of an operation to complete. This includes allexecute() calls as well as implicit executes for blob and auto-increment operations not visible to clients.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_wait_exec_complete_count_slave
  Deprecated synonym forNdb_api_wait_exec_complete_count_replica.
• Ndb_api_wait_exec_complete_count
  The number of times a thread has been blocked by this MySQL Server (SQL node) while waiting for execution of an operation to complete. This includes allexecute() calls as well as implicit executes for blob and auto-increment operations not visible to clients.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_wait_meta_request_count_session
  The number of times a thread has been blocked in this client session waiting for a metadata-based signal, such as is expected for DDL requests, new epochs, and seizure of transaction records.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it relates to the current session only, and is not affected by any other clients of thismysqld.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_wait_meta_request_count_replica
  The number of times a thread has been blocked by this replica waiting for a metadata-based signal, such as is expected for DDL requests, new epochs, and seizure of transaction records.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_wait_meta_request_count_slave
  Deprecated synonym forNdb_api_wait_meta_request_count_replica.
• Ndb_api_wait_meta_request_count
  The number of times a thread has been blocked by this MySQL Server (SQL node) waiting for a metadata-based signal, such as is expected for DDL requests, new epochs, and seizure of transaction records.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_wait_nanos_count_session
  Total time (in nanoseconds) spent in this client session waiting for any type of signal from the data nodes.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it relates to the current session only, and is not affected by any other clients of thismysqld.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_wait_nanos_count_replica
  Total time (in nanoseconds) spent by this replica waiting for any type of signal from the data nodes.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_wait_nanos_count_slave
  Deprecated synonym forNdb_api_wait_nanos_count_replica.
• Ndb_api_wait_nanos_count
  Total time (in nanoseconds) spent by this MySQL Server (SQL node) waiting for any type of signal from the data nodes.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_wait_scan_result_count_session
  The number of times a thread has been blocked in this client session while waiting for a scan-based signal, such as when waiting for more results from a scan, or when waiting for a scan to close.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it relates to the current session only, and is not affected by any other clients of thismysqld.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_wait_scan_result_count_replica
  The number of times a thread has been blocked by this replica while waiting for a scan-based signal, such as when waiting for more results from a scan, or when waiting for a scan to close.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_api_wait_scan_result_count_slave
  Deprecated synonym forNdb_api_wait_scan_result_count_replica.
• Ndb_api_wait_scan_result_count
  The number of times a thread has been blocked by this MySQL Server (SQL node) while waiting for a scan-based signal, such as when waiting for more results from a scan, or when waiting for a scan to close.
  Although this variable can be read using eitherSHOW GLOBAL STATUS orSHOW SESSION STATUS, it is effectively global in scope.
  For more information, seeSection 25.6.16, “NDB API Statistics Counters and Variables”.
• Ndb_cluster_node_id
  If the server is acting as an NDB Cluster node, then the value of this variable its node ID in the cluster.
  If the server is not part of an NDB Cluster, then the value of this variable is 0.
• Ndb_config_from_host
  If the server is part of an NDB Cluster, the value of this variable is the host name or IP address of the Cluster management server from which it gets its configuration data.
  If the server is not part of an NDB Cluster, then the value of this variable is an empty string.
• Ndb_config_from_port
  If the server is part of an NDB Cluster, the value of this variable is the number of the port through which it is connected to the Cluster management server from which it gets its configuration data.
  If the server is not part of an NDB Cluster, then the value of this variable is 0.
• Ndb_config_generation
  Shows the generation number of the cluster's current configuration. This can be used as an indicator to determine whether the configuration of the cluster has changed since this SQL node last connected to the cluster.
• Ndb_conflict_fn_epoch
  Used in NDB Cluster Replication conflict resolution, this variable shows the number of rows found to be in conflict using NDB$EPOCH() conflict resolution on a given mysqld since the last time it was restarted.
  For more information, seeSection 25.7.12, “NDB Cluster Replication Conflict Resolution”.
• Ndb_conflict_fn_epoch_trans
  Used in NDB Cluster Replication conflict resolution, this variable shows the number of rows found to be in conflict using NDB$EPOCH_TRANS() conflict resolution on a given mysqld since the last time it was restarted.
  For more information, seeSection 25.7.12, “NDB Cluster Replication Conflict Resolution”.
• Ndb_conflict_fn_epoch2
  Shows the number of rows found to be in conflict in NDB Cluster Replication conflict resolution, when usingNDB$EPOCH2(), on the source designated as the primary since the last time it was restarted.
  For more information, seeNDB$EPOCH2().
• Ndb_conflict_fn_epoch2_trans
  Used in NDB Cluster Replication conflict resolution, this variable shows the number of rows found to be in conflict using NDB$EPOCH_TRANS2() conflict resolution on a given mysqld since the last time it was restarted.
  For more information, seeNDB$EPOCH2_TRANS().
• Ndb_conflict_fn_max
  Used in NDB Cluster Replication conflict resolution, this variable shows the number of times that a row was not applied on the current SQL node due to “greatest timestamp wins” conflict resolution since the last time that thismysqld was started.
  For more information, seeSection 25.7.12, “NDB Cluster Replication Conflict Resolution”.
• Ndb_conflict_fn_max_del_win
  Shows the number of times that a row was rejected on the current SQL node due to NDB Cluster Replication conflict resolution using NDB$MAX_DELETE_WIN(), since the last time that this mysqld was started.
  For more information, seeSection 25.7.12, “NDB Cluster Replication Conflict Resolution”.
• Ndb_conflict_fn_max_del_win_ins
  Shows the number of times that insertion of a row was rejected on the current SQL node due to NDB Cluster Replication conflict resolution usingNDB$MAX_DEL_WIN_INS(), since the last time that this mysqld was started.
  For more information, seeSection 25.7.12, “NDB Cluster Replication Conflict Resolution”.
• Ndb_conflict_fn_max_ins
  Used in NDB Cluster Replication conflict resolution, this variable shows the number of times that a row was not inserted on the current SQL node due to “greatest timestamp wins” conflict resolution since the last time that thismysqld was started.
  For more information, seeSection 25.7.12, “NDB Cluster Replication Conflict Resolution”.
• Ndb_conflict_fn_old
  Used in NDB Cluster Replication conflict resolution, this variable shows the number of times that a row was not applied as the result of “same timestamp wins” conflict resolution on a given mysqld since the last time it was restarted.
  For more information, seeSection 25.7.12, “NDB Cluster Replication Conflict Resolution”.
• Ndb_conflict_last_conflict_epoch
  The most recent epoch in which a conflict was detected on this replica. You can compare this value withNdb_replica_max_replicated_epoch; if Ndb_replica_max_replicated_epoch is greater thanNdb_conflict_last_conflict_epoch, no conflicts have yet been detected.
  SeeSection 25.7.12, “NDB Cluster Replication Conflict Resolution”, for more information.
• Ndb_conflict_reflected_op_discard_count
  When using NDB Cluster Replication conflict resolution, this is the number of reflected operations that were not applied on the secondary, due to encountering an error during execution.
  SeeSection 25.7.12, “NDB Cluster Replication Conflict Resolution”, for more information.
• Ndb_conflict_reflected_op_prepare_count
  When using conflict resolution with NDB Cluster Replication, this status variable contains the number of reflected operations that have been defined (that is, prepared for execution on the secondary).
  SeeSection 25.7.12, “NDB Cluster Replication Conflict Resolution”.
• Ndb_conflict_refresh_op_count
  When using conflict resolution with NDB Cluster Replication, this gives the number of refresh operations that have been prepared for execution on the secondary.
  SeeSection 25.7.12, “NDB Cluster Replication Conflict Resolution”, for more information.
• Ndb_conflict_last_stable_epoch
  Number of rows found to be in conflict by a transactional conflict function
  SeeSection 25.7.12, “NDB Cluster Replication Conflict Resolution”, for more information.
• Ndb_conflict_trans_row_conflict_count
  Used in NDB Cluster Replication conflict resolution, this status variable shows the number of rows found to be directly in-conflict by a transactional conflict function on a givenmysqld since the last time it was restarted.
  Currently, the only transactional conflict detection function supported by NDB Cluster is NDB$EPOCH_TRANS(), so this status variable is effectively the same asNdb_conflict_fn_epoch_trans.
  For more information, seeSection 25.7.12, “NDB Cluster Replication Conflict Resolution”.
• Ndb_conflict_trans_row_reject_count
  Used in NDB Cluster Replication conflict resolution, this status variable shows the total number of rows realigned due to being determined as conflicting by a transactional conflict detection function. This includes not onlyNdb_conflict_trans_row_conflict_count, but any rows in or dependent on conflicting transactions.
  For more information, seeSection 25.7.12, “NDB Cluster Replication Conflict Resolution”.
• Ndb_conflict_trans_reject_count
  Used in NDB Cluster Replication conflict resolution, this status variable shows the number of transactions found to be in conflict by a transactional conflict detection function.
  For more information, seeSection 25.7.12, “NDB Cluster Replication Conflict Resolution”.
• Ndb_conflict_trans_detect_iter_count
  Used in NDB Cluster Replication conflict resolution, this shows the number of internal iterations required to commit an epoch transaction. Should be (slightly) greater than or equal toNdb_conflict_trans_conflict_commit_count.
  For more information, seeSection 25.7.12, “NDB Cluster Replication Conflict Resolution”.
• Ndb_conflict_trans_conflict_commit_count
  Used in NDB Cluster Replication conflict resolution, this shows the number of epoch transactions committed after they required transactional conflict handling.
  For more information, seeSection 25.7.12, “NDB Cluster Replication Conflict Resolution”.
• Ndb_epoch_delete_delete_count
  When using delete-delete conflict detection, this is the number of delete-delete conflicts detected, where a delete operation is applied, but the indicated row does not exist.
• Ndb_execute_count
  Provides the number of round trips to theNDB kernel made by operations.
• Ndb_fetch_table_stats
  This count is incremented whenever a MySQL Server acting as an NDB CLuster API node fetches table statistics for a given table, rather than using cached statistics.
• Ndb_last_commit_epoch_server
  The epoch most recently committed by NDB.
• Ndb_last_commit_epoch_session
  The epoch most recently committed by thisNDB client.
• Ndb_metadata_detected_count
  The number of times since this server was last started that the NDB metadata change detection thread has discovered changes with respect to the MySQL data dictionary.
• Ndb_metadata_excluded_count
  The number of metadata objects that the NDB binlog thread has been unable to synchronize on this SQL node since it was last restarted.
  Should an object be excluded, it is not again considered for automatic synchronization until the user corrects the mismatch manually. This can be done by attempting to use the table with a statement such as SHOW CREATE TABLE_`table`_, SELECT * FROM _`table`_, or any other statement that would trigger table discovery.
• Ndb_metadata_synced_count
  The number of NDB metadata objects which have been synchronized on this SQL node since it was last restarted.
• Ndb_number_of_data_nodes
  If the server is part of an NDB Cluster, the value of this variable is the number of data nodes in the cluster.
  If the server is not part of an NDB Cluster, then the value of this variable is 0.
• Ndb_pushed_queries_defined
  The total number of joins pushed down to the NDB kernel for distributed handling on the data nodes.
  Note
  Joins tested using EXPLAIN that can be pushed down contribute to this number.
• Ndb_pushed_queries_dropped
  The number of joins that were pushed down to the NDB kernel but that could not be handled there.
• Ndb_pushed_queries_executed
  The number of joins successfully pushed down toNDB and executed there.
• Ndb_pushed_reads
  The number of rows returned to mysqld from the NDB kernel by joins that were pushed down.
  Note
  Executing EXPLAIN on joins that can be pushed down to NDB does not add to this number.
• Ndb_pruned_scan_count
  This variable holds a count of the number of scans executed byNDBCLUSTER since the NDB Cluster was last started where NDBCLUSTER was able to use partition pruning.
  Using this variable together withNdb_scan_count can be helpful in schema design to maximize the ability of the server to prune scans to a single table partition, thereby involving replica only a single data node.
• Ndb_replica_max_replicated_epoch
  The most recently committed epoch on this replica. You can compare this value withNdb_conflict_last_conflict_epoch; if Ndb_replica_max_replicated_epoch is the greater of the two, no conflicts have yet been detected.
  For more information, seeSection 25.7.12, “NDB Cluster Replication Conflict Resolution”.
• Ndb_scan_count
  This variable holds a count of the total number of scans executed by NDBCLUSTER since the NDB Cluster was last started.
• Ndb_schema_participant_count
  Indicates the number of MySQL servers that are participating in NDB schema change distribution.
  Added in NDB 8.4.5.
• Ndb_slave_max_replicated_epoch
  Deprecated synonym forNdb_replica_max_replicated_epoch.
• Ndb_system_name
  If this MySQL Server is connected to an NDB cluster, this read-only variable shows the cluster system name. Otherwise, the value is an empty string.
• Ndb_trans_hint_count_session
  The number of transactions using hints that have been started in the current session. Compare withNdb_api_trans_start_count_session to obtain the proportion of all NDB transactions able to use hints.