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

LP #949030: [DOC] Clarify temporary tables

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Documentation
    • Labels:

      Description

      **Reported in Launchpad by Baron Schwartz last update 02-04-2012 09:39:07

      http://www.percona.com/doc/percona-server/5.5/diagnostics/misc_info_schema_tables.html#GLOBAL_TEMPORARY_TABLES does not mention what kind of temporary tables are shown. Apparently the I_S table only shows explicitly created tables, those created with CREATE TEMPORARY TABLE. Users may be confused by this and think that it should show temporary tables that are created to process complex queries. (Is it possible to show such tables? It would be helpful.)

      See http://forum.percona.com/index.php?t=rview&goto=8048&th=2132#msg_8048 for example.

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: