Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  / ...  / MySQL sys Schema  / sys Schema Object Reference  / sys Schema Views  /  The statements_with_temp_tables and x$statements_with_temp_tables Views

26.4.3.40 The statements_with_temp_tables and x$statements_with_temp_tables Views

These views list normalized statements that have used temporary tables. By default, rows are sorted by descending number of on-disk temporary tables used and descending number of in-memory temporary tables used.

Thestatements_with_temp_tables andx$statements_with_temp_tables views have these columns:

  • query

    The normalized statement string.

  • db

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

  • exec_count

    The total number of times the statement has executed.

  • total_latency

    The total wait time of timed occurrences of the statement.

  • memory_tmp_tables

    The total number of internal in-memory temporary tables created by occurrences of the statement.

  • disk_tmp_tables

    The total number of internal on-disk temporary tables created by occurrences of the statement.

  • avg_tmp_tables_per_query

    The average number of internal temporary tables created per occurrence of the statement.

  • tmp_tables_to_disk_pct

    The percentage of internal in-memory temporary tables that were converted to on-disk tables.

  • 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.