<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-cluster-ndbinfo-diskstats-1sec">
      </a>
      25.6.17.33 The ndbinfo diskstats_1sec Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045089368336">
  </a>
  <p>
   The
   <code class="literal">
    diskstats_1sec
   </code>
   table provides information
        about writes to Disk Data tablespaces over the past 20 seconds.
  </p>
  <p>
   The
   <code class="literal">
    diskstat
   </code>
   table contains the following
        columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       node_id
      </code>
     </p>
     <p>
      Node ID of this node
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       block_instance
      </code>
     </p>
     <p>
      ID of reporting instance of
      <a class="ulink" href="/doc/ndb-internals/en/ndb-internals-kernel-blocks-pgman.html" target="_top">
       <code class="literal">
        PGMAN
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       pages_made_dirty
      </code>
     </p>
     <p>
      Pages made dirty during the designated 1-second interval
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       reads_issued
      </code>
     </p>
     <p>
      Reads issued during the designated 1-second interval
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       reads_completed
      </code>
     </p>
     <p>
      Reads completed during the designated 1-second interval
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       writes_issued
      </code>
     </p>
     <p>
      Writes issued during the designated 1-second interval
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       writes_completed
      </code>
     </p>
     <p>
      Writes completed during the designated 1-second interval
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       log_writes_issued
      </code>
     </p>
     <p>
      Number of times a page write has required a log write during
            the designated 1-second interval
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       log_writes_completed
      </code>
     </p>
     <p>
      Number of log writes completed during the designated
            1-second interval
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       get_page_calls_issued
      </code>
     </p>
     <p>
      Number of
      <code class="literal">
       get_page()
      </code>
      calls issued during
            the designated 1-second interval
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       get_page_reqs_issued
      </code>
     </p>
     <p>
      Number of times that a
      <code class="literal">
       get_page()
      </code>
      call
            has resulted in a wait for I/O or completion of I/O already
            begun during the designated 1-second interval
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       get_page_reqs_completed
      </code>
     </p>
     <p>
      Number of
      <code class="literal">
       get_page()
      </code>
      calls waiting for
            I/O or I/O completion that have completed during the
            designated 1-second interval
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       seconds_ago
      </code>
     </p>
     <p>
      Number of 1-second intervals in the past of the interval to
            which this row applies
     </p>
    </li>
   </ul>
  </div>
  <h5>
   <a name="idm46045089335408">
   </a>
   Notes
  </h5>
  <p>
   Each row in this table corresponds to an instance of
   <a class="ulink" href="/doc/ndb-internals/en/ndb-internals-kernel-blocks-pgman.html" target="_top">
    <code class="literal">
     PGMAN
    </code>
   </a>
   during a 1-second
        interval occurring from 0 to 19 seconds ago; there is one such
        instance per LDM thread plus an additional instance for each
        data node.
  </p>
 </div>
 <br/>
</div>
