[DOC] Clarify temporary tables

Bug #949030 reported by Baron Schwartz on 2012-03-07
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Undecided
Hrvoje Matijakovic
5.1
Fix Released
Undecided
Hrvoje Matijakovic
5.5
Fix Released
Undecided
Hrvoje Matijakovic

Bug Description

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.

Tags: doc Edit Tag help

Related branches

Changed in percona-server:
status: New → Fix Committed
Alexey Kopytov (akopytov) wrote :

It also shows internal temporary tables created by ALTER TABLE.

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2735

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers