<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="sys-schema-object-index">
      </a>
      30.4.1 sys Schema Object Index
     </h3>
    </div>
   </div>
  </div>
  <p>
   The following tables list
   <a class="link" href="sys-schema.html" title="Chapter 30 MySQL sys Schema">
    <code class="literal">
     sys
    </code>
   </a>
   schema objects and provide a short description of each one.
  </p>
  <div class="table">
   <a name="sys-schema-tables-table">
   </a>
   <p class="title">
    <b>
     Table 30.1 sys Schema Tables and Triggers
    </b>
   </p>
   <div class="table-contents">
    <table frame="box" rules="all" summary="Tables and triggers used in the sys schema implementation.">
     <colgroup>
      <col style="width: 28%"/>
      <col style="width: 71%"/>
     </colgroup>
     <thead>
      <tr>
       <th>
        Table or Trigger Name
       </th>
       <th>
        Description
       </th>
      </tr>
     </thead>
     <tbody>
      <tr>
       <td>
        <a class="link" href="sys-sys-config.html" title="30.4.2.1 The sys_config Table">
         <code class="literal">
          sys_config
         </code>
        </a>
       </td>
       <td>
        sys schema configuration options table
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-sys-config-insert-set-user.html" title="30.4.2.2 The sys_config_insert_set_user Trigger">
         <code class="literal">
          sys_config_insert_set_user
         </code>
        </a>
       </td>
       <td>
        sys_config insert trigger
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-sys-config-update-set-user.html" title="30.4.2.3 The sys_config_update_set_user Trigger">
         <code class="literal">
          sys_config_update_set_user
         </code>
        </a>
       </td>
       <td>
        sys_config update trigger
       </td>
      </tr>
     </tbody>
    </table>
   </div>
  </div>
  <br class="table-break"/>
  <div class="table">
   <a name="sys-schema-views-table">
   </a>
   <p class="title">
    <b>
     Table 30.2 sys Schema Views
    </b>
   </p>
   <div class="table-contents">
    <table frame="box" rules="all" summary="Views used in the sys schema implementation.">
     <colgroup>
      <col style="width: 25%"/>
      <col style="width: 62%"/>
      <col style="width: 12%"/>
     </colgroup>
     <thead>
      <tr>
       <th>
        View Name
       </th>
       <th>
        Description
       </th>
       <th>
        Deprecated
       </th>
      </tr>
     </thead>
     <tbody>
      <tr>
       <th scope="row">
        <a class="link" href="sys-host-summary.html" title="30.4.3.1 The host_summary and x$host_summary Views">
         <code class="literal">
          host_summary
         </code>
         ,
         <code class="literal">
          x$host_summary
         </code>
        </a>
       </th>
       <td>
        Statement activity, file I/O, and connections, grouped by host
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-host-summary-by-file-io.html" title="30.4.3.2 The host_summary_by_file_io and x$host_summary_by_file_io Views">
         <code class="literal">
          host_summary_by_file_io
         </code>
         ,
         <code class="literal">
          x$host_summary_by_file_io
         </code>
        </a>
       </th>
       <td>
        File I/O, grouped by host
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-host-summary-by-file-io-type.html" title="30.4.3.3 The host_summary_by_file_io_type and x$host_summary_by_file_io_type Views">
         <code class="literal">
          host_summary_by_file_io_type
         </code>
         ,
         <code class="literal">
          x$host_summary_by_file_io_type
         </code>
        </a>
       </th>
       <td>
        File I/O, grouped by host and event type
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-host-summary-by-stages.html" title="30.4.3.4 The host_summary_by_stages and x$host_summary_by_stages Views">
         <code class="literal">
          host_summary_by_stages
         </code>
         ,
         <code class="literal">
          x$host_summary_by_stages
         </code>
        </a>
       </th>
       <td>
        Statement stages, grouped by host
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-host-summary-by-statement-latency.html" title="30.4.3.5 The host_summary_by_statement_latency and x$host_summary_by_statement_latency Views">
         <code class="literal">
          host_summary_by_statement_latency
         </code>
         ,
         <code class="literal">
          x$host_summary_by_statement_latency
         </code>
        </a>
       </th>
       <td>
        Statement statistics, grouped by host
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-host-summary-by-statement-type.html" title="30.4.3.6 The host_summary_by_statement_type and x$host_summary_by_statement_type Views">
         <code class="literal">
          host_summary_by_statement_type
         </code>
         ,
         <code class="literal">
          x$host_summary_by_statement_type
         </code>
        </a>
       </th>
       <td>
        Statements executed, grouped by host and statement
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-innodb-buffer-stats-by-schema.html" title="30.4.3.7 The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Views">
         <code class="literal">
          innodb_buffer_stats_by_schema
         </code>
         ,
         <code class="literal">
          x$innodb_buffer_stats_by_schema
         </code>
        </a>
       </th>
       <td>
        InnoDB buffer information, grouped by schema
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-innodb-buffer-stats-by-table.html" title="30.4.3.8 The innodb_buffer_stats_by_table and x$innodb_buffer_stats_by_table Views">
         <code class="literal">
          innodb_buffer_stats_by_table
         </code>
         ,
         <code class="literal">
          x$innodb_buffer_stats_by_table
         </code>
        </a>
       </th>
       <td>
        InnoDB buffer information, grouped by schema and table
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-innodb-lock-waits.html" title="30.4.3.9 The innodb_lock_waits and x$innodb_lock_waits Views">
         <code class="literal">
          innodb_lock_waits
         </code>
         ,
         <code class="literal">
          x$innodb_lock_waits
         </code>
        </a>
       </th>
       <td>
        InnoDB lock information
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-io-by-thread-by-latency.html" title="30.4.3.10 The io_by_thread_by_latency and x$io_by_thread_by_latency Views">
         <code class="literal">
          io_by_thread_by_latency
         </code>
         ,
         <code class="literal">
          x$io_by_thread_by_latency
         </code>
        </a>
       </th>
       <td>
        I/O consumers, grouped by thread
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-io-global-by-file-by-bytes.html" title="30.4.3.11 The io_global_by_file_by_bytes and x$io_global_by_file_by_bytes Views">
         <code class="literal">
          io_global_by_file_by_bytes
         </code>
         ,
         <code class="literal">
          x$io_global_by_file_by_bytes
         </code>
        </a>
       </th>
       <td>
        Global I/O consumers, grouped by file and bytes
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-io-global-by-file-by-latency.html" title="30.4.3.12 The io_global_by_file_by_latency and x$io_global_by_file_by_latency Views">
         <code class="literal">
          io_global_by_file_by_latency
         </code>
         ,
         <code class="literal">
          x$io_global_by_file_by_latency
         </code>
        </a>
       </th>
       <td>
        Global I/O consumers, grouped by file and latency
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-io-global-by-wait-by-bytes.html" title="30.4.3.13 The io_global_by_wait_by_bytes and x$io_global_by_wait_by_bytes Views">
         <code class="literal">
          io_global_by_wait_by_bytes
         </code>
         ,
         <code class="literal">
          x$io_global_by_wait_by_bytes
         </code>
        </a>
       </th>
       <td>
        Global I/O consumers, grouped by bytes
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-io-global-by-wait-by-latency.html" title="30.4.3.14 The io_global_by_wait_by_latency and x$io_global_by_wait_by_latency Views">
         <code class="literal">
          io_global_by_wait_by_latency
         </code>
         ,
         <code class="literal">
          x$io_global_by_wait_by_latency
         </code>
        </a>
       </th>
       <td>
        Global I/O consumers, grouped by latency
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-latest-file-io.html" title="30.4.3.15 The latest_file_io and x$latest_file_io Views">
         <code class="literal">
          latest_file_io
         </code>
         ,
         <code class="literal">
          x$latest_file_io
         </code>
        </a>
       </th>
       <td>
        Most recent I/O, grouped by file and thread
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-memory-by-host-by-current-bytes.html" title="30.4.3.16 The memory_by_host_by_current_bytes and x$memory_by_host_by_current_bytes Views">
         <code class="literal">
          memory_by_host_by_current_bytes
         </code>
         ,
         <code class="literal">
          x$memory_by_host_by_current_bytes
         </code>
        </a>
       </th>
       <td>
        Memory use, grouped by host
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-memory-by-thread-by-current-bytes.html" title="30.4.3.17 The memory_by_thread_by_current_bytes and x$memory_by_thread_by_current_bytes Views">
         <code class="literal">
          memory_by_thread_by_current_bytes
         </code>
         ,
         <code class="literal">
          x$memory_by_thread_by_current_bytes
         </code>
        </a>
       </th>
       <td>
        Memory use, grouped by thread
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-memory-by-user-by-current-bytes.html" title="30.4.3.18 The memory_by_user_by_current_bytes and x$memory_by_user_by_current_bytes Views">
         <code class="literal">
          memory_by_user_by_current_bytes
         </code>
         ,
         <code class="literal">
          x$memory_by_user_by_current_bytes
         </code>
        </a>
       </th>
       <td>
        Memory use, grouped by user
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-memory-global-by-current-bytes.html" title="30.4.3.19 The memory_global_by_current_bytes and x$memory_global_by_current_bytes Views">
         <code class="literal">
          memory_global_by_current_bytes
         </code>
         ,
         <code class="literal">
          x$memory_global_by_current_bytes
         </code>
        </a>
       </th>
       <td>
        Memory use, grouped by allocation type
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-memory-global-total.html" title="30.4.3.20 The memory_global_total and x$memory_global_total Views">
         <code class="literal">
          memory_global_total
         </code>
         ,
         <code class="literal">
          x$memory_global_total
         </code>
        </a>
       </th>
       <td>
        Total memory use
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-metrics.html" title="30.4.3.21 The metrics View">
         <code class="literal">
          metrics
         </code>
        </a>
       </th>
       <td>
        Server metrics
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-processlist.html" title="30.4.3.22 The processlist and x$processlist Views">
         <code class="literal">
          processlist
         </code>
         ,
         <code class="literal">
          x$processlist
         </code>
        </a>
       </th>
       <td>
        Processlist information
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-ps-check-lost-instrumentation.html" title="30.4.3.23 The ps_check_lost_instrumentation View">
         <code class="literal">
          ps_check_lost_instrumentation
         </code>
        </a>
       </th>
       <td>
        Variables that have lost instruments
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-schema-auto-increment-columns.html" title="30.4.3.24 The schema_auto_increment_columns View">
         <code class="literal">
          schema_auto_increment_columns
         </code>
        </a>
       </th>
       <td>
        AUTO_INCREMENT column information
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-schema-index-statistics.html" title="30.4.3.25 The schema_index_statistics and x$schema_index_statistics Views">
         <code class="literal">
          schema_index_statistics
         </code>
         ,
         <code class="literal">
          x$schema_index_statistics
         </code>
        </a>
       </th>
       <td>
        Index statistics
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-schema-object-overview.html" title="30.4.3.26 The schema_object_overview View">
         <code class="literal">
          schema_object_overview
         </code>
        </a>
       </th>
       <td>
        Types of objects within each schema
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-schema-redundant-indexes.html" title="30.4.3.27 The schema_redundant_indexes and x$schema_flattened_keys Views">
         <code class="literal">
          schema_redundant_indexes
         </code>
        </a>
       </th>
       <td>
        Duplicate or redundant indexes
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-schema-table-lock-waits.html" title="30.4.3.28 The schema_table_lock_waits and x$schema_table_lock_waits Views">
         <code class="literal">
          schema_table_lock_waits
         </code>
         ,
         <code class="literal">
          x$schema_table_lock_waits
         </code>
        </a>
       </th>
       <td>
        Sessions waiting for metadata locks
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-schema-table-statistics.html" title="30.4.3.29 The schema_table_statistics and x$schema_table_statistics Views">
         <code class="literal">
          schema_table_statistics
         </code>
         ,
         <code class="literal">
          x$schema_table_statistics
         </code>
        </a>
       </th>
       <td>
        Table statistics
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-schema-table-statistics-with-buffer.html" title="30.4.3.30 The schema_table_statistics_with_buffer and x$schema_table_statistics_with_buffer Views">
         <code class="literal">
          schema_table_statistics_with_buffer
         </code>
         ,
         <code class="literal">
          x$schema_table_statistics_with_buffer
         </code>
        </a>
       </th>
       <td>
        Table statistics, including InnoDB buffer pool statistics
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-schema-tables-with-full-table-scans.html" title="30.4.3.31 The schema_tables_with_full_table_scans and x$schema_tables_with_full_table_scans Views">
         <code class="literal">
          schema_tables_with_full_table_scans
         </code>
         ,
         <code class="literal">
          x$schema_tables_with_full_table_scans
         </code>
        </a>
       </th>
       <td>
        Tables being accessed with full scans
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-schema-unused-indexes.html" title="30.4.3.32 The schema_unused_indexes View">
         <code class="literal">
          schema_unused_indexes
         </code>
        </a>
       </th>
       <td>
        Indexes not in active use
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-session.html" title="30.4.3.33 The session and x$session Views">
         <code class="literal">
          session
         </code>
         ,
         <code class="literal">
          x$session
         </code>
        </a>
       </th>
       <td>
        Processlist information for user sessions
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-session-ssl-status.html" title="30.4.3.34 The session_ssl_status View">
         <code class="literal">
          session_ssl_status
         </code>
        </a>
       </th>
       <td>
        Connection SSL information
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-statement-analysis.html" title="30.4.3.35 The statement_analysis and x$statement_analysis Views">
         <code class="literal">
          statement_analysis
         </code>
         ,
         <code class="literal">
          x$statement_analysis
         </code>
        </a>
       </th>
       <td>
        Statement aggregate statistics
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-statements-with-errors-or-warnings.html" title="30.4.3.36 The statements_with_errors_or_warnings and x$statements_with_errors_or_warnings Views">
         <code class="literal">
          statements_with_errors_or_warnings
         </code>
         ,
         <code class="literal">
          x$statements_with_errors_or_warnings
         </code>
        </a>
       </th>
       <td>
        Statements that have produced errors or warnings
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-statements-with-full-table-scans.html" title="30.4.3.37 The statements_with_full_table_scans and x$statements_with_full_table_scans Views">
         <code class="literal">
          statements_with_full_table_scans
         </code>
         ,
         <code class="literal">
          x$statements_with_full_table_scans
         </code>
        </a>
       </th>
       <td>
        Statements that have done full table scans
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-statements-with-runtimes-in-95th-percentile.html" title="30.4.3.38 The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile Views">
         <code class="literal">
          statements_with_runtimes_in_95th_percentile
         </code>
         ,
         <code class="literal">
          x$statements_with_runtimes_in_95th_percentile
         </code>
        </a>
       </th>
       <td>
        Statements with highest average runtime
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-statements-with-sorting.html" title="30.4.3.39 The statements_with_sorting and x$statements_with_sorting Views">
         <code class="literal">
          statements_with_sorting
         </code>
         ,
         <code class="literal">
          x$statements_with_sorting
         </code>
        </a>
       </th>
       <td>
        Statements that performed sorts
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-statements-with-temp-tables.html" title="30.4.3.40 The statements_with_temp_tables and x$statements_with_temp_tables Views">
         <code class="literal">
          statements_with_temp_tables
         </code>
         ,
         <code class="literal">
          x$statements_with_temp_tables
         </code>
        </a>
       </th>
       <td>
        Statements that used temporary tables
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-user-summary.html" title="30.4.3.41 The user_summary and x$user_summary Views">
         <code class="literal">
          user_summary
         </code>
         ,
         <code class="literal">
          x$user_summary
         </code>
        </a>
       </th>
       <td>
        User statement and connection activity
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-user-summary-by-file-io.html" title="30.4.3.42 The user_summary_by_file_io and x$user_summary_by_file_io Views">
         <code class="literal">
          user_summary_by_file_io
         </code>
         ,
         <code class="literal">
          x$user_summary_by_file_io
         </code>
        </a>
       </th>
       <td>
        File I/O, grouped by user
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-user-summary-by-file-io-type.html" title="30.4.3.43 The user_summary_by_file_io_type and x$user_summary_by_file_io_type Views">
         <code class="literal">
          user_summary_by_file_io_type
         </code>
         ,
         <code class="literal">
          x$user_summary_by_file_io_type
         </code>
        </a>
       </th>
       <td>
        File I/O, grouped by user and event
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-user-summary-by-stages.html" title="30.4.3.44 The user_summary_by_stages and x$user_summary_by_stages Views">
         <code class="literal">
          user_summary_by_stages
         </code>
         ,
         <code class="literal">
          x$user_summary_by_stages
         </code>
        </a>
       </th>
       <td>
        Stage events, grouped by user
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-user-summary-by-statement-latency.html" title="30.4.3.45 The user_summary_by_statement_latency and x$user_summary_by_statement_latency Views">
         <code class="literal">
          user_summary_by_statement_latency
         </code>
         ,
         <code class="literal">
          x$user_summary_by_statement_latency
         </code>
        </a>
       </th>
       <td>
        Statement statistics, grouped by user
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-user-summary-by-statement-type.html" title="30.4.3.46 The user_summary_by_statement_type and x$user_summary_by_statement_type Views">
         <code class="literal">
          user_summary_by_statement_type
         </code>
         ,
         <code class="literal">
          x$user_summary_by_statement_type
         </code>
        </a>
       </th>
       <td>
        Statements executed, grouped by user and statement
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-version.html" title="30.4.3.47 The version View">
         <code class="literal">
          version
         </code>
        </a>
       </th>
       <td>
        Current sys schema and MySQL server versions
       </td>
       <td>
        Yes
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-wait-classes-global-by-avg-latency.html" title="30.4.3.48 The wait_classes_global_by_avg_latency and x$wait_classes_global_by_avg_latency Views">
         <code class="literal">
          wait_classes_global_by_avg_latency
         </code>
         ,
         <code class="literal">
          x$wait_classes_global_by_avg_latency
         </code>
        </a>
       </th>
       <td>
        Wait class average latency, grouped by event class
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-wait-classes-global-by-latency.html" title="30.4.3.49 The wait_classes_global_by_latency and x$wait_classes_global_by_latency Views">
         <code class="literal">
          wait_classes_global_by_latency
         </code>
         ,
         <code class="literal">
          x$wait_classes_global_by_latency
         </code>
        </a>
       </th>
       <td>
        Wait class total latency, grouped by event class
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-waits-by-host-by-latency.html" title="30.4.3.50 The waits_by_host_by_latency and x$waits_by_host_by_latency Views">
         <code class="literal">
          waits_by_host_by_latency
         </code>
         ,
         <code class="literal">
          x$waits_by_host_by_latency
         </code>
        </a>
       </th>
       <td>
        Wait events, grouped by host and event
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-waits-by-user-by-latency.html" title="30.4.3.51 The waits_by_user_by_latency and x$waits_by_user_by_latency Views">
         <code class="literal">
          waits_by_user_by_latency
         </code>
         ,
         <code class="literal">
          x$waits_by_user_by_latency
         </code>
        </a>
       </th>
       <td>
        Wait events, grouped by user and event
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-waits-global-by-latency.html" title="30.4.3.52 The waits_global_by_latency and x$waits_global_by_latency Views">
         <code class="literal">
          waits_global_by_latency
         </code>
         ,
         <code class="literal">
          x$waits_global_by_latency
         </code>
        </a>
       </th>
       <td>
        Wait events, grouped by event
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-statements-with-runtimes-in-95th-percentile.html" title="30.4.3.38 The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile Views">
         <code class="literal">
          x$ps_digest_95th_percentile_by_avg_us
         </code>
        </a>
       </th>
       <td>
        Helper view for 95th-percentile views
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-statements-with-runtimes-in-95th-percentile.html" title="30.4.3.38 The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile Views">
         <code class="literal">
          x$ps_digest_avg_latency_distribution
         </code>
        </a>
       </th>
       <td>
        Helper view for 95th-percentile views
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-schema-table-statistics.html" title="30.4.3.29 The schema_table_statistics and x$schema_table_statistics Views">
         <code class="literal">
          x$ps_schema_table_statistics_io
         </code>
        </a>
       </th>
       <td>
        Helper view for table-statistics views
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-schema-redundant-indexes.html" title="30.4.3.27 The schema_redundant_indexes and x$schema_flattened_keys Views">
         <code class="literal">
          x$schema_flattened_keys
         </code>
        </a>
       </th>
       <td>
        Helper view for schema_redundant_indexes
       </td>
       <td>
       </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 style="width: 372.641px;">
        View Name
       </th>
       <th style="width: 276.203px;">
        Description
       </th>
       <th style="width: 89.1562px;">
        Deprecated
       </th>
      </tr>
     </thead>
    </table>
   </div>
  </div>
  <br class="table-break"/>
  <div class="table">
   <a name="sys-schema-procedures-table">
   </a>
   <p class="title">
    <b>
     Table 30.3 sys Schema Stored Procedures
    </b>
   </p>
   <div class="table-contents">
    <table frame="box" rules="all" summary="Stored procedures used in the sys schema implementation.">
     <colgroup>
      <col style="width: 28%"/>
      <col style="width: 71%"/>
     </colgroup>
     <thead>
      <tr>
       <th>
        Procedure Name
       </th>
       <th>
        Description
       </th>
      </tr>
     </thead>
     <tbody>
      <tr>
       <td>
        <a class="link" href="sys-create-synonym-db.html" title="30.4.4.1 The create_synonym_db() Procedure">
         <code class="literal">
          create_synonym_db()
         </code>
        </a>
       </td>
       <td>
        Create synonym for schema
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-diagnostics.html" title="30.4.4.2 The diagnostics() Procedure">
         <code class="literal">
          diagnostics()
         </code>
        </a>
       </td>
       <td>
        Collect system diagnostic information
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-execute-prepared-stmt.html" title="30.4.4.3 The execute_prepared_stmt() Procedure">
         <code class="literal">
          execute_prepared_stmt()
         </code>
        </a>
       </td>
       <td>
        Execute prepared statement
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-setup-disable-background-threads.html" title="30.4.4.4 The ps_setup_disable_background_threads() Procedure">
         <code class="literal">
          ps_setup_disable_background_threads()
         </code>
        </a>
       </td>
       <td>
        Disable background thread instrumentation
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-setup-disable-consumer.html" title="30.4.4.5 The ps_setup_disable_consumer() Procedure">
         <code class="literal">
          ps_setup_disable_consumer()
         </code>
        </a>
       </td>
       <td>
        Disable consumers
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-setup-disable-instrument.html" title="30.4.4.6 The ps_setup_disable_instrument() Procedure">
         <code class="literal">
          ps_setup_disable_instrument()
         </code>
        </a>
       </td>
       <td>
        Disable instruments
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-setup-disable-thread.html" title="30.4.4.7 The ps_setup_disable_thread() Procedure">
         <code class="literal">
          ps_setup_disable_thread()
         </code>
        </a>
       </td>
       <td>
        Disable instrumentation for thread
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-setup-enable-background-threads.html" title="30.4.4.8 The ps_setup_enable_background_threads() Procedure">
         <code class="literal">
          ps_setup_enable_background_threads()
         </code>
        </a>
       </td>
       <td>
        Enable background thread instrumentation
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-setup-enable-consumer.html" title="30.4.4.9 The ps_setup_enable_consumer() Procedure">
         <code class="literal">
          ps_setup_enable_consumer()
         </code>
        </a>
       </td>
       <td>
        Enable consumers
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-setup-enable-instrument.html" title="30.4.4.10 The ps_setup_enable_instrument() Procedure">
         <code class="literal">
          ps_setup_enable_instrument()
         </code>
        </a>
       </td>
       <td>
        Enable instruments
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-setup-enable-thread.html" title="30.4.4.11 The ps_setup_enable_thread() Procedure">
         <code class="literal">
          ps_setup_enable_thread()
         </code>
        </a>
       </td>
       <td>
        Enable instrumentation for thread
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-setup-reload-saved.html" title="30.4.4.12 The ps_setup_reload_saved() Procedure">
         <code class="literal">
          ps_setup_reload_saved()
         </code>
        </a>
       </td>
       <td>
        Reload saved Performance Schema configuration
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-setup-reset-to-default.html" title="30.4.4.13 The ps_setup_reset_to_default() Procedure">
         <code class="literal">
          ps_setup_reset_to_default()
         </code>
        </a>
       </td>
       <td>
        Reset saved Performance Schema configuration
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-setup-save.html" title="30.4.4.14 The ps_setup_save() Procedure">
         <code class="literal">
          ps_setup_save()
         </code>
        </a>
       </td>
       <td>
        Save Performance Schema configuration
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-setup-show-disabled.html" title="30.4.4.15 The ps_setup_show_disabled() Procedure">
         <code class="literal">
          ps_setup_show_disabled()
         </code>
        </a>
       </td>
       <td>
        Display disabled Performance Schema configuration
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-setup-show-disabled-consumers.html" title="30.4.4.16 The ps_setup_show_disabled_consumers() Procedure">
         <code class="literal">
          ps_setup_show_disabled_consumers()
         </code>
        </a>
       </td>
       <td>
        Display disabled Performance Schema consumers
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-setup-show-disabled-instruments.html" title="30.4.4.17 The ps_setup_show_disabled_instruments() Procedure">
         <code class="literal">
          ps_setup_show_disabled_instruments()
         </code>
        </a>
       </td>
       <td>
        Display disabled Performance Schema instruments
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-setup-show-enabled.html" title="30.4.4.18 The ps_setup_show_enabled() Procedure">
         <code class="literal">
          ps_setup_show_enabled()
         </code>
        </a>
       </td>
       <td>
        Display enabled Performance Schema configuration
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-setup-show-enabled-consumers.html" title="30.4.4.19 The ps_setup_show_enabled_consumers() Procedure">
         <code class="literal">
          ps_setup_show_enabled_consumers()
         </code>
        </a>
       </td>
       <td>
        Display enabled Performance Schema consumers
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-setup-show-enabled-instruments.html" title="30.4.4.20 The ps_setup_show_enabled_instruments() Procedure">
         <code class="literal">
          ps_setup_show_enabled_instruments()
         </code>
        </a>
       </td>
       <td>
        Display enabled Performance Schema instruments
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-statement-avg-latency-histogram.html" title="30.4.4.21 The ps_statement_avg_latency_histogram() Procedure">
         <code class="literal">
          ps_statement_avg_latency_histogram()
         </code>
        </a>
       </td>
       <td>
        Display statement latency histogram
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-trace-statement-digest.html" title="30.4.4.22 The ps_trace_statement_digest() Procedure">
         <code class="literal">
          ps_trace_statement_digest()
         </code>
        </a>
       </td>
       <td>
        Trace Performance Schema instrumentation for digest
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-trace-thread.html" title="30.4.4.23 The ps_trace_thread() Procedure">
         <code class="literal">
          ps_trace_thread()
         </code>
        </a>
       </td>
       <td>
        Dump Performance Schema data for thread
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-ps-truncate-all-tables.html" title="30.4.4.24 The ps_truncate_all_tables() Procedure">
         <code class="literal">
          ps_truncate_all_tables()
         </code>
        </a>
       </td>
       <td>
        Truncate Performance Schema summary tables
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-statement-performance-analyzer.html" title="30.4.4.25 The statement_performance_analyzer() Procedure">
         <code class="literal">
          statement_performance_analyzer()
         </code>
        </a>
       </td>
       <td>
        Report of statements running on server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="sys-table-exists.html" title="30.4.4.26 The table_exists() Procedure">
         <code class="literal">
          table_exists()
         </code>
        </a>
       </td>
       <td>
        Whether a table exists
       </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 style="width: 307.641px;">
        Procedure Name
       </th>
       <th style="width: 430.359px;">
        Description
       </th>
      </tr>
     </thead>
    </table>
   </div>
  </div>
  <br class="table-break"/>
  <div class="table">
   <a name="sys-schema-functions-table">
   </a>
   <p class="title">
    <b>
     Table 30.4 sys Schema Stored Functions
    </b>
   </p>
   <div class="table-contents">
    <table frame="box" rules="all" summary="Stored functions used in the sys schema implementation.">
     <colgroup>
      <col style="width: 25%"/>
      <col style="width: 62%"/>
      <col style="width: 12%"/>
     </colgroup>
     <thead>
      <tr>
       <th>
        Function Name
       </th>
       <th>
        Description
       </th>
       <th>
        Deprecated
       </th>
      </tr>
     </thead>
     <tbody>
      <tr>
       <th scope="row">
        <a class="link" href="sys-extract-schema-from-file-name.html" title="30.4.5.1 The extract_schema_from_file_name() Function">
         <code class="literal">
          extract_schema_from_file_name()
         </code>
        </a>
       </th>
       <td>
        Extract schema name part of file name
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-extract-table-from-file-name.html" title="30.4.5.2 The extract_table_from_file_name() Function">
         <code class="literal">
          extract_table_from_file_name()
         </code>
        </a>
       </th>
       <td>
        Extract table name part of file name
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-format-bytes.html" title="30.4.5.3 The format_bytes() Function">
         <code class="literal">
          format_bytes()
         </code>
        </a>
       </th>
       <td>
        Convert byte count to value with units
       </td>
       <td>
        Yes
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-format-path.html" title="30.4.5.4 The format_path() Function">
         <code class="literal">
          format_path()
         </code>
        </a>
       </th>
       <td>
        Replace directories in path name with symbolic system variable names
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-format-statement.html" title="30.4.5.5 The format_statement() Function">
         <code class="literal">
          format_statement()
         </code>
        </a>
       </th>
       <td>
        Truncate long statement to fixed length
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-format-time.html" title="30.4.5.6 The format_time() Function">
         <code class="literal">
          format_time()
         </code>
        </a>
       </th>
       <td>
        Convert picoseconds time to value with units
       </td>
       <td>
        Yes
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-list-add.html" title="30.4.5.7 The list_add() Function">
         <code class="literal">
          list_add()
         </code>
        </a>
       </th>
       <td>
        Add item to list
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-list-drop.html" title="30.4.5.8 The list_drop() Function">
         <code class="literal">
          list_drop()
         </code>
        </a>
       </th>
       <td>
        Remove item from list
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-ps-is-account-enabled.html" title="30.4.5.9 The ps_is_account_enabled() Function">
         <code class="literal">
          ps_is_account_enabled()
         </code>
        </a>
       </th>
       <td>
        Whether Performance Schema instrumentation for account is enabled
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-ps-is-consumer-enabled.html" title="30.4.5.10 The ps_is_consumer_enabled() Function">
         <code class="literal">
          ps_is_consumer_enabled()
         </code>
        </a>
       </th>
       <td>
        Whether Performance Schema consumer is enabled
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-ps-is-instrument-default-enabled.html" title="30.4.5.11 The ps_is_instrument_default_enabled() Function">
         <code class="literal">
          ps_is_instrument_default_enabled()
         </code>
        </a>
       </th>
       <td>
        Whether Performance Schema instrument is enabled by default
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-ps-is-instrument-default-timed.html" title="30.4.5.12 The ps_is_instrument_default_timed() Function">
         <code class="literal">
          ps_is_instrument_default_timed()
         </code>
        </a>
       </th>
       <td>
        Whether Performance Schema instrument is timed by default
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-ps-is-thread-instrumented.html" title="30.4.5.13 The ps_is_thread_instrumented() Function">
         <code class="literal">
          ps_is_thread_instrumented()
         </code>
        </a>
       </th>
       <td>
        Whether Performance Schema instrumentation for connection ID is enabled
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-ps-thread-account.html" title="30.4.5.14 The ps_thread_account() Function">
         <code class="literal">
          ps_thread_account()
         </code>
        </a>
       </th>
       <td>
        Account associated with Performance Schema thread ID
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-ps-thread-id.html" title="30.4.5.15 The ps_thread_id() Function">
         <code class="literal">
          ps_thread_id()
         </code>
        </a>
       </th>
       <td>
        Performance Schema thread ID associated with connection ID
       </td>
       <td>
        Yes
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-ps-thread-stack.html" title="30.4.5.16 The ps_thread_stack() Function">
         <code class="literal">
          ps_thread_stack()
         </code>
        </a>
       </th>
       <td>
        Event information for connection ID
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-ps-thread-trx-info.html" title="30.4.5.17 The ps_thread_trx_info() Function">
         <code class="literal">
          ps_thread_trx_info()
         </code>
        </a>
       </th>
       <td>
        Transaction information for thread ID
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-quote-identifier.html" title="30.4.5.18 The quote_identifier() Function">
         <code class="literal">
          quote_identifier()
         </code>
        </a>
       </th>
       <td>
        Quote string as identifier
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-sys-get-config.html" title="30.4.5.19 The sys_get_config() Function">
         <code class="literal">
          sys_get_config()
         </code>
        </a>
       </th>
       <td>
        sys schema configuration option value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-version-major.html" title="30.4.5.20 The version_major() Function">
         <code class="literal">
          version_major()
         </code>
        </a>
       </th>
       <td>
        MySQL server major version number
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-version-minor.html" title="30.4.5.21 The version_minor() Function">
         <code class="literal">
          version_minor()
         </code>
        </a>
       </th>
       <td>
        MySQL server minor version number
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="sys-version-patch.html" title="30.4.5.22 The version_patch() Function">
         <code class="literal">
          version_patch()
         </code>
        </a>
       </th>
       <td>
        MySQL server patch release version number
       </td>
       <td>
       </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 style="width: 283.266px;">
        Function Name
       </th>
       <th style="width: 365.578px;">
        Description
       </th>
       <th style="width: 89.1562px;">
        Deprecated
       </th>
      </tr>
     </thead>
    </table>
   </div>
  </div>
  <br class="table-break"/>
 </div>
 <br/>
</div>
