[DOC] Clarify temporary tables

Bug #949030 reported by Baron Schwartz
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

Related branches

Changed in percona-server:
status: New → Fix Committed
Revision history for this message
Alexey Kopytov (akopytov) wrote :

It also shows internal temporary tables created by ALTER TABLE.

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.