Not the answer you need?
Register and ask your own question!

The temporary table has problem

meolep92meolep92 EntrantCurrent User Role Novice
i use percona server ,when i check information_schema.global_temporary_table and temporary_table,i find nothing,but i can observe a lot of temp table from my temp dir

# ls /data/mysql_tmp_no_del/
#sql_196c_1.MYD #sql_196c_1.MYI #sql_196c_5.MYD #sql_196c_5.MYI #sql_196c_6.MYD #sql_196c_6.MYI #sql_196c_7.MYD #sql_196c_7.MYI #sql_196c_8.MYD #sql_196c_8.MYI

mysql> show temporary tables;
Empty set (0.00 sec)

mysql> show temporary tables;
Empty set (0.00 sec)

mysql> show global temporary tables;
Empty set (0.00 sec)

mysql> select version();
+
+
| version() |
+
+
| 5.5.20-55-log |
+
+
1 row in set (0.00 sec)


mysql> use information_schema;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from GLOBAL_TEMPORARY_TABLES\G
Empty set (0.00 sec)

mysql> select * from TEMPORARY_TABLES\G
Empty set (0.00 sec)

Lee!
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.