Percona Server with XtraDB

[DOC] Clarify temporary tables

Reported by Baron Schwartz on 2012-03-07
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
Undecided
Hrvoje Matijakovic
5.1
Undecided
Hrvoje Matijakovic
5.5
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

lp:~hrvojem/percona-server/bug930571-5.1
Merged into lp:percona-server/5.1 at revision 432
Stewart Smith (community): Approve on 2012-04-02
Alexey Kopytov: Pending requested 2012-03-27
Changed in percona-server:
status: New → Fix Committed
Alexey Kopytov (akopytov) wrote :

It also shows internal temporary tables created by ALTER TABLE.

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

Other bug subscribers