Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 38.5Mb
PDF (A4) - 38.5Mb
PDF (RPM) - 33.3Mb
HTML Download (TGZ) - 8.1Mb
HTML Download (Zip) - 8.2Mb
HTML Download (RPM) - 7.0Mb
Man Pages (TGZ) - 134.2Kb
Man Pages (Zip) - 190.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  ...  /  The schema_index_statistics and x$schema_index_statistics Views The schema_index_statistics and x$schema_index_statistics Views

These views provide index statistics. By default, rows are sorted by descending total index latency.

The schema_index_statistics and x$schema_index_statistics views have these columns:

  • table_schema

    The schema that contains the table.

  • table_name

    The table that contains the index.

  • index_name

    The name of the index.

  • rows_selected

    The total number of rows read using the index.

  • select_latency

    The total wait time of timed reads using the index.

  • rows_inserted

    The total number of rows inserted into the index.

  • insert_latency

    The total wait time of timed inserts into the index.

  • rows_updated

    The total number of rows updated in the index.

  • update_latency

    The total wait time of timed updates in the index.

  • rows_deleted

    The total number of rows deleted from the index.

  • delete_latency

    The total wait time of timed deletes from the index.

User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.