<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="mysql-cluster-ndb-api-statistics">
      </a>
      25.6.16 NDB API Statistics Counters and Variables
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045091110544">
  </a>
  <a class="indexterm" name="idm46045091109056">
  </a>
  <a class="indexterm" name="idm46045091108016">
  </a>
  <p>
   A number of types of statistical counters relating to actions
      performed by or affecting
   <a class="ulink" href="/doc/ndbapi/en/ndb-ndb.html" target="_top">
    <code class="literal">
     Ndb
    </code>
   </a>
   objects are available. Such actions include starting and closing
      (or aborting) transactions; primary key and unique key operations;
      table, range, and pruned scans; threads blocked while waiting for
      the completion of various operations; and data and events sent and
      received by
   <code class="literal">
    NDBCLUSTER
   </code>
   . The counters are
      incremented inside the NDB kernel whenever NDB API calls are made
      or data is sent to or received by the data nodes.
   <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
    <span class="command">
     <strong>
      mysqld
     </strong>
    </span>
   </a>
   exposes these counters as system status
      variables; their values can be read in the output of
   <a class="link" href="show-status.html" title="15.7.7.37 SHOW STATUS Statement">
    <code class="literal">
     SHOW STATUS
    </code>
   </a>
   , or by querying the
      Performance Schema
   <a class="link" href="performance-schema-status-variable-tables.html" title="29.12.15 Performance Schema Status Variable Tables">
    <code class="literal">
     session_status
    </code>
   </a>
   or
   <a class="link" href="performance-schema-status-variable-tables.html" title="29.12.15 Performance Schema Status Variable Tables">
    <code class="literal">
     global_status
    </code>
   </a>
   table. By comparing the
      values before and after statements operating on
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   tables, you can observe the
      corresponding actions taken on the API level, and thus the cost of
      performing the statement.
  </p>
  <p>
   You can list all of these status variables using the following
   <a class="link" href="show-status.html" title="15.7.7.37 SHOW STATUS Statement">
    <code class="literal">
     SHOW STATUS
    </code>
   </a>
   statement:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa10467556"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">STATUS</span> <span class="token operator">LIKE</span> <span class="token string">'ndb_api%'</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Variable_name                                <span class="token punctuation">|</span> Value       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_exec_complete_count             <span class="token punctuation">|</span> 11          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_scan_result_count               <span class="token punctuation">|</span> 14          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_meta_request_count              <span class="token punctuation">|</span> 74          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_nanos_count                     <span class="token punctuation">|</span> 31453031678 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_sent_count                     <span class="token punctuation">|</span> 3336        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_received_count                 <span class="token punctuation">|</span> 103568      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_start_count                    <span class="token punctuation">|</span> 10          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count                   <span class="token punctuation">|</span> 2           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_abort_count                    <span class="token punctuation">|</span> 4           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_close_count                    <span class="token punctuation">|</span> 10          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pk_op_count                          <span class="token punctuation">|</span> 6           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_uk_op_count                          <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_table_scan_count                     <span class="token punctuation">|</span> 3           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_range_scan_count                     <span class="token punctuation">|</span> 1           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pruned_scan_count                    <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_scan_batch_count                     <span class="token punctuation">|</span> 3           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_read_row_count                       <span class="token punctuation">|</span> 11          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_local_read_row_count           <span class="token punctuation">|</span> 9           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_forced_count           <span class="token punctuation">|</span> 5           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_unforced_count         <span class="token punctuation">|</span> 11          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_deferred_count         <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_data_count                     <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_nondata_count                  <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_bytes_count                    <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_data_count_injector            <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_nondata_count_injector         <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_bytes_count_injector           <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_exec_complete_count_slave       <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_scan_result_count_slave         <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_meta_request_count_slave        <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_nanos_count_slave               <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_sent_count_slave               <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_received_count_slave           <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_start_count_slave              <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count_slave             <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_abort_count_slave              <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_close_count_slave              <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pk_op_count_slave                    <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_uk_op_count_slave                    <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_table_scan_count_slave               <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_range_scan_count_slave               <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pruned_scan_count_slave              <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_scan_batch_count_slave               <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_read_row_count_slave                 <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_local_read_row_count_slave     <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_forced_count_slave     <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_unforced_count_slave   <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_deferred_count_slave   <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_exec_complete_count_replica     <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_scan_result_count_replica       <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_meta_request_count_replica      <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_nanos_count_replica             <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_sent_count_replica             <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_received_count_replica         <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_start_count_replica            <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count_replica           <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_abort_count_replica            <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_close_count_replica            <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pk_op_count_replica                  <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_uk_op_count_replica                  <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_table_scan_count_replica             <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_range_scan_count_replica             <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pruned_scan_count_replica            <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_scan_batch_count_replica             <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_read_row_count_replica               <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_local_read_row_count_replica   <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_forced_count_replica   <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_unforced_count_replica <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_deferred_count_replica <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_exec_complete_count_session     <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_scan_result_count_session       <span class="token punctuation">|</span> 3           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_meta_request_count_session      <span class="token punctuation">|</span> 6           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_nanos_count_session             <span class="token punctuation">|</span> 2022486     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_sent_count_session             <span class="token punctuation">|</span> 268         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_received_count_session         <span class="token punctuation">|</span> 10332       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_start_count_session            <span class="token punctuation">|</span> 1           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count_session           <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_abort_count_session            <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_close_count_session            <span class="token punctuation">|</span> 1           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pk_op_count_session                  <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_uk_op_count_session                  <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_table_scan_count_session             <span class="token punctuation">|</span> 1           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_range_scan_count_session             <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pruned_scan_count_session            <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_scan_batch_count_session             <span class="token punctuation">|</span> 2           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_read_row_count_session               <span class="token punctuation">|</span> 2           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_local_read_row_count_session   <span class="token punctuation">|</span> 2           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_forced_count_session   <span class="token punctuation">|</span> 1           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_unforced_count_session <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_deferred_count_session <span class="token punctuation">|</span> 0           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output">90 rows in set (0.00 sec)</span></code></pre>
  </div>
  <p>
   These status variables are also available from the Performance
      Schema
   <a class="link" href="performance-schema-status-variable-tables.html" title="29.12.15 Performance Schema Status Variable Tables">
    <code class="literal">
     session_status
    </code>
   </a>
   and
   <a class="link" href="performance-schema-status-variable-tables.html" title="29.12.15 Performance Schema Status Variable Tables">
    <code class="literal">
     global_status
    </code>
   </a>
   tables, as shown here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa86049965"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> performance_schema<span class="token punctuation">.</span>session_status
<span class="token prompt">    -&gt;</span>   <span class="token keyword">WHERE</span> VARIABLE_NAME <span class="token operator">LIKE</span> <span class="token string">'ndb_api%'</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> VARIABLE_NAME                                <span class="token punctuation">|</span> VARIABLE_VALUE <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_exec_complete_count             <span class="token punctuation">|</span> 11             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_scan_result_count               <span class="token punctuation">|</span> 14             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_meta_request_count              <span class="token punctuation">|</span> 81             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_nanos_count                     <span class="token punctuation">|</span> 119485762051   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_sent_count                     <span class="token punctuation">|</span> 3476           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_received_count                 <span class="token punctuation">|</span> 105372         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_start_count                    <span class="token punctuation">|</span> 10             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count                   <span class="token punctuation">|</span> 2              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_abort_count                    <span class="token punctuation">|</span> 4              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_close_count                    <span class="token punctuation">|</span> 10             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pk_op_count                          <span class="token punctuation">|</span> 6              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_uk_op_count                          <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_table_scan_count                     <span class="token punctuation">|</span> 3              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_range_scan_count                     <span class="token punctuation">|</span> 1              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pruned_scan_count                    <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_scan_batch_count                     <span class="token punctuation">|</span> 3              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_read_row_count                       <span class="token punctuation">|</span> 11             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_local_read_row_count           <span class="token punctuation">|</span> 9              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_forced_count           <span class="token punctuation">|</span> 5              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_unforced_count         <span class="token punctuation">|</span> 11             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_deferred_count         <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_data_count                     <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_nondata_count                  <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_bytes_count                    <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_data_count_injector            <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_nondata_count_injector         <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_bytes_count_injector           <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_exec_complete_count_slave       <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_scan_result_count_slave         <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_meta_request_count_slave        <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_nanos_count_slave               <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_sent_count_slave               <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_received_count_slave           <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_start_count_slave              <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count_slave             <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_abort_count_slave              <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_close_count_slave              <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pk_op_count_slave                    <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_uk_op_count_slave                    <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_table_scan_count_slave               <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_range_scan_count_slave               <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pruned_scan_count_slave              <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_scan_batch_count_slave               <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_read_row_count_slave                 <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_local_read_row_count_slave     <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_forced_count_slave     <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_unforced_count_slave   <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_deferred_count_slave   <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_exec_complete_count_replica     <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_scan_result_count_replica       <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_meta_request_count_replica      <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_nanos_count_replica             <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_sent_count_replica             <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_received_count_replica         <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_start_count_replica            <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count_replica           <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_abort_count_replica            <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_close_count_replica            <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pk_op_count_replica                  <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_uk_op_count_replica                  <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_table_scan_count_replica             <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_range_scan_count_replica             <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pruned_scan_count_replica            <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_scan_batch_count_replica             <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_read_row_count_replica               <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_local_read_row_count_replica   <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_forced_count_replica   <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_unforced_count_replica <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_deferred_count_replica <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_exec_complete_count_session     <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_scan_result_count_session       <span class="token punctuation">|</span> 3              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_meta_request_count_session      <span class="token punctuation">|</span> 6              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_nanos_count_session             <span class="token punctuation">|</span> 2022486        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_sent_count_session             <span class="token punctuation">|</span> 268            <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_received_count_session         <span class="token punctuation">|</span> 10332          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_start_count_session            <span class="token punctuation">|</span> 1              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count_session           <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_abort_count_session            <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_close_count_session            <span class="token punctuation">|</span> 1              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pk_op_count_session                  <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_uk_op_count_session                  <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_table_scan_count_session             <span class="token punctuation">|</span> 1              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_range_scan_count_session             <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pruned_scan_count_session            <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_scan_batch_count_session             <span class="token punctuation">|</span> 2              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_read_row_count_session               <span class="token punctuation">|</span> 2              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_local_read_row_count_session   <span class="token punctuation">|</span> 2              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_forced_count_session   <span class="token punctuation">|</span> 1              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_unforced_count_session <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_deferred_count_session <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output">90 rows in set (0.00 sec)</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> performance_schema<span class="token punctuation">.</span>global_status
<span class="token prompt">    -&gt;</span>     <span class="token keyword">WHERE</span> VARIABLE_NAME <span class="token operator">LIKE</span> <span class="token string">'ndb_api%'</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> VARIABLE_NAME                                <span class="token punctuation">|</span> VARIABLE_VALUE <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_exec_complete_count             <span class="token punctuation">|</span> 11             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_scan_result_count               <span class="token punctuation">|</span> 14             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_meta_request_count              <span class="token punctuation">|</span> 88             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_nanos_count                     <span class="token punctuation">|</span> 159810484729   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_sent_count                     <span class="token punctuation">|</span> 3616           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_received_count                 <span class="token punctuation">|</span> 107176         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_start_count                    <span class="token punctuation">|</span> 10             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count                   <span class="token punctuation">|</span> 2              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_abort_count                    <span class="token punctuation">|</span> 4              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_close_count                    <span class="token punctuation">|</span> 10             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pk_op_count                          <span class="token punctuation">|</span> 6              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_uk_op_count                          <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_table_scan_count                     <span class="token punctuation">|</span> 3              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_range_scan_count                     <span class="token punctuation">|</span> 1              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pruned_scan_count                    <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_scan_batch_count                     <span class="token punctuation">|</span> 3              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_read_row_count                       <span class="token punctuation">|</span> 11             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_local_read_row_count           <span class="token punctuation">|</span> 9              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_forced_count           <span class="token punctuation">|</span> 5              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_unforced_count         <span class="token punctuation">|</span> 11             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_deferred_count         <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_data_count                     <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_nondata_count                  <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_bytes_count                    <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_data_count_injector            <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_nondata_count_injector         <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_bytes_count_injector           <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_exec_complete_count_slave       <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_scan_result_count_slave         <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_meta_request_count_slave        <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_nanos_count_slave               <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_sent_count_slave               <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_received_count_slave           <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_start_count_slave              <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count_slave             <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_abort_count_slave              <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_close_count_slave              <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pk_op_count_slave                    <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_uk_op_count_slave                    <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_table_scan_count_slave               <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_range_scan_count_slave               <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pruned_scan_count_slave              <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_scan_batch_count_slave               <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_read_row_count_slave                 <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_local_read_row_count_slave     <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_forced_count_slave     <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_unforced_count_slave   <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_deferred_count_slave   <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_exec_complete_count_replica     <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_scan_result_count_replica       <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_meta_request_count_replica      <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_nanos_count_replica             <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_sent_count_replica             <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_received_count_replica         <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_start_count_replica            <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count_replica           <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_abort_count_replica            <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_close_count_replica            <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pk_op_count_replica                  <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_uk_op_count_replica                  <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_table_scan_count_replica             <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_range_scan_count_replica             <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pruned_scan_count_replica            <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_scan_batch_count_replica             <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_read_row_count_replica               <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_local_read_row_count_replica   <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_forced_count_replica   <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_unforced_count_replica <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_deferred_count_replica <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_exec_complete_count_session     <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_scan_result_count_session       <span class="token punctuation">|</span> 3              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_meta_request_count_session      <span class="token punctuation">|</span> 6              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_nanos_count_session             <span class="token punctuation">|</span> 2022486        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_sent_count_session             <span class="token punctuation">|</span> 268            <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_received_count_session         <span class="token punctuation">|</span> 10332          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_start_count_session            <span class="token punctuation">|</span> 1              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count_session           <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_abort_count_session            <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_close_count_session            <span class="token punctuation">|</span> 1              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pk_op_count_session                  <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_uk_op_count_session                  <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_table_scan_count_session             <span class="token punctuation">|</span> 1              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_range_scan_count_session             <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pruned_scan_count_session            <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_scan_batch_count_session             <span class="token punctuation">|</span> 2              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_read_row_count_session               <span class="token punctuation">|</span> 2              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_local_read_row_count_session   <span class="token punctuation">|</span> 2              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_forced_count_session   <span class="token punctuation">|</span> 1              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_unforced_count_session <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_deferred_count_session <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output">90 rows in set (0.01 sec)</span></code></pre>
  </div>
  <a class="indexterm" name="idm46045091052368">
  </a>
  <a class="indexterm" name="idm46045091050864">
  </a>
  <p>
   Each
   <a class="ulink" href="/doc/ndbapi/en/ndb-ndb.html" target="_top">
    <code class="literal">
     Ndb
    </code>
   </a>
   object has its own
      counters. NDB API applications can read the values of the counters
      for use in optimization or monitoring. For multithreaded clients
      which use more than one
   <a class="ulink" href="/doc/ndbapi/en/ndb-ndb.html" target="_top">
    <code class="literal">
     Ndb
    </code>
   </a>
   object concurrently, it is also possible to obtain a summed view
      of counters from all
   <a class="ulink" href="/doc/ndbapi/en/ndb-ndb.html" target="_top">
    <code class="literal">
     Ndb
    </code>
   </a>
   objects
      belonging to a given
   <a class="ulink" href="/doc/ndbapi/en/ndb-ndb-cluster-connection.html" target="_top">
    <code class="literal">
     Ndb_cluster_connection
    </code>
   </a>
   .
  </p>
  <p>
   Four sets of these counters are exposed. One set applies to the
      current session only; the other 3 are global.
   <span class="emphasis">
    <em>
     This is in
      spite of the fact that their values can be obtained as either
      session or global status variables in the
     <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
      <span class="command">
       <strong>
        mysql
       </strong>
      </span>
     </a>
     client
    </em>
   </span>
   . This means that specifying the
   <code class="literal">
    SESSION
   </code>
   or
   <code class="literal">
    GLOBAL
   </code>
   keyword
      with
   <a class="link" href="show-status.html" title="15.7.7.37 SHOW STATUS Statement">
    <code class="literal">
     SHOW STATUS
    </code>
   </a>
   has no effect on
      the values reported for NDB API statistics status variables, and
      the value for each of these variables is the same whether the
      value is obtained from the equivalent column of the
   <a class="link" href="performance-schema-status-variable-tables.html" title="29.12.15 Performance Schema Status Variable Tables">
    <code class="literal">
     session_status
    </code>
   </a>
   or the
   <a class="link" href="performance-schema-status-variable-tables.html" title="29.12.15 Performance Schema Status Variable Tables">
    <code class="literal">
     global_status
    </code>
   </a>
   table.
  </p>
  <a class="indexterm" name="idm46045091036256">
  </a>
  <a class="indexterm" name="idm46045091034752">
  </a>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <span class="emphasis">
       <em>
        Session counters (session specific)
       </em>
      </span>
     </p>
     <p>
      Session counters relate to the
      <a class="ulink" href="/doc/ndbapi/en/ndb-ndb.html" target="_top">
       <code class="literal">
        Ndb
       </code>
      </a>
      objects in use by (only)
          the current session. Use of such objects by other MySQL
          clients does not influence these counts.
     </p>
     <p>
      In order to minimize confusion with standard MySQL session
          variables, we refer to the variables that correspond to these
          NDB API session counters as
      <span class="quote">
       “
       <span class="quote">
        <code class="literal">
         _session
        </code>
        variables
       </span>
       ”
      </span>
      , with a leading underscore.
     </p>
    </li>
    <li class="listitem">
     <p>
      <span class="emphasis">
       <em>
        Replica counters (global)
       </em>
      </span>
     </p>
     <p>
      This set of counters relates to the
      <a class="ulink" href="/doc/ndbapi/en/ndb-ndb.html" target="_top">
       <code class="literal">
        Ndb
       </code>
      </a>
      objects used by the
          replica SQL thread, if any. If this
      <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
       <span class="command">
        <strong>
         mysqld
        </strong>
       </span>
      </a>
      does not act as a replica, or does not use
      <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
       <code class="literal">
        NDB
       </code>
      </a>
      tables, then all of these
          counts are 0.
     </p>
     <p>
      We refer to the related status variables as
      <span class="quote">
       “
       <span class="quote">
        <code class="literal">
         _replica
        </code>
        variables
       </span>
       ”
      </span>
      (with a
          leading underscore).
     </p>
    </li>
    <li class="listitem">
     <p>
      <span class="emphasis">
       <em>
        Injector counters (global)
       </em>
      </span>
     </p>
     <p>
      Injector counters relate to the
      <a class="ulink" href="/doc/ndbapi/en/ndb-ndb.html" target="_top">
       <code class="literal">
        Ndb
       </code>
      </a>
      object used to listen to
          cluster events by the binary log injector thread. Even when
          not writing a binary log,
      <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
       <span class="command">
        <strong>
         mysqld
        </strong>
       </span>
      </a>
      processes
          attached to an NDB Cluster continue to listen for some events,
          such as schema changes.
     </p>
     <p>
      We refer to the status variables that correspond to NDB API
          injector counters as
      <span class="quote">
       “
       <span class="quote">
        <code class="literal">
         _injector
        </code>
        variables
       </span>
       ”
      </span>
      (with a leading underscore).
     </p>
    </li>
    <li class="listitem">
     <p>
      <span class="emphasis">
       <em>
        Server (Global) counters (global)
       </em>
      </span>
     </p>
     <p>
      This set of counters relates to all
      <a class="ulink" href="/doc/ndbapi/en/ndb-ndb.html" target="_top">
       <code class="literal">
        Ndb
       </code>
      </a>
      objects currently used by
          this
      <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
       <span class="command">
        <strong>
         mysqld
        </strong>
       </span>
      </a>
      . This includes all MySQL client
          applications, the replica SQL thread (if any), the binary log
          injector, and the
      <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
       <code class="literal">
        NDB
       </code>
      </a>
      utility
          thread.
     </p>
     <p>
      We refer to the status variables that correspond to these
          counters as
      <span class="quote">
       “
       <span class="quote">
        global variables
       </span>
       ”
      </span>
      or
      <span class="quote">
       “
       <span class="quote">
        <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
         <span class="command">
          <strong>
           mysqld
          </strong>
         </span>
        </a>
        -level variables
       </span>
       ”
      </span>
      .
     </p>
    </li>
   </ul>
  </div>
  <p>
   You can obtain values for a particular set of variables by
      additionally filtering for the substring
   <code class="literal">
    session
   </code>
   ,
   <code class="literal">
    replica
   </code>
   , or
   <code class="literal">
    injector
   </code>
   in the variable name (along with the
      common prefix
   <code class="literal">
    Ndb_api
   </code>
   ). For
   <code class="literal">
    _session
   </code>
   variables, this can be done as shown
      here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa25869197"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">STATUS</span> <span class="token operator">LIKE</span> <span class="token string">'ndb_api%session'</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Variable_name                                <span class="token punctuation">|</span> Value   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_exec_complete_count_session     <span class="token punctuation">|</span> 0       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_scan_result_count_session       <span class="token punctuation">|</span> 3       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_meta_request_count_session      <span class="token punctuation">|</span> 6       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_nanos_count_session             <span class="token punctuation">|</span> 2022486 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_sent_count_session             <span class="token punctuation">|</span> 268     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_received_count_session         <span class="token punctuation">|</span> 10332   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_start_count_session            <span class="token punctuation">|</span> 1       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count_session           <span class="token punctuation">|</span> 0       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_abort_count_session            <span class="token punctuation">|</span> 0       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_close_count_session            <span class="token punctuation">|</span> 1       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pk_op_count_session                  <span class="token punctuation">|</span> 0       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_uk_op_count_session                  <span class="token punctuation">|</span> 0       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_table_scan_count_session             <span class="token punctuation">|</span> 1       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_range_scan_count_session             <span class="token punctuation">|</span> 0       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pruned_scan_count_session            <span class="token punctuation">|</span> 0       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_scan_batch_count_session             <span class="token punctuation">|</span> 2       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_read_row_count_session               <span class="token punctuation">|</span> 2       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_local_read_row_count_session   <span class="token punctuation">|</span> 2       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_forced_count_session   <span class="token punctuation">|</span> 1       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_unforced_count_session <span class="token punctuation">|</span> 0       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_deferred_count_session <span class="token punctuation">|</span> 0       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output">21 rows in set (0.00 sec)</span></code></pre>
  </div>
  <p>
   To obtain a listing of the NDB API
   <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
    <span class="command">
     <strong>
      mysqld
     </strong>
    </span>
   </a>
   -level
      status variables, filter for variable names beginning with
   <code class="literal">
    ndb_api
   </code>
   and ending in
   <code class="literal">
    _count
   </code>
   , like this:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa21225759"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> performance_schema<span class="token punctuation">.</span>session_status
<span class="token prompt">    -&gt;</span>     <span class="token keyword">WHERE</span> VARIABLE_NAME <span class="token operator">LIKE</span> <span class="token string">'ndb_api%count'</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> VARIABLE_NAME                      <span class="token punctuation">|</span> VARIABLE_VALUE <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_WAIT_EXEC_COMPLETE_COUNT   <span class="token punctuation">|</span> 4              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_WAIT_SCAN_RESULT_COUNT     <span class="token punctuation">|</span> 3              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_WAIT_META_REQUEST_COUNT    <span class="token punctuation">|</span> 28             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_WAIT_NANOS_COUNT           <span class="token punctuation">|</span> 53756398       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_BYTES_SENT_COUNT           <span class="token punctuation">|</span> 1060           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_BYTES_RECEIVED_COUNT       <span class="token punctuation">|</span> 9724           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_TRANS_START_COUNT          <span class="token punctuation">|</span> 3              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_TRANS_COMMIT_COUNT         <span class="token punctuation">|</span> 2              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_TRANS_ABORT_COUNT          <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_TRANS_CLOSE_COUNT          <span class="token punctuation">|</span> 3              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_PK_OP_COUNT                <span class="token punctuation">|</span> 2              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_UK_OP_COUNT                <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_TABLE_SCAN_COUNT           <span class="token punctuation">|</span> 1              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_RANGE_SCAN_COUNT           <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_PRUNED_SCAN_COUNT          <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_SCAN_BATCH_COUNT           <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_READ_ROW_COUNT             <span class="token punctuation">|</span> 2              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_TRANS_LOCAL_READ_ROW_COUNT <span class="token punctuation">|</span> 2              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_EVENT_DATA_COUNT           <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_EVENT_NONDATA_COUNT        <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> NDB_API_EVENT_BYTES_COUNT          <span class="token punctuation">|</span> 0              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output">21 rows in set (0.09 sec)</span></code></pre>
  </div>
  <p>
   Not all counters are reflected in all 4 sets of status variables.
      For the event counters
   <code class="literal">
    DataEventsRecvdCount
   </code>
   ,
   <code class="literal">
    NondataEventsRecvdCount
   </code>
   , and
   <code class="literal">
    EventBytesRecvdCount
   </code>
   , only
   <code class="literal">
    _injector
   </code>
   and
   <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
    <span class="command">
     <strong>
      mysqld
     </strong>
    </span>
   </a>
   -level
      NDB API status variables are available:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa66341745"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">STATUS</span> <span class="token operator">LIKE</span> <span class="token string">'ndb_api%event%'</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Variable_name                        <span class="token punctuation">|</span> Value <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_data_count_injector    <span class="token punctuation">|</span> 0     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_nondata_count_injector <span class="token punctuation">|</span> 0     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_bytes_count_injector   <span class="token punctuation">|</span> 0     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_data_count             <span class="token punctuation">|</span> 0     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_nondata_count          <span class="token punctuation">|</span> 0     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_bytes_count            <span class="token punctuation">|</span> 0     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output">6 rows in set (0.00 sec)</span></code></pre>
  </div>
  <p>
   <code class="literal">
    _injector
   </code>
   status variables are not implemented
      for any other NDB API counters, as shown here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa96492355"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">STATUS</span> <span class="token operator">LIKE</span> <span class="token string">'ndb_api%injector%'</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Variable_name                        <span class="token punctuation">|</span> Value <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_data_count_injector    <span class="token punctuation">|</span> 0     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_nondata_count_injector <span class="token punctuation">|</span> 0     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_bytes_count_injector   <span class="token punctuation">|</span> 0     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output">3 rows in set (0.00 sec)</span></code></pre>
  </div>
  <a class="indexterm" name="idm46045090981504">
  </a>
  <a class="indexterm" name="idm46045090979984">
  </a>
  <p>
   The names of the status variables can easily be associated with
      the names of the corresponding counters. Each NDB API statistics
      counter is listed in the following table with a description as
      well as the names of any MySQL server status variables
      corresponding to this counter.
  </p>
  <div class="table">
   <a name="idm46045090977760">
   </a>
   <p class="title">
    <b>
     Table 25.39 NDB API statistics counters
    </b>
   </p>
   <div class="table-contents">
    <table>
     <colgroup>
      <col style="width: 30%"/>
      <col style="width: 35%"/>
      <col style="width: 40%"/>
     </colgroup>
     <thead>
      <tr>
       <th scope="col">
        Counter Name
       </th>
       <th scope="col">
        Description
       </th>
       <th scope="col">
        Status Variables (by statistic type):
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            Session
           </p>
          </li>
          <li class="listitem">
           <p>
            Replica (slave)
           </p>
          </li>
          <li class="listitem">
           <p>
            Injector
           </p>
          </li>
          <li class="listitem">
           <p>
            Server
           </p>
          </li>
         </ul>
        </div>
       </th>
      </tr>
     </thead>
     <tbody>
      <tr>
       <th scope="row">
        <code class="literal">
         WaitExecCompleteCount
        </code>
       </th>
       <td>
        Number of times thread has been blocked while waiting for execution of
            an operation to complete. Includes all
        <a class="ulink" href="/doc/ndbapi/en/ndb-ndbtransaction.html#ndb-ndbtransaction-execute" target="_top">
         <code class="literal">
          execute()
         </code>
        </a>
        calls as well as implicit executes for blob operations and
            auto-increment not visible to clients.
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_wait_exec_complete_count_session">
             <code class="literal">
              Ndb_api_wait_exec_complete_count_session
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_wait_exec_complete_count_replica">
             <code class="literal">
              Ndb_api_wait_exec_complete_count_replica
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_wait_exec_complete_count">
             <code class="literal">
              Ndb_api_wait_exec_complete_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         WaitScanResultCount
        </code>
       </th>
       <td>
        Number of times thread has been blocked while waiting for a scan-based
            signal, such waiting for additional results, or for a scan
            to close.
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_wait_scan_result_count_session">
             <code class="literal">
              Ndb_api_wait_scan_result_count_session
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_wait_scan_result_count_replica">
             <code class="literal">
              Ndb_api_wait_scan_result_count_replica
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_wait_scan_result_count">
             <code class="literal">
              Ndb_api_wait_scan_result_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         WaitMetaRequestCount
        </code>
       </th>
       <td>
        Number of times thread has been blocked waiting for a metadata-based
            signal; this can occur when waiting for a DDL operation or
            for an epoch to be started (or ended).
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_wait_meta_request_count_session">
             <code class="literal">
              Ndb_api_wait_meta_request_count_session
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_wait_meta_request_count_replica">
             <code class="literal">
              Ndb_api_wait_meta_request_count_replica
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_wait_meta_request_count">
             <code class="literal">
              Ndb_api_wait_meta_request_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         WaitNanosCount
        </code>
       </th>
       <td>
        Total time (in nanoseconds) spent waiting for some type of signal from
            the data nodes.
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_wait_nanos_count_session">
             <code class="literal">
              Ndb_api_wait_nanos_count_session
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_wait_nanos_count_replica">
             <code class="literal">
              Ndb_api_wait_nanos_count_replica
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_wait_nanos_count">
             <code class="literal">
              Ndb_api_wait_nanos_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         BytesSentCount
        </code>
       </th>
       <td>
        Amount of data (in bytes) sent to the data nodes
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_bytes_sent_count_session">
             <code class="literal">
              Ndb_api_bytes_sent_count_session
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_bytes_sent_count_replica">
             <code class="literal">
              Ndb_api_bytes_sent_count_replica
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_bytes_sent_count">
             <code class="literal">
              Ndb_api_bytes_sent_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         BytesRecvdCount
        </code>
       </th>
       <td>
        Amount of data (in bytes) received from the data nodes
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_bytes_received_count_session">
             <code class="literal">
              Ndb_api_bytes_received_count_session
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_bytes_received_count_slave">
             <code class="literal">
              Ndb_api_bytes_received_count_slave
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_bytes_received_count">
             <code class="literal">
              Ndb_api_bytes_received_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         TransStartCount
        </code>
       </th>
       <td>
        Number of transactions started.
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_trans_start_count_session">
             <code class="literal">
              Ndb_api_trans_start_count_session
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_trans_start_count_replica">
             <code class="literal">
              Ndb_api_trans_start_count_replica
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_trans_start_count">
             <code class="literal">
              Ndb_api_trans_start_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         TransCommitCount
        </code>
       </th>
       <td>
        Number of transactions committed.
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_trans_commit_count_session">
             <code class="literal">
              Ndb_api_trans_commit_count_session
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_trans_commit_count_replica">
             <code class="literal">
              Ndb_api_trans_commit_count_replica
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_trans_commit_count">
             <code class="literal">
              Ndb_api_trans_commit_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         TransAbortCount
        </code>
       </th>
       <td>
        Number of transactions aborted.
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_trans_abort_count_session">
             <code class="literal">
              Ndb_api_trans_abort_count_session
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_trans_abort_count_replica">
             <code class="literal">
              Ndb_api_trans_abort_count_replica
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_trans_abort_count">
             <code class="literal">
              Ndb_api_trans_abort_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         TransCloseCount
        </code>
       </th>
       <td>
        Number of transactions aborted. (This value may be greater than the sum
            of
        <code class="literal">
         TransCommitCount
        </code>
        and
        <code class="literal">
         TransAbortCount
        </code>
        .)
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_trans_close_count_session">
             <code class="literal">
              Ndb_api_trans_close_count_session
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_trans_close_count_replica">
             <code class="literal">
              Ndb_api_trans_close_count_replica
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_trans_close_count">
             <code class="literal">
              Ndb_api_trans_close_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         PkOpCount
        </code>
       </th>
       <td>
        Number of operations based on or using primary keys. This count includes
            blob-part table operations, implicit unlocking operations,
            and auto-increment operations, as well as primary key
            operations normally visible to MySQL clients.
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_pk_op_count_session">
             <code class="literal">
              Ndb_api_pk_op_count_session
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_pk_op_count_replica">
             <code class="literal">
              Ndb_api_pk_op_count_replica
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_pk_op_count">
             <code class="literal">
              Ndb_api_pk_op_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         UkOpCount
        </code>
       </th>
       <td>
        Number of operations based on or using unique keys.
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_uk_op_count_session">
             <code class="literal">
              Ndb_api_uk_op_count_session
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_uk_op_count_replica">
             <code class="literal">
              Ndb_api_uk_op_count_replica
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_uk_op_count">
             <code class="literal">
              Ndb_api_uk_op_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         TableScanCount
        </code>
       </th>
       <td>
        Number of table scans that have been started. This includes scans of
            internal tables.
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_table_scan_count_session">
             <code class="literal">
              Ndb_api_table_scan_count_session
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_table_scan_count_replica">
             <code class="literal">
              Ndb_api_table_scan_count_replica
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_table_scan_count">
             <code class="literal">
              Ndb_api_table_scan_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         RangeScanCount
        </code>
       </th>
       <td>
        Number of range scans that have been started.
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_range_scan_count_session">
             <code class="literal">
              Ndb_api_range_scan_count_session
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_range_scan_count_replica">
             <code class="literal">
              Ndb_api_range_scan_count_replica
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_range_scan_count">
             <code class="literal">
              Ndb_api_range_scan_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         PrunedScanCount
        </code>
       </th>
       <td>
        Number of scans that have been pruned to a single partition.
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_pruned_scan_count_session">
             <code class="literal">
              Ndb_api_pruned_scan_count_session
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_pruned_scan_count_replica">
             <code class="literal">
              Ndb_api_pruned_scan_count_replica
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_pruned_scan_count">
             <code class="literal">
              Ndb_api_pruned_scan_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         ScanBatchCount
        </code>
       </th>
       <td>
        Number of batches of rows received. (A
        <span class="firstterm">
         batch
        </span>
        in this context
            is a set of scan results from a single fragment.)
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_scan_batch_count_session">
             <code class="literal">
              Ndb_api_scan_batch_count_session
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_scan_batch_count_replica">
             <code class="literal">
              Ndb_api_scan_batch_count_replica
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_scan_batch_count">
             <code class="literal">
              Ndb_api_scan_batch_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         ReadRowCount
        </code>
       </th>
       <td>
        Total number of rows that have been read. Includes rows read using
            primary key, unique key, and scan operations.
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_read_row_count_session">
             <code class="literal">
              Ndb_api_read_row_count_session
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_read_row_count_replica">
             <code class="literal">
              Ndb_api_read_row_count_replica
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_read_row_count">
             <code class="literal">
              Ndb_api_read_row_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         TransLocalReadRowCount
        </code>
       </th>
       <td>
        Number of rows read from the data same node on which the transaction was
            being run.
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_trans_local_read_row_count_session">
             <code class="literal">
              Ndb_api_trans_local_read_row_count_session
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_trans_local_read_row_count_replica">
             <code class="literal">
              Ndb_api_trans_local_read_row_count_replica
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_trans_local_read_row_count">
             <code class="literal">
              Ndb_api_trans_local_read_row_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         DataEventsRecvdCount
        </code>
       </th>
       <td>
        Number of row change events received.
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_event_data_count_injector">
             <code class="literal">
              Ndb_api_event_data_count_injector
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_event_data_count">
             <code class="literal">
              Ndb_api_event_data_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         NondataEventsRecvdCount
        </code>
       </th>
       <td>
        Number of events received, other than row change events.
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_event_nondata_count_injector">
             <code class="literal">
              Ndb_api_event_nondata_count_injector
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_event_nondata_count">
             <code class="literal">
              Ndb_api_event_nondata_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <code class="literal">
         EventBytesRecvdCount
        </code>
       </th>
       <td>
        Number of bytes of events received.
       </td>
       <td>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            [none]
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_event_bytes_count_injector">
             <code class="literal">
              Ndb_api_event_bytes_count_injector
             </code>
            </a>
           </p>
          </li>
          <li class="listitem">
           <p>
            <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_event_bytes_count">
             <code class="literal">
              Ndb_api_event_bytes_count
             </code>
            </a>
           </p>
          </li>
         </ul>
        </div>
       </td>
      </tr>
     </tbody>
    </table>
   </div>
   <div class="table-contents">
    <table cellpadding="0" cellspacing="0" style="position: fixed; top: 0px; display: none; left: 401px; width: 739px;">
     <thead>
      <tr>
       <th scope="col" style="width: 199.219px;">
        Counter Name
       </th>
       <th scope="col" style="width: 160.5px;">
        Description
       </th>
       <th scope="col" style="width: 378.281px;">
        Status Variables (by statistic type):
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: disc; ">
          <li class="listitem">
           <p>
            Session
           </p>
          </li>
          <li class="listitem">
           <p>
            Replica (slave)
           </p>
          </li>
          <li class="listitem">
           <p>
            Injector
           </p>
          </li>
          <li class="listitem">
           <p>
            Server
           </p>
          </li>
         </ul>
        </div>
       </th>
      </tr>
     </thead>
    </table>
   </div>
  </div>
  <br class="table-break"/>
  <p>
   To see all counts of committed transactions—that is, all
   <code class="literal">
    TransCommitCount
   </code>
   counter status
      variables—you can filter the results of
   <a class="link" href="show-status.html" title="15.7.7.37 SHOW STATUS Statement">
    <code class="literal">
     SHOW STATUS
    </code>
   </a>
   for the substring
   <code class="literal">
    trans_commit_count
   </code>
   , like this:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa8288054"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">STATUS</span> <span class="token operator">LIKE</span> <span class="token string">'%trans_commit_count%'</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Variable_name                      <span class="token punctuation">|</span> Value <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count_session <span class="token punctuation">|</span> 1     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count_slave   <span class="token punctuation">|</span> 0     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count         <span class="token punctuation">|</span> 2     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output">3 rows in set (0.00 sec)</span></code></pre>
  </div>
  <p>
   From this you can determine that 1 transaction has been committed
      in the current
   <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
    <span class="command">
     <strong>
      mysql
     </strong>
    </span>
   </a>
   client session, and 2
      transactions have been committed on this
   <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
    <span class="command">
     <strong>
      mysqld
     </strong>
    </span>
   </a>
   since it was last restarted.
  </p>
  <p>
   You can see how various NDB API counters are incremented by a
      given SQL statement by comparing the values of the corresponding
   <code class="literal">
    _session
   </code>
   status variables immediately before
      and after performing the statement. In this example, after getting
      the initial values from
   <a class="link" href="show-status.html" title="15.7.7.37 SHOW STATUS Statement">
    <code class="literal">
     SHOW
      STATUS
    </code>
   </a>
   , we create in the
   <code class="literal">
    test
   </code>
   database an
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   table, named
   <code class="literal">
    t
   </code>
   , that has a single column:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa14463494"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">STATUS</span> <span class="token operator">LIKE</span> <span class="token string">'ndb_api%session%'</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Variable_name                              <span class="token punctuation">|</span> Value  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_exec_complete_count_session   <span class="token punctuation">|</span> 2      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_scan_result_count_session     <span class="token punctuation">|</span> 0      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_meta_request_count_session    <span class="token punctuation">|</span> 3      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_nanos_count_session           <span class="token punctuation">|</span> 820705 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_sent_count_session           <span class="token punctuation">|</span> 132    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_received_count_session       <span class="token punctuation">|</span> 372    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_start_count_session          <span class="token punctuation">|</span> 1      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count_session         <span class="token punctuation">|</span> 1      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_abort_count_session          <span class="token punctuation">|</span> 0      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_close_count_session          <span class="token punctuation">|</span> 1      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pk_op_count_session                <span class="token punctuation">|</span> 1      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_uk_op_count_session                <span class="token punctuation">|</span> 0      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_table_scan_count_session           <span class="token punctuation">|</span> 0      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_range_scan_count_session           <span class="token punctuation">|</span> 0      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pruned_scan_count_session          <span class="token punctuation">|</span> 0      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_scan_batch_count_session           <span class="token punctuation">|</span> 0      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_read_row_count_session             <span class="token punctuation">|</span> 1      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_local_read_row_count_session <span class="token punctuation">|</span> 1      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output">18 rows in set (0.00 sec)</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">USE</span> test<span class="token punctuation">;</span>
<span class="token keyword">Database</span> <span class="token keyword">changed</span>
<span class="token prompt">mysql&gt;</span> <span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> t <span class="token punctuation">(</span>c <span class="token datatype">INT</span><span class="token punctuation">)</span> <span class="token keyword">ENGINE</span> <span class="token keyword">NDBCLUSTER</span><span class="token punctuation">;</span>
<span class="token output">Query OK, 0 rows affected (0.85 sec)</span></code></pre>
  </div>
  <p>
   Now you can execute a new
   <a class="link" href="show-status.html" title="15.7.7.37 SHOW STATUS Statement">
    <code class="literal">
     SHOW
      STATUS
    </code>
   </a>
   statement and observe the changes, as shown here
      (with the changed rows highlighted in the output):
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa22625805"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">STATUS</span> <span class="token operator">LIKE</span> <span class="token string">'ndb_api%session%'</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Variable_name                              <span class="token punctuation">|</span> Value     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span><em>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_exec_complete_count_session   <span class="token punctuation">|</span> 8         <span class="token punctuation">|</span></span></em><span class="token output"><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_scan_result_count_session     <span class="token punctuation">|</span> 0         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_wait_meta_request_count_session    <span class="token punctuation">|</span> 17        <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_wait_nanos_count_session           <span class="token punctuation">|</span> 706871709 <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_bytes_sent_count_session           <span class="token punctuation">|</span> 2376      <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_bytes_received_count_session       <span class="token punctuation">|</span> 3844      <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_trans_start_count_session          <span class="token punctuation">|</span> 4         <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_trans_commit_count_session         <span class="token punctuation">|</span> 4         <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_abort_count_session          <span class="token punctuation">|</span> 0         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_trans_close_count_session          <span class="token punctuation">|</span> 4         <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_pk_op_count_session                <span class="token punctuation">|</span> 6         <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_uk_op_count_session                <span class="token punctuation">|</span> 0         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_table_scan_count_session           <span class="token punctuation">|</span> 0         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_range_scan_count_session           <span class="token punctuation">|</span> 0         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pruned_scan_count_session          <span class="token punctuation">|</span> 0         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_scan_batch_count_session           <span class="token punctuation">|</span> 0         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_read_row_count_session             <span class="token punctuation">|</span> 2         <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_local_read_row_count_session <span class="token punctuation">|</span> 1         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output">18 rows in set (0.00 sec)</span></code></pre>
  </div>
  <p>
   Similarly, you can see the changes in the NDB API statistics
      counters caused by inserting a row into
   <code class="literal">
    t
   </code>
   :
      Insert the row, then run the same
   <a class="link" href="show-status.html" title="15.7.7.37 SHOW STATUS Statement">
    <code class="literal">
     SHOW
      STATUS
    </code>
   </a>
   statement used in the previous example, as shown
      here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa6502045"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">INSERT</span> <span class="token keyword">INTO</span> t <span class="token keyword">VALUES</span> <span class="token punctuation">(</span><span class="token number">100</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token output">Query OK, 1 row affected (0.00 sec)</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">STATUS</span> <span class="token operator">LIKE</span> <span class="token string">'ndb_api%session%'</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Variable_name                              <span class="token punctuation">|</span> Value     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_wait_exec_complete_count_session   <span class="token punctuation">|</span> 11        <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_wait_scan_result_count_session     <span class="token punctuation">|</span> 6         <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_wait_meta_request_count_session    <span class="token punctuation">|</span> 20        <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_wait_nanos_count_session           <span class="token punctuation">|</span> 707370418 <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_bytes_sent_count_session           <span class="token punctuation">|</span> 2724      <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_bytes_received_count_session       <span class="token punctuation">|</span> 4116      <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_trans_start_count_session          <span class="token punctuation">|</span> 7         <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_trans_commit_count_session         <span class="token punctuation">|</span> 6         <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_abort_count_session          <span class="token punctuation">|</span> 0         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_trans_close_count_session          <span class="token punctuation">|</span> 7         <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_pk_op_count_session                <span class="token punctuation">|</span> 8         <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_uk_op_count_session                <span class="token punctuation">|</span> 0         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_table_scan_count_session           <span class="token punctuation">|</span> 1         <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_range_scan_count_session           <span class="token punctuation">|</span> 0         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pruned_scan_count_session          <span class="token punctuation">|</span> 0         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_scan_batch_count_session           <span class="token punctuation">|</span> 0         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_read_row_count_session             <span class="token punctuation">|</span> 3         <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> Ndb_api_trans_local_read_row_count_session <span class="token punctuation">|</span> 2         <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output">18 rows in set (0.00 sec)</span></code></pre>
  </div>
  <p>
   We can make a number of observations from these results:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      Although we created
      <code class="literal">
       t
      </code>
      with no explicit
          primary key, 5 primary key operations were performed in doing
          so (the difference in the
      <span class="quote">
       “
       <span class="quote">
        before
       </span>
       ”
      </span>
      and
      <span class="quote">
       “
       <span class="quote">
        after
       </span>
       ”
      </span>
      values of
      <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_pk_op_count_session">
       <code class="literal">
        Ndb_api_pk_op_count_session
       </code>
      </a>
      ,
          or 6 minus 1). This reflects the creation of the hidden
          primary key that is a feature of all tables using the
      <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
       <code class="literal">
        NDB
       </code>
      </a>
      storage engine.
     </p>
    </li>
    <li class="listitem">
     <p>
      By comparing successive values for
      <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_wait_nanos_count_session">
       <code class="literal">
        Ndb_api_wait_nanos_count_session
       </code>
      </a>
      ,
          we can see that the NDB API operations implementing the
      <a class="link" href="create-table.html" title="15.1.20 CREATE TABLE Statement">
       <code class="literal">
        CREATE TABLE
       </code>
      </a>
      statement waited
          much longer (706871709 - 820705 = 706051004 nanoseconds, or
          approximately 0.7 second) for responses from the data nodes
          than those executed by the
      <a class="link" href="insert.html" title="15.2.7 INSERT Statement">
       <code class="literal">
        INSERT
       </code>
      </a>
      (707370418 - 706871709 =
          498709 ns or roughly .0005 second). The execution times
          reported for these statements in the
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      client correlate roughly with these figures.
     </p>
     <p>
      On platforms without sufficient (nanosecond) time resolution,
          small changes in the value of the
      <code class="literal">
       WaitNanosCount
      </code>
      NDB API counter due to SQL
          statements that execute very quickly may not always be visible
          in the values of
      <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_wait_nanos_count_session">
       <code class="literal">
        Ndb_api_wait_nanos_count_session
       </code>
      </a>
      ,
      <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_wait_nanos_count_replica">
       <code class="literal">
        Ndb_api_wait_nanos_count_replica
       </code>
      </a>
      ,
          or
      <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_wait_nanos_count">
       <code class="literal">
        Ndb_api_wait_nanos_count
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      The
      <a class="link" href="insert.html" title="15.2.7 INSERT Statement">
       <code class="literal">
        INSERT
       </code>
      </a>
      statement
          incremented both the
      <code class="literal">
       ReadRowCount
      </code>
      and
      <code class="literal">
       TransLocalReadRowCount
      </code>
      NDB API statistics
          counters, as reflected by the increased values of
      <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_read_row_count_session">
       <code class="literal">
        Ndb_api_read_row_count_session
       </code>
      </a>
      and
      <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_api_trans_local_read_row_count_session">
       <code class="literal">
        Ndb_api_trans_local_read_row_count_session
       </code>
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
