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

This article will explain in detail the method of configuring MySQL parameter tmp_table_size for you. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

The method of MySQL configuration parameter [tmp_table_size]: first check [tmp_table_size]; then set [tmp_table_size]; finally, add [tmp_table_size] under mysqld in the MySQL configuration file [my.cnf].

Memory cache size of tmp_table_size temporary table

Temporary table means that temporary data table is generated when sql executes

# tmp_table_size default value 16777216 minimum value 1 maximum value 18446744073709551615 / / default value per byte is more than 16m

View tmp_table_size

Show global variables like 'tmp_table_size'

Set up tmp_table_size

Set global tmp_table_size= 2048; (effective immediately and expire after restart)

Add tmp_table_size under mysqld in MySQL configuration file my.cnf

[mysqld]

Tmp_table_size = 100000000

Be careful

The max_heap_table_size parameter in MySQL affects the memory cache size of temporary tables.

Max_heap_table_size is the table size of the MEMORY memory engine, because temporary tables also belong to memory tables, so they are also limited by this parameter, so if you want to increase the size of tmp_table_size, you need to increase the size of max_heap_table_size at the same time.

You can analyze whether you need to add tmp_table_size by Created_tmp_disk_tables and Created_tmp_tables status

View statu

Show global status like 'Created_tmp_disk_tables';show global status like' Created_tmp_tables';Created_tmp_disk_tables: number of disk temporary tables Created_tmp_tables: number of memory temporary tables this is the way to share the MySQL configuration parameter tmp_table_size. I hope the above content can be helpful to you and you can learn more. If you think the article is good, you can share it for more people to see.

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.