No cache version.


Caching disabled. Default setting for this page:enabled (code DEF204)
If the display is too slow, you can disable the user mode to view the cached version.

Rechercher dans le manuel MySQL

27.4.3.37 The statements_with_full_table_scans and x$statements_with_full_table_scans Views

These views display normalized statements that have done full table scans. By default, rows are sorted by descending percentage of time a full scan was done and descending total latency.

The statements_with_full_table_scans and x$statements_with_full_table_scans views have these columns:

  • query

    The normalized statement string.

  • db

    The default database for the statement, or NULL if there is none.

  • exec_count

    The total number of times the statement has executed.

  • total_latency

    The total wait time of timed statement events for the statement.

  • no_index_used_count

    The total number of times no index was used to scan the table.

  • no_good_index_used_count

    The total number of times no good index was used to scan the table.

  • no_index_used_pct

    The percentage of the time no index was used to scan the table.

  • rows_sent

    The total number of rows returned from the table.

  • rows_examined

    The total number of rows read from the storage engine for the table.

  • rows_sent_avg

    The average number of rows returned from the table.

  • rows_examined_avg

    The average number of rows read from the storage engine for the table.

  • first_seen

    The time at which the statement was first seen.

  • last_seen

    The time at which the statement was most recently seen.

  • digest

    The statement digest.


Find a PHP function

Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-sys-statements-with-full-table-scans.html

The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.

References

  1. View the html document Language of the document:en Manuel MySQL : https://dev.mysql.com/

These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.

Contents Haut