Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-5041

TempTable engine temp tables bump Tmp_disk_tables slow log counter?

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 8.0.x, Not 5.5.x, Not 5.6.x, Not 5.7.x
    • Fix Version/s: 8.0.13-3
    • Component/s: None
    • Labels:

      Description

      By code review, in sql_tmp_table.cc:free_tmp_table:

          if (entry->file->ht->db_type != DB_TYPE_HEAP) thd->tmp_tables_disk_used++;
      

      Since there is no

      && ... db_type != DB_TYPE_TEMPTABLE

      , it is likely that TempTable temp tables are incorrectly counted as disk-based ones in the extended slow query log.

        Attachments

          Activity

            People

            Assignee:
            laurynas.biveinis Laurynas Biveinis (Inactive)
            Reporter:
            laurynas.biveinis Laurynas Biveinis (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist