Shulou(Shulou.com)06/01 Report--

This article mainly introduces what the temporary table in mysql refers to, which has certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

Temporary tables are tables that MySQL uses to store some intermediate result sets. Temporary tables are only visible in the current connection. When the connection is closed, Mysql automatically deletes the table and frees up all space. Why is there a temporary watch? It is generally due to complex SQL that temporary tables are created in large numbers.

Temporary tables are added in version 3.23 of MySQL. If you have a version of MySQL earlier than version 3.23, you cannot use temporary tables of MySQL. However, it is rare to use such a low version of the MySQL database service these days.

There are two kinds of temporary tables, one is memory temporary table, the other is disk temporary table. The memory temporary table uses the memory storage engine, and the disk temporary table uses the myisam storage engine (the disk temporary table can also use the innodb storage engine, which is controlled by the internal_tmp_disk_storage_engine parameter. It defaults to the innodb storage engine after mysql5.7.6, while the previous version defaults to the myisam storage engine). Use the parameters Created_tmp_disk_tables and Created_tmp_tables to see how many disk temporary tables and all generated temporary tables (memory and disk) have been generated.

Thank you for reading this article carefully. I hope the editor can share what the temporary table in mysql refers to is helpful to everyone. At the same time, I also hope you can support us, pay attention to the industry information channel, and find out if you have any problems. Detailed solutions are waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.