Bug #33274 No way to report temporary tables.
Submitted: 16 Dec 2007 19:12 Modified: 4 Oct 2008 20:53
Reporter: Morgan Tocker Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: Information schema Severity:S4 (Feature request)
Version:5.0 OS:Any
Assigned to: CPU Architecture:Any

[16 Dec 2007 19:12] Morgan Tocker
Can't see what temporary tables are used by the current connection.

How to repeat:
mysql> use test;
Database changed
mysql> create temporary table a (a int);
Query OK, 0 rows affected (0.00 sec)

mysql> select * from information_schema.tables where TABLE_SCHEMA='test';
Empty set (0.00 sec)

mysql> show tables;
Empty set (0.00 sec)

Suggested fix:
This limits what connection pooling you can do, since you can't guarantee objects will be freed.
[1 Oct 2008 20:20] MySQL Verification Team
I would also like to add that the temporary tables of any one connection should be queriable from any other session. This would allow an administrator to login under one session and use this report to diagnose temporary table usage for all sessions or any specific session.
[4 Oct 2008 20:53] Konstantin Osipov
Duplicate of Bug#20001 Support for temp-tables in INFORMATION_SCHEMA